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


when trying to declare the IPUMS data as panel on stata there are repeated ti...
2010 5-year PUMA definition
Where can I find city populations, by age, San Diego, New Orleans, Atlanta, C...
Hi, it has been over 4 hours for my data extract and I was wondering if there...
When I take several Nov Supplements, the weighted number of voters equals pub...
Are there aggregate categories for OCC/OCCLY in CPS?
Login   |   Register

Recently Active Members

View More »

Share |