Link to home
Start Free TrialLog in
Avatar of "Abys" Wallace
"Abys" WallaceFlag for United States of America

asked on

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?

Avatar of Alan
Flag of New Zealand image

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!

This is one option
Convert XLS To CSV Files - Command Line Able

This too
Convert XLS to CSV on command line

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.
Avatar of "Abys" Wallace


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.

User generated image
Also, I'm using a Macbook Pro ... I don't have access to Notepad.
I may be able to convert the data for you.

How do I select an entire state, I can click on a county (I'm from Australia so hope this is the corect name)
Thank you!   Yes, it's tricky getting the entire state.  To do so, you have to click along the state's border.
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?

User generated image
If this isnt the correct data set how big is the excel download you have? (Kbytes/Mbytes/Gbytes)
Yes, that's the correct dataset
Avatar of mbkitmgr
Flag of Australia image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you @mbkitmgr!