> 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/onedrive.md).

# OneDrive

Sync Excel files from OneDrive to Google Sheets, BigQuery, Looker Studio, or AI platforms with Coupler.io automation.

OneDrive is Microsoft's cloud storage service. You can connect Excel files stored in OneDrive to Coupler.io and automatically sync them to Google Sheets, Excel, BigQuery, Looker Studio, or even AI destinations like Claude and ChatGPT.

## Why connect OneDrive to Coupler.io?

* **Automate Excel syncing** — Keep your spreadsheets in sync without manual copy-paste
* **Consolidate multiple sheets** — Pull data from different sheets or tabs into a single destination
* **Send data to AI** — Extract OneDrive Excel data and pipe it directly to Claude, ChatGPT, or other AI platforms for analysis and content generation
* **Schedule regular updates** — Set it and forget it — your data refreshes on your schedule
* **Work with shared files** — Connect to Excel files shared with you or in shared drives

## Prerequisites

* A Microsoft account (personal OneDrive or OneDrive for Business)
* An Excel file (.xlsx, .xls) in your OneDrive
* Read access to the file you want to connect

## Quick start

{% hint style="success" %}
Start by signing in with your Microsoft account. Coupler.io will guide you through finding your Excel file and selecting which sheets to import. No manual configuration needed.
{% endhint %}

## How to connect

{% stepper %}
{% step %}
**In Coupler.io, click "+ Add source" and select OneDrive.** You'll be prompted to sign in with your Microsoft account.
{% endstep %}

{% step %}
**Complete the Microsoft login flow.** Coupler.io will ask for permission to access your OneDrive files. Grant access to proceed.
{% endstep %}

{% step %}
**Select your Excel file from the file picker.** Navigate through your OneDrive folders to find the workbook you want to connect. The picker shows all Excel files you have access to.
{% endstep %}

{% step %}
**Choose which sheet(s) to import.** If your workbook has multiple sheets, specify which ones you want to pull data from. You can select one or multiple sheets — they'll be combined into your destination.
{% endstep %}

{% step %}
**Optionally set a range.** If you only want to import a specific area of the sheet (e.g., A1:Z100), enter the range. If left blank, all data in the sheet will be imported.
{% endstep %}

{% step %}
**Choose your destination.** Pick where the data should go — Google Sheets, Excel, BigQuery, Looker Studio, or an AI destination like Claude or ChatGPT.
{% endstep %}

{% step %}
**Run the data flow.** Click "Run" to execute a manual test. Once it completes successfully, you can set up a schedule for automatic updates.
{% endstep %}
{% endstepper %}

## Supported file types

| File Type     | Supported |
| ------------- | --------- |
| Excel (.xlsx) | ✓         |
| Excel (.xls)  | ✓         |
| CSV           | ✗         |
| Other formats | ✗         |

## What data can you import from OneDrive?

OneDrive is a file storage service, so the data you can import depends entirely on what's in your Excel files. Coupler.io treats each Excel file as a data source and pulls the contents of any sheets you specify.

## How it works

When you connect an Excel file from OneDrive, you choose:

1. **Which file** — The specific Excel workbook in your OneDrive
2. **Which sheet(s)** — One or more tabs/sheets within that workbook
3. **Which range** (optional) — A specific cell range, or leave blank to import everything

The data is then synced to your destination on your schedule.

## Data structure

OneDrive Excel files typically have:

* **Headers** — The first row usually contains column names
* **Data rows** — The rows below headers contain your actual data
* **Multiple sheets** — You can consolidate data from different sheets using the Append transformation

## Common use cases

### Marketers

Sync campaign performance data from an Excel tracking sheet in OneDrive to a live Google Sheets dashboard. Pull metrics like impressions, clicks, and conversions, then send them to Claude for automated performance summaries.

### Finance teams

Import expense reports or budget tracking spreadsheets from OneDrive to BigQuery for centralized analysis. Use the Append transformation to combine multiple team budgets into one dataset.

### Sales operations

Keep a CRM data export from OneDrive in sync with Looker Studio for real-time sales dashboards. Append data from multiple regional teams or time periods for unified reporting.

### Product teams

Pull user feedback or bug tracking data from OneDrive, then send it to Perplexity or ChatGPT for automated categorization and summary generation.

## Platform-specific notes

