Advanced Excel

aid: advanced-excel
url: https://raw.githubusercontent.com/api-evangelist/advanced-excel/refs/heads/main/apis.yml
name: Advanced Excel
type: Index
image: https://kinlane-productions.s3.amazonaws.com/apis-json/apis-json-logo.jpg
tags:
  - Automation
  - Business Intelligence
  - Data Analysis
  - Data Processing
  - Excel
  - Microsoft
  - Spreadsheets
description: >-
  Advanced Excel is a subject-matter topic encompassing Microsoft Excel's programmatic capabilities for data analysis,
  formula execution, workbook management, chart generation, and automation. This topic index covers REST APIs, open data
  schemas, and developer tools for working with Excel workbooks programmatically, including Microsoft Graph Excel API,
  open-source spreadsheet libraries, and data interchange formats used in business intelligence and automation
  workflows.
created: '2024-01-15'
modified: '2026-05-19'
specificationVersion: '0.19'
apis:
  - name: Microsoft Graph Excel API
    description: >-
      The Microsoft Graph Excel API provides REST access to Excel workbooks stored in OneDrive, SharePoint, or Teams.
      Supports reading and writing cell values, executing formulas, managing worksheets, creating charts and tables, and
      running workbook sessions for transactional batch operations.
    humanURL: https://learn.microsoft.com/en-us/graph/api/resources/excel
    baseURL: https://graph.microsoft.com/v1.0
    tags:
      - Excel
      - Microsoft
      - OneDrive
      - REST API
      - Spreadsheets
    properties:
      - type: Documentation
        url: https://learn.microsoft.com/en-us/graph/api/resources/excel
      - type: OpenAPI
        url: openapi/microsoft-graph-excel-api-openapi.yml
      - type: JSONSchema
        url: json-schema/
      - type: JSONStructure
        url: json-structure/
      - type: JSONLD
        url: json-ld/microsoft-graph-excel-api-context.jsonld
      - type: Vocabulary
        url: vocabulary/advanced-excel-vocabulary.yaml
integrations:
  - name: Microsoft
  - name: Two people looking at a computer.
  - name: This is placeholder text for
  - name: IDC
  - name: Nationwide
  - name: RSA company
  - name: Teleperformance
  - name: A woman smiling at a laptop
  - name: A man holding a laptop.
maintainers:
  - FN: Kin Lane
    email: [email protected]
common:
  - type: Website
    url: https://www.microsoft.com/en-us/microsoft-365/excel
  - type: Documentation
    url: https://learn.microsoft.com/en-us/graph/excel-concept-overview
  - type: GettingStarted
    url: https://learn.microsoft.com/en-us/graph/api/resources/excel
  - type: TermsOfService
    url: https://www.microsoft.com/en-us/servicesagreement
  - type: PrivacyPolicy
    url: https://privacy.microsoft.com/en-us/privacystatement
  - type: GitHubOrganization
    url: https://github.com/OfficeDev
  - type: Features
    data:
      - name: Workbook and Worksheet Management
        description: Create, read, update, and delete Excel workbooks and worksheets via REST API calls.
      - name: Formula Execution
        description: Execute Excel formulas and retrieve computed values programmatically via the Microsoft Graph API.
      - name: Range and Cell Operations
        description: Read and write cell values, apply formatting, and manipulate named ranges and tables.
      - name: Chart Generation
        description: Create and configure charts from worksheet data including column, line, pie, and bar chart types.
      - name: Table and PivotTable Operations
        description: Create, query, and manipulate Excel tables and pivot tables via API.
      - name: Session Management
        description: Manage persistent workbook sessions for transactional multi-step operations on Excel files.
      - name: Named Items and Functions
        description: Access named ranges, defined names, and custom functions within Excel workbooks.
      - name: Conditional Formatting
        description: Apply and query conditional formatting rules on cell ranges via the REST API.
  - type: UseCases
    data:
      - name: Automated Reporting
        description: Generate Excel-based financial, operational, or analytical reports programmatically from business data.
      - name: Data Import and Export
        description: Read data from Excel workbooks into business applications or write application data into Excel formats.
      - name: Spreadsheet Automation
        description: Automate repetitive Excel tasks such as data cleanup, formula recalculation, and sheet formatting.
      - name: Business Intelligence Pipelines
        description: Extract and transform Excel data for loading into data warehouses and BI tools.
      - name: Financial Modeling
        description: Execute complex financial models stored in Excel and retrieve results via API for application integration.
      - name: Form and Survey Data Collection
        description: Use Excel as a data store for forms and survey responses collected via web or mobile applications.
  - type: Integrations
    data:
      - name: Microsoft Power Automate
        description: No-code automation flows that read and write Excel data using the Excel Online Business connector.
      - name: Microsoft Power BI
        description: Publish Excel workbooks to Power BI for interactive dashboards and data visualization.
      - name: Azure Logic Apps
        description: Enterprise workflow automation that connects Excel data to Azure services and external APIs.
      - name: Python openpyxl
        description: Open-source Python library for reading and writing Excel 2010+ files without Microsoft Office.
      - name: Apache POI
        description: Java library for reading and writing Microsoft Office formats including Excel XLSX files.
      - name: ExcelJS
        description: Node.js library for reading, manipulating, and writing Excel workbook files.
      - name: Google Sheets API
        description: Google's spreadsheet REST API offering similar capabilities for Sheets-based workflows.
  - type: Integrations
    url: https://www.microsoft.com/en-us/marketplace