I'm working with Census datasets with over 1 million rows. The datasets are in Excel format. I need to convert from Excel to .csv so I can work with them using MySQL.
I do not want to open the Excel file and do a Save As because when I do it ruins the data beyond 1 million rows. How can I convert from Excel to .csv without having to open the Excel file?