Excel file over 1 million rows to .csv without opening
Hey Experts,
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?
Thanks
Abys
Microsoft ExcelMicrosoft Office
Last Comment
"Abys" Wallace
8/22/2022 - Mon
Alan
Is there no way to obtain the dataset in CSV or something similar?
I would hope that most government date would be available that way, but call me naive!
There may also be an option to install MS SQL Express, import the data from Excel then export, though I havent tried this it would require some experimentation.
"Abys" Wallace
ASKER
I'm retrieving the datasets from the Census Hard To Count site for the state of Virginia and the Tract data is in Excel format. https://www.censushardtocountmaps2020.us/
I want to make sure I have the correct data set. Below is a screen capture, does the file size look correct and does the display of the excel data look correct?
mbkitmgr
If this isnt the correct data set how big is the excel download you have? (Kbytes/Mbytes/Gbytes)
I would hope that most government date would be available that way, but call me naive!
Alan.