Limitations of Excel and CSV Downloads


Cell Character Limits and Limits on Numbers of Rows


When downloading data off of Socrata, one of the most common tools used for analyzing the data is Microsoft Excel. Both .xlsx and .csv files have a limit of
32,767 characters per cell.  Excel has a limit of   1,048,576 rows and 16,384 columns per sheet. CSV files can hold many more rows. You can read more about these limits and others here.

However, Socrata datasets sometimes will contain parameters that exceed these limits. In the case that a cell exceeds the limit, Excel wraps the text down to a new line rather than losing the data. This can make it appear that the download of your data is corrupted. Rows beyond 1,048,576 will not be displayed, making the download appear incomplete.

In these cases, it is recommended that you open the file using a text editor or another program (such as Sublime Text or Notepad++) that does not have the limits. Another option is to filter the dataset before downloading to select the rows you are interested in.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Article is closed for comments.