Once a dataset has been loaded into Data & Insights, it is available for download in a number of different formats:
- CSV (Comma Separated Values)
- CSV for Excel (Tab Separated Values)
- CSV for Excel (Europe)*
- RSS** (with GeoRSS information if there is a Location column in the dataset)
- TSV for Excel
If the dataset contains Geospatial information (Point, Line, Polygon, etc.), the dataset will have additional output formats*:
*Note that exporting geospatial files containing multipolygons using the CSV button will export the data in Well Known Text format. Opening these text files in Excel may result in the text wrapping to the next line if the multipolygon string exceeds the cell character limit. If this happens, open the file with a powerful text editor.
**Shapefiles have a field name limit of 10 characters. Also, floating timestamp columns get turned into 2 columns, a date column and a time column, because shapefiles can't store date and time data in the same column. These limitations could cause field names to be different than what is on the platform.
Downloading a dataset can be done through either the Primer page or through the table view. With Primer just select Download at the top of the page.
To download a dataset while viewing the table, click on the Export sidebar button and then select the "Download" subsection. The sidebar will display the available file formats for your dataset.
*Note for international customers: The CSV for Excel (Europe) file will:
- Have semicolon separators
- Preserve any date and number formats that have been specified in the column settings for that dataset
- Contain the BOM character needed in CSV files in order for Excel to read the file and special characters properly
**RSS feeds are restricted to a maximum of 50-row updates.
Ordering and Filtering Downloads
When exporting the file simply by clicking the Export button on the primer page, we cannot affect the order of rows in the exported file. However, all of the above formats can present the data in filtered, ordered, or even queried downloads via the Data & Insights Open Data Consumer API. This API is useful for developers too.