# 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 |