View all resources

Analyzing OCDS data in a spreadsheet

Video
2021

View resource

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: