Head to head · Sheets read · October 2026 research run

Google Sheets API vs Microsoft Excel (Microsoft Graph workbook API)

Google Sheets API scores 76.3 (BB) on agent readiness against Microsoft Excel (Microsoft Graph workbook API)'s 58.5 (C), and leads in 6 of 7 scored categories. Both do sheets read.

Which one, for what

Google Sheets API BB

Good for Agents reading and writing cells, formulas and formatting in spreadsheets people already keep in Google Sheets.

Ahead on

  • Reliability, 90 against 62
  • Security & auth, 80 against 65
  • Payments & pricing, 35 against 15
  • Maintenance & community, 85 against 53
  • Transparency & trust, 80 against 75

Also in its favour

  • Agent-ready, a grade of BB or better
  • No incidents deducted, where Microsoft Excel (Microsoft Graph workbook API) loses 4 points for them

Watch for

Quotas are 300 reads and 300 writes a minute per project and 60 each per user per project

Microsoft Excel (Microsoft Graph workbook API) C

Good for Agents working on .xlsx files that already live in a Microsoft 365 tenant, and for using Excel's calculation engine through function endpoints.

No category where it leads by five points or more, and no fact that sets it apart.

Watch for

Reference pages list delegated permissions only and mark application permissions as not supported

Score by category

CategoryWeight this runGoogle Sheets APIMicrosoft Excel (Microsoft Graph workbook API)Edge
Reliability16%209062Google Sheets API +28
Performance10%pendingpendingpendingnot scored in this run
Schema & documentation13%16.28385Microsoft Excel (Microsoft Graph workbook API) +2
Agent ergonomics13%16.27473Google Sheets API +1
Security & auth14%17.58065Google Sheets API +15
Payments & pricing10%12.53515Google Sheets API +20
Task success10%pendingpendingpendingnot scored in this run
Maintenance & community7%8.88553Google Sheets API +32
Transparency & trust7%8.88075Google Sheets API +5
Negative events≤150-4
Total76.3 · BB58.5 · C

Facts side by side

FactGoogle Sheets APIMicrosoft Excel (Microsoft Graph workbook API)
KindHTTP APIHTTP API
VendorGoogleMicrosoft
Hosted endpointhttps://sheets.googleapis.com/v4https://graph.microsoft.com/v1.0
TransportsHTTP, Streamable HTTPHTTP
AuthOAuthOAuth
PricingFreeYour plan
x402nono
LicenceProprietary service under the Google APIs Terms of Service. The client libraries are Apache-2.0MIT (SDKs)
Tools exposed6none
Read-only variant documentednono
llms.txtnono
Last release2026-10-072025-09-19
Terms last updated2021-11-092025-10-01
Privacy policy last updated2026-10-012026-09-01
Customer content may train modelsyesyes
Terms restrict automated accessyesyes
Terms restrict benchmarkingnot found in the textyes
Terms or service can change without noticenot found in the textyes
Arbitration or class-action waivernot found in the textnot found in the text
Popularity12k stars, 1.9M npm/wk, 31.8M PyPI/wk835 stars, 2.9M npm/wk, 1.6M PyPI/wk

Verdicts

Google Sheets API

Batch updates apply atomically and count as one request, and the drive.file scope limits an app to files the user picks. Quotas are 300 reads and 300 writes a minute per project, reads are by range with no row filter or paging, and a person must complete OAuth consent first.

Microsoft Excel (Microsoft Graph workbook API)

Ranges, tables, charts and 366 worksheet function endpoints are reachable over REST with a public OpenAPI, and a non-persistent session lets an agent test changes without saving them. The reference pages list delegated permissions only, with Files.ReadWrite as the least privileged scope, and writes take no idempotency key.

Before you call either

Google Sheets API

  1. Ask for drive.file where the user picks the files. spreadsheets and spreadsheets.readonly are sensitive scopes and need extra verification for a public app
  2. Send valueInputOption=USER_ENTERED to write formulas. With RAW the string =1+2 is stored as text
  3. Put related changes in one spreadsheets.batchUpdate. It counts as one write request and none of it applies if any request is invalid
  4. Pass ranges and a fields mask on spreadsheets.get and leave includeGridData off for large files
  5. Back off exponentially on 429 and 503, and keep to one request a second per spreadsheet. After a timeout on values.append, read the range before retrying

Microsoft Excel (Microsoft Graph workbook API)

  1. Create a session with POST /workbook/createSession and send workbook-session-id on every call. Persistent sessions expire after about 5 minutes idle
  2. Set persistChanges to false when you only need a calculation or a chart image, so nothing is saved to the file
  3. Send one request at a time per workbook and wait for each response. Microsoft warns that parallel writes cause throttling, timeouts and merge conflicts
  4. Add rows in one call with a two-dimensional values array, and check the table before repeating a row add that returned 504
  5. Read bounded addresses such as A1:D500. A whole-column range such as C:C returns null for values, and writes to it are refused

Questions

Which is better for AI agents, Google Sheets API or Microsoft Excel (Microsoft Graph workbook API)?

Google Sheets API scores 76.3 (BB) on agent readiness against Microsoft Excel (Microsoft Graph workbook API)'s 58.5 (C), and leads in 6 of 7 scored categories.

Do Google Sheets API and Microsoft Excel (Microsoft Graph workbook API) need an API key?

Both use an OAuth sign-in.

Can an agent call Google Sheets API and Microsoft Excel (Microsoft Graph workbook API) without installing anything?

Yes. Google Sheets API has a hosted endpoint at https://sheets.googleapis.com/v4 and Microsoft Excel (Microsoft Graph workbook API) at https://graph.microsoft.com/v1.0.

Other comparisons with Google Sheets API or Microsoft Excel (Microsoft Graph workbook API)

Machine-readable

For companies

Do agents find, use and choose your tools?

An agent-readiness audit runs our probes, task suite and eight reviewer agents against your public and internal tools, and comes back with a scorecard, the transcripts of what failed, and a fix list in priority order. From $2,500, re-run included. We never take payment to move a rank. We do help companies earn one.