Question

Status:Closed    Asked:Mar 15, 2018 - 12:00 PM

I having difficulty down loading the CSV formatted data into EXCEL. Any suggestions?

When I upload the CSV formatted data into EXCEL I get non alpha charactures in a single column. What is the best way to upload data into EXCEL?



 
Do you have the same question? Follow this Question
 

Staff Answer

avatar

Joe_Grover

Staff

The issue may be that your data extract includes more records (meaning rows) then Excel is able to hold in on spreadsheet. There are a number of ways to limit the size of your data extract. Since your particular issue is that there are too many records I would recommend using either the select cases feature or the custom sample size feature.

 

Mar 15, 2018 - 03:23 PM

0
0
Report it

OTHER QUESTIONS NEEDING ANSWERS

In 2012 ACS data, why am I getting breaks where all variables have 000?
Data downloaded in Excel format?
.CVS format data uploaded into EXCEL
Is there an excel version of the INDNAICS cross walk ( https://usa.ipums.org/...
Login   |   Register

Recently Active Members

View More »

Share |