Question

Status:Closed    Asked:Oct 03, 2018 - 04:40 PM

How do I download my data extract into excel?

I compressed my data file and attempeted to download the file into excel, however, was not able to download. What exact steps should I be taking in order to downlowd this data into an exel spreadsheet?

 
Do you have the same question? Follow this Question
 

Staff Answer

avatar

Jeff Bloem

Staff

Before submitting your data extract on the "Extract Request" page, click the "Change" button on the "Data Format" option line. This will give you several different data format options, the default being a fixed-width data file. If you select the .csv option, your data extract will be delivered to you as a .csv file and be able to be opened in Excel. We also have an online video tutorial that walks through these steps.


One limitation of Excel to be aware of is the row limit set at 1,048,576 rows. For some IPUMS data files this can be quite restrictive.

 

Oct 04, 2018 - 09:32 AM

0
0
Report it

OTHER QUESTIONS NEEDING ANSWERS

Can I download the data to Excel?
Fail to download data
On the dowload/extract page there is no option for me to download the formatt...
How can I get my data file to download to my computer using R? Currently an ...
Login   |   Register

Recently Active Members

View More »

Share |