.CVS format data uploaded into EXCEL

#1

Hello,

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!

#2

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.