> For the complete documentation index, see [llms.txt](https://docs.coupler.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.coupler.io/sources/category/files-and-tables/microsoft-excel.md).

# Microsoft Excel

Automate Excel data exports to Google Sheets, BigQuery, Looker Studio, and AI tools via Coupler.io — no manual copy-paste needed.

Microsoft Excel is a spreadsheet application that's part of the Microsoft 365 suite. With Coupler.io, you can pull data from Excel workbooks stored in OneDrive or SharePoint and send it to your preferred destination — automatically, on a schedule.

## Why connect Excel to Coupler.io?

* **Automate data exports** from Excel to Google Sheets, BigQuery, Looker Studio, or AI tools like ChatGPT and Gemini — no manual copy-paste needed
* **Combine multiple sheets** from one or more workbooks using Append or Join transformations
* **Keep dashboards fresh** by scheduling regular syncs from your Excel files
* **Centralize reporting** by merging Excel data with other sources in a single data flow

## Prerequisites

* A Microsoft 365 account with access to OneDrive or SharePoint
* Your Excel file must be stored in OneDrive or SharePoint — local files on your computer are not supported
* You need at least read access to the file you want to connect

## Quick start

{% hint style="success" %}
Before you start, make sure your Excel file is uploaded to OneDrive or SharePoint. Coupler.io cannot access files stored only on your local machine.
{% endhint %}

## How to connect

{% stepper %}
{% step %}
**Create a new data flow.** In Coupler.io, click **Add data flow** and select **Microsoft Excel** as your source.
{% endstep %}

{% step %}
**Authorize your Microsoft account.** Click **Connect** and sign in with your Microsoft 365 account. Grant Coupler.io permission to access your OneDrive files.
{% endstep %}

{% step %}
**Pick your Excel file.** Use the file picker to browse your OneDrive or SharePoint and select the workbook you want to import data from.
{% endstep %}

{% step %}
**Select your sheet(s).** Enter the name(s) of the sheet tabs you want to pull data from. To include multiple sheets, enter each sheet name on a new line.
{% endstep %}

{% step %}
**Choose a destination.** Select where you want your data to go — Google Sheets, Excel, BigQuery, Looker Studio, or an AI destination like Claude or Perplexity.
{% endstep %}

{% step %}
**Run your data flow.** Click **Run** to execute a manual sync and confirm everything is working correctly.
{% endstep %}
{% endstepper %}

## What data can you pull?

| Parameter       | What it does                                                         |
| --------------- | -------------------------------------------------------------------- |
| Sheet(s)        | Specify one or more sheet/tab names to import                        |
| Range           | Limit the import to a specific cell range (e.g., A1:Z100)            |
| Skip header row | Skip the first row — useful when appending data from multiple sheets |

## Microsoft Excel data overview

Coupler.io reads data directly from the sheets and ranges you specify in your Excel workbook. There are no pre-defined entities or report types — the data you get is exactly what's in your spreadsheet.

## What's available

| Configuration option | Description                                                           |
| -------------------- | --------------------------------------------------------------------- |
| Workbook             | The Excel file stored in OneDrive or SharePoint                       |
| Sheet(s)             | One or more tabs within the workbook                                  |
| Range                | A specific cell range to limit the import (e.g., A1:Z50)              |
| Skip header          | Option to skip the first row when combining data from multiple sheets |

Because Excel is a flexible, freeform source, Coupler.io imports whatever columns and rows exist in your selected sheet. Column names are taken from the first row of your data (unless you enable **Skip header**).

#### Data types supported

| Type     | Notes                                                         |
| -------- | ------------------------------------------------------------- |
| Text     | Imported as-is                                                |
| Numbers  | Preserved as numeric values                                   |
| Dates    | Imported as date values; formatting may vary by destination   |
| Formulas | The **calculated result** is imported, not the formula itself |
| Booleans | TRUE/FALSE values are supported                               |

#### Data types not supported

| Type         | Notes                                                                           |
| ------------ | ------------------------------------------------------------------------------- |
| Images       | Images embedded in worksheets are not imported                                  |
| Charts       | Chart objects are ignored                                                       |
| Pivot tables | Raw pivot table output may be inconsistent — export the underlying data instead |

## Common data combinations

Because Excel workbooks often contain related data across multiple sheets, Coupler.io's transformations are especially useful here:

* **Append** multiple sheets from the same workbook (or different workbooks) into a single table — great for combining monthly reports
* **Join** Excel data with data from another source (e.g., a CRM or database) to enrich your spreadsheet records
* **Aggregate** raw transactional rows into summary metrics before sending to a dashboard

## Use cases by role

{% tabs %}
{% tab title="Finance" %}

* Consolidate monthly budget sheets from multiple Excel files into a single BigQuery table
* Append quarterly P\&L tabs into one continuous dataset for trend analysis
* Sync actuals from Excel to Google Sheets for live budget vs. forecast dashboards
  {% endtab %}

{% tab title="Operations" %}

* Pull inventory or logistics data from Excel into Looker Studio for real-time reporting
* Combine data from multiple regional workbooks using Append into a single operations view
* Feed Excel tracking sheets into AI tools like ChatGPT or Gemini for automated summaries
  {% endtab %}

{% tab title="Analysts" %}

* Extract raw data from Excel into BigQuery for SQL-based analysis
* Join Excel data with CRM or ad platform data to build unified reports
* Use scheduled syncs to keep downstream dashboards current without manual exports
  {% endtab %}
  {% endtabs %}

## Platform-specific notes

* Your Excel file must be stored in **OneDrive or SharePoint** — Coupler.io cannot access locally saved files
* Files shared with you via SharePoint should appear in the file picker as long as you have read access
* Only the **calculated values** of formulas are exported, not the formula expressions themselves
* Images, embedded objects, and charts are not included in the export
* Very large workbooks (hundreds of thousands of rows) may hit memory limits — use the **Range** parameter to limit the import to the rows you actually need
* If your sheet names contain special characters, enter them exactly as they appear in the Excel tab

## Microsoft Excel common issues

### Connection issues

<details>

<summary>I can't sign in or authorize my Microsoft account</summary>

Make sure you're signing in with a **Microsoft 365 account** that has access to OneDrive. Personal Microsoft accounts (e.g., outlook.com) may have limited OneDrive API access. If your organization uses conditional access policies or restricts third-party app permissions, ask your IT admin to allow Coupler.io in your Microsoft 365 tenant settings.

</details>

<details>

<summary>My Excel file doesn't appear in the file picker</summary>

The file picker only shows files stored in **OneDrive or SharePoint**. If your file is saved locally on your computer, upload it to OneDrive first. For SharePoint files, make sure you have at least read access to the document library where the file is stored. Try navigating to the SharePoint site directly in the file picker if the file doesn't appear in your default OneDrive view.

</details>

<details>

<summary>I get a "Cannot read properties of undefined" error</summary>

This error typically occurs when Coupler.io tries to read a sheet that is empty, has an unexpected structure, or when the sheet name entered doesn't exactly match the tab name in your workbook. Double-check the sheet name for typos, extra spaces, or special characters. Also verify the sheet contains at least one row of data.

</details>

### Missing data

<details>

<summary>Some rows or columns are missing after the import</summary>

If you specified a **Range** (e.g., A1:Z50), data outside that range won't be imported. Expand the range or remove it to import the full sheet. Also check if any rows are hidden in Excel — hidden rows may not be exported. If you're using **Skip header**, make sure that setting is only enabled when you're combining sheets and don't need the header row duplicated.

</details>

<details>

<summary>Data from a specific sheet isn't coming through</summary>

Sheet names are case-sensitive and must match the tab name exactly. Go back to your data flow settings and verify the sheet name. If your workbook has multiple sheets listed and one is blank, that blank sheet may cause the import to return no data for that tab.

</details>

<details>

<summary>Images or charts from my workbook aren't imported</summary>

Coupler.io imports cell values only. Images, embedded charts, shapes, and other visual objects are not included in the export. This is a platform limitation.

</details>

### Permission errors

<details>

<summary>I get a permissions error when trying to access a SharePoint file</summary>

You need at least **read access** to the SharePoint document library containing the file. Ask the file owner to share it with you directly, or ask your SharePoint admin to grant access. If your Microsoft 365 tenant restricts third-party app access, an admin may need to approve Coupler.io in the Azure Active Directory app permissions settings.

</details>

### Data discrepancies

<details>

<summary>Formula results look different from what I see in Excel</summary>

Coupler.io exports the **calculated value** of a formula, not the formula itself. If a formula references external workbooks or real-time data feeds (e.g., stock prices), the exported value reflects what was last calculated in OneDrive. Values that depend on your local Excel add-ins or volatile functions may differ.

</details>

<details>

<summary>Dates are importing as numbers or in the wrong format</summary>

Excel stores dates as serial numbers internally. Depending on your destination, these may appear as raw numbers. In Google Sheets, you can apply a date format to the column after import. In BigQuery, map the column to a DATE type in your schema settings.

</details>

### Rate limits

<details>

<summary>My data flow fails with a memory or size limit error</summary>

Very large workbooks can exceed Coupler.io's processing limits. Use the **Range** parameter to restrict the import to only the rows and columns you need (e.g., A1:J5000). Avoid importing entire sheets with hundreds of thousands of rows if only a subset is needed.

</details>

## Microsoft Excel FAQ

<details>

<summary>Can I import an Excel file saved on my local computer?</summary>

No. Coupler.io can only access Excel files stored in **OneDrive or SharePoint**. If your file is saved locally, upload it to OneDrive first, then connect it through the file picker. Once it's in OneDrive, any changes you save locally (if OneDrive sync is enabled) will be reflected in future Coupler.io runs.

</details>

<details>

<summary>Can I import multiple sheets from the same workbook?</summary>

Yes. In the **Sheet(s)** field, enter each sheet name on a new line. Coupler.io will pull data from all listed tabs. If you want to stack the data from multiple sheets into one table, enable the **Append** transformation and turn on **Skip header** so column headers aren't repeated.

</details>

<details>

<summary>Can I connect Excel files stored in SharePoint (not just personal OneDrive)?</summary>

Yes. SharePoint files appear in the file picker as long as you have read access to the document library. If a file isn't showing up, check that it's been shared with your account and that your Microsoft 365 admin hasn't restricted third-party app access to SharePoint.

</details>

<details>

<summary>Does Coupler.io sync formulas or just the values?</summary>

Only the **calculated values** are exported — not the formula expressions. So if a cell contains `=SUM(A1:A10)`, Coupler.io will import the resulting number, not the formula itself.

</details>

<details>

<summary>Can I do a two-way sync between Excel and Google Sheets?</summary>

Coupler.io supports one-way data flows — from Excel to your chosen destination. It does not write data back to Excel. If you need to keep both files in sync bidirectionally, that's not a use case Coupler.io currently supports.

</details>

<details>

<summary>Why is data missing after my import runs?</summary>

The most common causes are: the sheet name doesn't match exactly (check for typos or extra spaces), the **Range** parameter is too narrow and excludes some rows, or the sheet contains hidden rows that aren't exported. See the [Common Issues](#microsoft-excel-common-issues) article for a full troubleshooting guide.

</details>

<details>

<summary>Can I import images or charts from my Excel workbook?</summary>

No. Coupler.io imports cell values only. Images, embedded charts, shapes, and other visual objects are not included.

</details>

<details>

<summary>Can I connect multiple Excel workbooks in one data flow?</summary>

Yes. You can add multiple sources to a single data flow — each pointing to a different Excel file. Use the **Append** transformation to combine their data into one unified table, or **Join** to merge them on a common key.

</details>

<details>

<summary>Can I send Excel data to an AI tool like ChatGPT or Gemini?</summary>

Yes. Coupler.io supports AI destinations including ChatGPT, Claude, Gemini, Perplexity, Cursor, and OpenClaw. You can route your Excel data directly to these tools for analysis, summarization, or other AI-powered tasks.

</details>

{% hint style="info" %}
For details on what data types and fields are supported, see the [Data Overview](#microsoft-excel-data-overview) article. For setup recommendations and tips on handling large files, check [Best Practices](https://docs.coupler.io/sources/category/files-and-tables/microsoft-excel/best-practices.md).
{% endhint %}


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://docs.coupler.io/sources/category/files-and-tables/microsoft-excel.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
