Analyzing OCDS data in a spreadsheet

Download video

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
• Learning Lab: Getting & Exploring OCDS Data with Google Sheets
• Learning Lab: Advanced OCDS Analysis With Excel
• OCDS Schema: Deep Dive
• OCDS Release Structure
• Google Docs Editors Help: VLOOKUP
• Google Docs Editors Help: Create and use pivot tables