Status:Closed    Asked:Mar 06, 2014 - 01:27 PM

Could I get the 2000PUMAsASCII.txt file in excel format?

For my research project, I need to calculate the pouplation by city and county. For this purpose I am using the 2000PUMAsACSII.txt. However, when I try to import the txt file into stata (or excel) some columns are combined and I cannot identify the variables anymore. I already used different formats (tab, space, semicolon delimit) but nothing is working. Is it possible to obtain the file in excel format?

Thank you very much

Do you have the same question? Follow this Question

Staff Answer




Unfortunately, I cannot provide the excel document here because the file is to large to link. Instead I have attached a text file with the 2000PUMAs data in tab delimited form. Copying all of the contents of the file should paste nicely into excel. You will still need the original text file for the explanation and column headers.

I hope this helps.


Mar 06, 2014 - 03:12 PM

Report it


Thank you for the file.

It works now!


Mar 10, 2014 - 04:31 PM

Report it


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?
Do you have any idea when STEPMOM and STEPDAD will be available for usage? Th...
Comparing 2015 ASEC CPS IPUMS with Census data and Table Creator, I note diff...
Login   |   Register

Recently Active Members

View More »

Share |