aid: spreadsheets name: Spreadsheets description: >- Spreadsheets covers the APIs, tools, and services for programmatic access to spreadsheet data across major platforms including Google Sheets and Microsoft Excel. The Google Sheets API v4 provides RESTful access to read, write, format, and manage Google Spreadsheets. The Microsoft Graph Excel API enables reading and writing Excel workbooks stored in OneDrive for Business and SharePoint. Third-party services like SheetDB, Sheety, Sheet Best, and Sheet2API convert spreadsheets into REST APIs for use as lightweight backends. Spreadsheet APIs are widely used for data import/export, automated reporting, form submissions, lightweight CMS, and business process automation. type: Index position: Consumer access: 3rd-Party image: https://kinlane-productions.s3.amazonaws.com/apis-json/apis-json-logo.jpg tags: - Spreadsheets - Data - Google Sheets - Excel - Productivity - Automation created: '2026-03-16' modified: '2026-05-02' url: >- https://raw.githubusercontent.com/api-evangelist/spreadsheets/refs/heads/main/apis.yml specificationVersion: '0.19' apis: - aid: spreadsheets:google-sheets-api name: Google Sheets API description: >- The Google Sheets API v4 is a RESTful interface that lets developers read and modify Google Spreadsheet data programmatically. The API supports creating spreadsheets, reading and writing cell values by range (A1 notation), batch operations for efficiency, managing sheet structure and formatting, and accessing developer metadata. Authentication uses Google OAuth 2.0. The API is widely used for data pipelines, automated reporting, form data collection, and spreadsheet-powered applications. humanURL: https://developers.google.com/workspace/sheets/api baseURL: https://sheets.googleapis.com/v4 tags: - Google Sheets - Spreadsheets - Data - Productivity - Google Workspace properties: - type: Documentation url: https://developers.google.com/workspace/sheets/api/guides/concepts - type: Reference url: https://developers.google.com/workspace/sheets/api/reference/rest - type: OpenAPI url: openapi/google-sheets-openapi.yml - type: Getting Started url: https://developers.google.com/workspace/sheets/api/quickstart/python - type: Discovery url: https://sheets.googleapis.com/$discovery/rest?version=v4 features: - type: SpreadsheetCRUD description: Create, read, and batch-update entire spreadsheets - type: ValueReadWrite description: Read and write cell values by range using A1 notation (e.g., Sheet1!A1:B2) - type: BatchOperations description: Batch read/write multiple ranges in a single API call for efficiency - type: SheetFormatting description: Apply number formats, text formatting, conditional formatting, and cell styles - type: DataValidation description: Set and enforce data validation rules on cell ranges - type: PivotTables description: Create and manage pivot tables programmatically - type: Charts description: Create, update, and embed charts in spreadsheets - type: DeveloperMetadata description: Attach custom metadata to spreadsheets for application use useCases: - type: DataPipeline description: Import and export data between databases and spreadsheets - type: AutomatedReporting description: Generate weekly/monthly reports directly into Google Sheets - type: FormDataCollection description: Write form submission data to spreadsheets as a lightweight backend - type: FinancialModeling description: Programmatically update financial models with live data - type: ContentManagement description: Use Sheets as a lightweight CMS for websites and apps - aid: spreadsheets:microsoft-graph-excel-api name: Microsoft Graph Excel API description: >- The Microsoft Graph Excel API enables reading and writing Excel workbooks (.xlsx format) stored in OneDrive for Business, SharePoint, or Group drives via the Microsoft Graph REST API. Supports worksheets, ranges, tables, charts, named items, and Excel worksheet functions. Uses session-based access for efficient multi-step operations. Authentication requires Microsoft identity platform (OAuth 2.0) with Files.Read or Files.ReadWrite scopes. humanURL: https://learn.microsoft.com/en-us/graph/api/resources/excel baseURL: https://graph.microsoft.com/v1.0 tags: - Excel - Microsoft Graph - Microsoft 365 - Spreadsheets - OneDrive properties: - type: Documentation url: https://learn.microsoft.com/en-us/graph/api/resources/excel - type: Reference url: https://learn.microsoft.com/en-us/graph/api/resources/excel - type: Getting Started url: https://learn.microsoft.com/en-us/graph/excel-use-functions features: - type: WorkbookAccess description: Read and modify .xlsx workbooks stored in OneDrive for Business and SharePoint - type: Sessions description: Persistent and non-persistent session management for efficient operations - type: WorksheetManagement description: Create, rename, delete, and reorder worksheets within a workbook - type: RangeOperations description: Read, write, format, and sort cell ranges using A1-style addressing - type: TableOperations description: Create tables, manage rows/columns, sort, filter, and convert to range - type: ChartOperations description: Create, update, and retrieve chart images from workbooks - type: NamedItems description: Work with named ranges and named expressions - type: WorkbookFunctions description: Execute Excel worksheet functions (PMT, SUM, VLOOKUP, etc.) via API - aid: spreadsheets:sheetdb name: SheetDB description: >- SheetDB is a service that turns any Google Sheet into a JSON REST API. Provides GET, POST, PUT, PATCH, and DELETE endpoints against spreadsheet data, supporting full CRUD operations without code. Used for prototyping, simple backends, and content management. humanURL: https://sheetdb.io/ baseURL: https://sheetdb.io/api/v1 tags: - Spreadsheets - No Code - REST API - Google Sheets properties: - type: Documentation url: https://docs.sheetdb.io/ - type: Website url: https://sheetdb.io/ - aid: spreadsheets:sheety name: Sheety description: >- Sheety converts Google Spreadsheets into RESTful JSON APIs, providing simple HTTP endpoints for reading and writing spreadsheet data. Supports GET, POST, PUT, PATCH, and DELETE operations with optional API key authentication. humanURL: https://sheety.co/ baseURL: https://api.sheety.co tags: - Spreadsheets - No Code - REST API - Google Sheets properties: - type: Documentation url: https://sheety.co/docs - type: Website url: https://sheety.co/ common: - type: Website url: https://developers.google.com/workspace/sheets/api - type: Reference url: https://learn.microsoft.com/en-us/graph/api/resources/excel - type: OpenAPI url: openapi/google-sheets-openapi.yml - type: JSONSchema url: json-schema/spreadsheet-range-schema.json - type: JSONSchema url: json-schema/spreadsheet-value-schema.json - type: JSONStructure url: json-structure/spreadsheet-range-structure.json - type: JSONLD url: json-ld/spreadsheets-context.jsonld - type: SpectralRules url: rules/spreadsheets-rules.yml - type: Capabilities url: capabilities/spreadsheet-automation.yaml - type: Vocabulary url: vocabulary/spreadsheets-vocabulary.yml maintainers: - FN: Kin Lane email: kin@apievangelist.com