# How do I get SAM.gov data into Excel or Google Sheets? For a one-off list, download it: SAM.gov search results and USAspending searches export to CSV. For a sheet that refreshes, call an API from Excel Power Query (Get Data, From Web, with an Authorization header) or from Google Sheets Apps Script with UrlFetchApp, and schedule a daily refresh. Spreadsheets suit lists of a few thousand rows: a bid pipeline, a supplier file, a teaming shortlist.Checked on 2026-11-15.Source: [Apps Script UrlFetchApp](https://developers.google.com/apps-script/reference/url-fetch/url-fetch-app) | Excel | Power Query, From Web | | --- | --- | | Google Sheets | Apps Script UrlFetchApp | | Refresh | Scheduled trigger | | Bulk | CSV export (Scale) | ## The answer in detail Spreadsheets suit lists of a few thousand rows: a bid pipeline, a supplier file, a teaming shortlist. Power Query handles the JSON and expands the data list into columns; Apps Script writes rows with setValues and runs on a time trigger.Keep the key out of shared sheets. In Apps Script, store it in Script Properties; in Excel, use a parameter that each user sets locally.For a whole dataset, a spreadsheet is the wrong tool: the Scale plan's CSV export or the one-time data license deliver files for a database instead. ## How the options compare | Option | Price | Access and limits | Coverage and history | Best for | Checked | | --- | --- | --- | --- | --- | --- | | [SAM.gov APIs (official)](https://open.gsa.gov/api/entity-api/) | Free | 10 requests a day with no SAM.gov role, 1,000 with a role or a non-federal system account; keys expire every 90 days | The live, authoritative record: entities, opportunities, exclusions, contract awards, hierarchy, subawards | Anyone who needs the official record itself, at low volume | 2026-11-12 | | [USAspending API (official)](https://api.usaspending.gov/docs/endpoints) | Free, no key | No key and no published daily cap | Prime awards and subawards back to FY2001; no SAM.gov registration status or expiry | Award and spending history | 2026-11-12 | | [samgovapi.io](https://samgovapi.io/pricing) | Free (100 credits a month, no card); Developer $49/mo, Pro $149/mo, Scale $499/mo | 20 to 180 requests a minute by plan, no daily cap; REST, MCP and keyless MCP search | 881,370 entities (1 Nov 2026 extract), 74,420 notices, 169,191 exclusions, 114,954 awards since 1 Oct 2026 | Developers and AI agents who want entities, bids and exclusions joined in one API | 2026-11-15 | ## Where samgovapi.io is the weaker choice - No ready-made Sheets add-on yet; the script below is the integration. ## Try it Google Apps Script: write open bids for a NAICS code into the active sheet. ``` function loadBids() { const key = PropertiesService.getScriptProperties().getProperty("SAMGOVAPI_API_KEY"); const url = "https://samgovapi.io/api/v1/opportunities?naics=541611&open=true&sort=deadline&limit=100"; const body = JSON.parse(UrlFetchApp.fetch(url, { headers: { Authorization: "Bearer " + key } }).getContentText()); const rows = body.data.map(o => [o.notice_id, o.title, o.department, o.set_aside_code, o.response_deadline]); const sheet = SpreadsheetApp.getActiveSheet(); sheet.clearContents().getRange(1, 1, 1, 5).setValues([["Notice", "Title", "Agency", "Set-aside", "Deadline"]]); if (rows.length) sheet.getRange(2, 1, rows.length, 5).setValues(rows); } ``` ## Questions Can I use IMPORTDATA or IMPORTJSON?IMPORTDATA cannot send an auth header; use Apps Script.How many rows fit?Google Sheets allows 10 million cells; a few thousand bids is fine. ## Related - [Bulk download](https://samgovapi.io/bulk-download) - [Open bids](https://samgovapi.io/opportunities) - [API docs](https://samgovapi.io/docs) - [Pricing](https://samgovapi.io/pricing) - [Answers](https://samgovapi.io/answers)Updated 2026-11-15. Sources checked 2026-11-15.Independent. Not affiliated with, endorsed by or sponsored by GSA, SAM.gov or any U.S. government agency. Registering in SAM.gov is free at sam.gov.

---

HTML version: https://samgovapi.io/answers/sam-gov-data-in-excel-or-google-sheets . Markdown: https://samgovapi.io/answers/sam-gov-data-in-excel-or-google-sheets.md

Independent. Not affiliated with, endorsed by or sponsored by GSA, SAM.gov or any U.S. government agency. Registering in SAM.gov is free at sam.gov.

Get a free API key: https://samgovapi.io/sign-up?ref=ai-claudebot