* **Personal OneDrive and OneDrive for Business work the same way** — Just sign in with your Microsoft account and pick your file
* **Shared files are supported** — If someone has shared an Excel file with you, it will appear in the file picker
* **Sheet names matter** — If you rename a sheet after setting up your data flow, you'll need to update the sheet name in the configuration
* **Large files may take longer** — Excel files over 10 MB might take extra time to process
* **Headers are required** — Your Excel sheets should have header rows so Coupler.io knows what each column represents

## OneDrive common issues

### Connection issues

<details>

<summary>"Could not obtain a WAC access token" error</summary>

This error occurs when the Excel file is temporarily unavailable or there's a connectivity issue with Microsoft's servers. **Solution:** Wait a few minutes and try running the data flow again. If the error persists, check that:

* Your Microsoft account still has access to the file
* The file hasn't been moved or deleted
* Your internet connection is stable

If the file is stored in a shared drive, verify that you still have read access to it.

</details>

<details>

<summary>"Cannot connect to OneDrive account" error</summary>

This usually means the OAuth connection expired or was revoked. **Solution:**

1. In your data flow settings, click "Reconnect source"
2. Sign in again with your Microsoft account
3. Grant permission when prompted
4. Run the data flow again

If you recently changed your Microsoft password, you'll need to reconnect as well.

</details>

<details>

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

If you can't find your Excel file when setting up the data flow, it might be:

* Stored in a folder you don't have access to
* Recently moved (refresh the picker and look in the new location)
* Shared with you but not in your main OneDrive folder (check "Shared with me" section if available)

**Solution:** Navigate through your OneDrive folders in the picker. If it's a shared file, ask the owner to reshare it. For OneDrive for Business files, make sure you're using your work account to sign in.

</details>

### Missing data

<details>

<summary>Some rows aren't being imported</summary>

Common causes:

* **Range is too narrow** — If you set a custom range (e.g., A1:D100), only those columns/rows are imported. Check that your range covers all the data you need.
* **Sheet name is incorrect** — If you manually entered the sheet name and it has a typo, no data will import. Verify the exact sheet name in your Excel file.
* **Blank rows in the data** — Excel sheets with empty rows in the middle might cause issues. Try removing blank rows or running a filter first.

**Solution:** Clear any custom range and sheet name filters, then run the data flow again to import all available data.

</details>

<details>

<summary>Headers are missing or duplicated</summary>

If you're importing multiple sheets, headers from each sheet get included in the final data. **Solution:** Use the "Skip header" option when consolidating data from multiple sheets. Enable this if you're using the Append transformation to combine sheets — it will skip the header row on subsequent sheets.

</details>

<details>

<summary>File shows as empty even though it has data</summary>

This can happen if:

* The file is password-protected and you don't have the password
* The data is on a different sheet than expected
* The file is very large and still loading

**Solution:** Open the file in Excel to confirm it has data. Try selecting a different sheet. If the file is password-protected, you'll need to remove the password first.

</details>

### Permission errors

<details>

<summary>"You do not have permissions to open this file in the browser" error</summary>

Microsoft sometimes restricts access to Office files through web browsers for security reasons. **Solution:**

1. Check that your Microsoft account has read access to the file
2. Ask the file owner to re-share it with you if needed
3. Try disconnecting and reconnecting your OneDrive account
4. Wait a few hours — the restriction may be temporary

If the file is stored in a shared drive, contact your OneDrive administrator to check permissions.

</details>

<details>

<summary>File is shared with me but I can't select it</summary>

Shared files sometimes don't appear in the file picker if the share hasn't fully synced. **Solution:**

1. Sign into your OneDrive account and confirm you can open the file there
2. Disconnect and reconnect your OneDrive source in Coupler.io
3. Check the file picker again

If it still doesn't appear, ask the owner to reshare it using "Share" → "Anyone with the link" or directly with your email address.

</details>

### Data discrepancies

<details>

<summary>Data looks different in the destination than in the source file</summary>

This can occur if:

* Formulas in Excel are calculating values that change between runs
* The file is being edited while Coupler.io is importing it
* Date or number formatting is being applied by the destination (Google Sheets, Excel, etc.)

**Solution:** Check if the raw data is the same in both places. If Excel formulas are the issue, consider exporting their values instead. Avoid editing the source file while a data flow is running.

</details>

<details>

<summary>Numbers or dates are being imported as text</summary>

