.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!

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.