Status:Closed    Asked:Feb 24, 2014 - 01:58 PM

How do you get the information codes in excel to show the actual information?

I know how to download the data into an excel file, but it still only shows up as codes corresponding to different information. Is there a way of translating the codes into what the data is?

Do you have the same question? Follow this Question

Staff Answer




I am not aware of a method for applying labels to data within Excel. Using the codebook that is generated with your extract, you can apply labels to tables and figures by simply replacing the numeric value with the appropriate label. You may try searching excel user forums for tips on applying value labels to numeric data. For the most part however, editing cell values is not recommend as this could unintentionally alter values. It may be best to apply labels to resulting figures.

I hope this helps.


Feb 24, 2014 - 03:56 PM

Report it


I am looking for the Kessler 6 variable in IPUMS-MEPS
Reason for missing MIGSTA1 values in ASEC files for 1985 (and 1995)
India Area-level data (geo2) inconsistent for total population, urban share, ...
Does anyone have a method for handling missing data in CPS "EDUC" variable? 2...
How do I find the data file:Ipumsi_00001.dat for the 1974
Variables from Full Year Consolidated Files currently not included in IPUMS-M...
Login   |   Register

Recently Active Members

View More »

Share |