View all resources
Analyzing OCDS data in a spreadsheet
In this video, review key ideas for analyzing tabular Open Contracting Data Standard data in a spreadsheet, including determining whether data needs to be transformed before analysis, how to combine data from different sheets, and how to use pivot tables to summarize data in a single sheet. We encourage you to watch in full screen mode as we made use of spreadsheets for demonstrations within this video.
To learn more, check out these related resources:
- Prototyping OCDS data using spreadsheets – http://bit.ly/ocds-spreadsheets
- Learning Lab: Getting & Exploring OCDS Data with Google Sheets – https://bit.ly/OCP-LL-OCDS-googlesheet
- Learning Lab: Advanced OCDS Analysis With Excel – https://bit.ly/OCP-LL-OCDS-Excel
- OCDS Schema: Deep Dive – http://bit.ly/OCDS-schema-deepdive
- OCDS Release Structure – http://bit.ly/OCDS-release-structure
- Google Docs Editors Help: VLOOKUP – http://bit.ly/OCDS-VLOOKUP
- Google Docs Editors Help: Create and use pivot tables – http://bit.ly/create-use-pivot-tables