Status:Closed    Asked:Mar 15, 2018 - 04:43 PM

.CVS format data uploaded into EXCEL


I am very new to IPUMS and am having difficulty loading a .CVS.GZ file into EXCEL. Do you have any idea what I might be doing wrong? Data is in non-alpha numeric char. all in one column.

Thanks for any assistance!

Do you have the same question? Follow this Question

Staff Answer

Zipped files (i.e. files that end in .GZ such as your csv extract) need to be decompressed first. As described here, if you're on a PC, you'll need a decompression software such as 7zip.

Once you've extracted the data file, you should be able to open it in Excel. However, just be aware that Excel does have a row limit, so depending on the size of your extract, you may exceed it and not have the full set of data.


Mar 19, 2018 - 08:15 AM

Report it


Data downloaded in Excel format?
Why are not all the "not in the labour force" categories filled for the EMPST...
I having difficulty down loading the CSV formatted data into EXCEL. Any sugge...
Health Insurance Unit in ACS versus MEPS
Login   |   Register

Recently Active Members

View More »

Share |