How I Turned the SAM.gov Public Bulk Dataset Into a Searchable Contractor Database

Description and use

A local compiler enables quick, repeatable filtering of the large SAM.gov dataset by NAICS, geography, small‑business status, and more, exporting results to Excel/CSV without API dependency.

Problem

Researchers and analysts need to filter the large SAM.gov public bulk dataset by criteria such as NAICS code, geography, small‑business status, CAGE availability, and more, but existing solutions rely on APIs, commercial platforms, or complex scripting.

Outcome

The compiler enables rapid, repeatable filtering of the SAM.gov dataset locally, producing clean, export‑friendly Excel/CSV files without API dependencies, suitable for analysts and developers.

Workflow

• Download SAM.gov public bulk extract
• Run the SAM.gov Public Contractor & NAICS Database Compiler (Windows EXE or Python/BAT)
• Select desired filters (status, NAICS, state, small‑business, CAGE, website, etc.)
• Choose output mode (registration‑level or entity‑level)
• Export to Excel or CSV
• Use exported data for research or downstream workflows

Evidence

The workflow does not depend on repeatedly calling an external API just to filter data that already exists in a downloadable public dataset.

Source

The product includes a standalone Windows EXE, but I also wanted a Python/BAT version available.

Source