# Microsoft Excel

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 |


---

# Agent Instructions: Querying This Documentation

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

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

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

The question should be specific, self-contained, and written in natural language.
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.