Excel files sometimes store numbers or dates as text, which can cause formatting issues in the destination. **Solution:** Open your Excel file and verify that columns with numbers/dates are formatted correctly as "Number" or "Date" (not "Text"). Then run the data flow again.

</details>

### Rate limits

<details>

<summary>"Microsoft Excel Online is temporarily unavailable" error</summary>

Microsoft's Excel service occasionally goes down for maintenance or encounters temporary issues. **Solution:** Wait 15-30 minutes and try running the data flow again. This is usually resolved quickly on Microsoft's side.

If the error persists for more than an hour, check Microsoft's status page for any ongoing incidents.

</details>

<details>

<summary>Data flow runs very slowly or times out</summary>

Large Excel files (10+ MB) or files with thousands of rows can take longer to import. **Solution:**

1. Try setting a specific range (e.g., A1:Z1000) instead of importing the whole sheet
2. Consider splitting large files into smaller ones
3. If possible, schedule data flow runs during off-peak hours

Very large imports may occasionally hit timeout limits — if that happens, contact Coupler.io support.

</details>

## OneDrive FAQ

<details>

<summary>Can I import from OneDrive for Business (SharePoint) or only personal OneDrive?</summary>

Both work the same way. OneDrive for Business is part of your Microsoft 365 account, so just sign in with your work email and the file picker will show your SharePoint and OneDrive files together.

</details>

<details>

<summary>What if the Excel file is shared with me by someone else?</summary>

Shared files work perfectly — they'll show up in the file picker once you've signed in. You need at least read access to the file. If you can't see it in the picker, make sure the file owner has shared it with your specific email address (not just a generic link).

</details>

<details>

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

Yes! When you select a file, you can specify multiple sheet names (enter each on a new line). You can also use the Append transformation to combine data from different sheets into a single dataset.

</details>

<details>

<summary>What happens if I rename the sheet in Excel after I've set up the data flow?</summary>

The data flow will break because it's looking for the old sheet name. You'll need to update the sheet name in your data flow configuration to match the new name in Excel.

</details>

<details>

<summary>Can I import a specific range instead of the entire sheet?</summary>

Yes. Use the Range parameter to specify which cells to import (e.g., A1:Z100). If you leave it blank, all data in the sheet will be imported.

</details>

<details>

<summary>What file types does OneDrive support?</summary>

Coupler.io supports Excel files (.xlsx and .xls). CSV and other file types are not supported. If your data is in another format, first convert it to Excel in OneDrive.

</details>

<details>

<summary>Can I send OneDrive data directly to Claude, ChatGPT, or other AI platforms?</summary>

Yes! After importing your data, choose Claude, ChatGPT, Cursor, Gemini, Perplexity, or OpenClaw as your destination. This is perfect for summarizing reports, analyzing data, or generating insights from your Excel files.

</details>

<details>

<summary>How large can my Excel file be?</summary>

OneDrive files can be quite large, but very large files (10+ MB) may take longer to import. For optimal performance, try limiting your import to a specific range or archiving older data to a separate file.

</details>

<details>

<summary>What if I see "Could not obtain a WAC access token"?</summary>

This is a temporary Microsoft connectivity issue. Wait a few minutes and try running the data flow again. If it persists, verify that you still have access to the file and your internet connection is stable.

{% hint style="info" %}
See [Common Issues](#onedrive-common-issues) for more troubleshooting steps.
{% endhint %}

</details>

<details>

<summary>Do I need to reconnect my account if I change my Microsoft password?</summary>

Yes. After changing your password, go to your data flow settings and click "Reconnect source." Sign in with your new password to re-authorize Coupler.io.

</details>

<details>

<summary>Can I consolidate data from multiple Excel files?</summary>

Not directly in a single data flow. However, you can create separate data flows for each file and use the Append transformation to combine them in your destination (Google Sheets, BigQuery, etc.).

</details>

<details>

<summary>What if my Excel file has formulas — will they be imported?</summary>

No, only the calculated values are imported, not the formulas. If you need formulas in your destination, you'll need to recreate them there.

</details>

<details>

<summary>Can I schedule the data flow to run automatically?</summary>

Yes, but first you need to complete a successful manual run. Once the data flow runs without errors, you can set up a schedule (hourly, daily, weekly, etc.) in the data flow settings.

</details>


---

# 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/onedrive.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.
