Question

Status:Closed    Asked:May 19, 2016 - 07:41 AM

How to change the strange encoding that appears when we ask for a csv document ?

on IPUMS International, when I try to extract datas, I use the .csv format, but how to open it with a spreadsheet program, like Excel for instance and see the real numbers, and no "‹*¯=W ipumsi_00004.csv ¤ýËŽ-K¶%‰õùÙÎÆq_þlŠ‰z!Y ²Züÿ¿àÎ}a...."

 
Do you have the same question? Follow this Question
 

Staff Answer

avatar

Tim_Moreland

Staff

This issue can occur if you attempt to open the zipped version of the data extract in Excel. You can find instructions for decompressing the zipped data file here.


Hope this helps.

 

May 19, 2016 - 03:41 PM

0
0
Report it

OTHER QUESTIONS NEEDING ANSWERS

USA IPUMS 1980 ancestry variable -- mapping to country names
Did the version of database change since 2011?
Are DATANUM, SERIAL, and PERNUM the same in single-year and 5-year ACS sample...
How can I accurately calculate the median family income by state for families...
Detailed Variables Dropping From Dataset
Are weights adjusted when using "select cases" in an extraction?
Login   |   Register


Share |