We Are Here To Help

Follow

Export formats for downloading data

Once a dataset has been loaded into Socrata, 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)*
  • RDF
  • RSS** (with GeoRSS information if there is a Location column in the dataset)
  • TSV for Excel 
  • XML

All of the above formats are also available for that data in filtered views and are also available to developers via the Socrata Open Data Consumer API.

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.

Screen_Shot_2017-05-11_at_11.54.58_AM.png

To download a dataset while viewing the table, click on the export.jpg (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.

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

Comments

  • Avatar
    Dan Brickley

    Regarding the RDF export, I see a default export exists already, now I've made a quick test table and a couple of test rows.

    However I have seen examples - eg opendata.socrata.com/dataset/My-Friends-RDF-Test-/w7f6-86zj - where the RDF is nicely tuned to external / well known RDF schemas. I don't see where this is configured yet, ... can it be done through the Web UI?

     

    ps. you export "Web links" using a property foaf:document that doesn't exist in FOAF; that could do with tweaking somehow

  • Avatar
    Chris Metcalf

    Dan -

    The default RDF output isn't super useful since datasets we need more semantics in order to describe the data. You'll want to configure the column to include the semantic type. If you bring up the Column Properties sidebar by clicking on the orange drop-down button in the column header, you can select the predicate you want to use from the "Advanced" section. That'll then be used to describe the data in the RDF output.

    Note that you need to be the owner of the dataset in order to modify the column properties, so you should try this on a dataset you've created yourself.

    Feel free to let me know if you have more questions.

    Thanks,

    Chris Metcalf

    Director of Product Development

    and Developer Evangelism

    chris.metcalf (at) socrata.com

     

  • Avatar
    John Erickson

    Hi Chris!

    My question is somewhat related to Dan's; looking for...

    • Detail on how the "raw" RDF conversion is done
    • Detail on binding predicates to columns, especially adding candidate vocabularies, selecting terms from those vocabs, etc

    Is there a tutorial, and/or can I access a sandbox (this is suggested by your answer to Dan). 

    Thanks!

    John Erickson (TWC RPI)

Powered by Zendesk