search

DataUSA / datausa-site

The most comprehensive visualization of U.S. public data —
www.datausa.io
GNU Affero General Public License v3.0
97 stars 28 forks source link

CSV doesn't create properly #528

Closed danielbyler closed 7 years ago

danielbyler commented 7 years ago

When I am at https://datausa.io/map/?level=county&key=poor_or_fair_health in Chrome and click 'download CSV' I get poorly rendered output it's not a CSV (looks more like a failed JSON parse)

When opening, Excel lodges the error:

This message can appear due to one of the following: The file contains more than 1,048,576 rows or 16,384 columns. To fix this problem, open the source file in a text editor such as Microsoft Word. Save the source file as several smaller files that conform to this row and column limit, and then open the smaller files in Microsoft Excel. If the source data cannot be opened in a text editor, try importing the data into Microsoft Access, and then exporting subsets of the data from Access to Excel. The area that you are trying to paste the tab-delineated data into is too small. To fix this problem, select an area in the worksheet large enough to accommodate every delimited item. Notes Excel cannot exceed the limit of 1,048,576 rows and 16,384 columns. By default, Excel places three worksheets in a workbook file. Each worksheet can contain 1,048,576 rows and 16,384 columns of data, and workbooks can contain more than three worksheets if your computer has enough memory to support the additional data.

davelandry commented 7 years ago

Duplicate of #444, prioritizing fix.