Exporting data from OpenSpending

We've found that quite a few people want to get the raw data from OpenSpending. A common use case for the raw data is to look at it through tools that are more familiar, such as Microsoft Excel or Google Sheets. No problem! All the data in OpenSpending is stored in CSV files. You can export these files and then use them in other desktop applications.

Walkthroughs

Exporting a data package

  1. After you interact with the data package, you have the option to download it.

  2. Go to the bottom section of the OS Viewer, where you will see “Data Resources.”

Image1

  1. Choose to either “Download Data Package” or “View Raw Source Data.” First option will download the JSON file:

Image2

The second option, “View Raw Source Data,” will take you to OpenSpending’s data store.

Image3