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

Thanks
Abys
Microsoft ExcelMicrosoft Office

Avatar of undefined
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!

Alan.
mbkitmgr

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.
"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/

Screenshot-2020-01-31-18.05.35.png
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
"Abys" Wallace

ASKER
Also, I'm using a Macbook Pro ... I don't have access to Notepad.
mbkitmgr

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)
"Abys" Wallace

ASKER
Thank you!   Yes, it's tricky getting the entire state.  To do so, you have to click along the state's border.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
mbkitmgr

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?

Capture.JPG
mbkitmgr

If this isnt the correct data set how big is the excel download you have? (Kbytes/Mbytes/Gbytes)
"Abys" Wallace

ASKER
Yes, that's the correct dataset
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
ASKER CERTIFIED SOLUTION
mbkitmgr

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
"Abys" Wallace

ASKER
Thank you @mbkitmgr!