> 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/destinations/categories/spreadsheets/microsoft_excel.md).
# Microsoft Excel Online
Send data to Excel Online workbooks in OneDrive with preserved formulas and automatic updates via Coupler.io.
Microsoft Excel Online is one of the world's most widely used spreadsheet applications, used for everything from financial reporting to marketing dashboards. With Coupler.io, you can automatically push data from any supported source directly into Excel workbooks stored in OneDrive or OneDrive for Business — no manual exports or copy-pasting required.
**Why use Microsoft Excel Online as a Coupler.io destination?**
* **Keep your formulas intact** — data lands exactly where you specify, so calculations and formatting around your imported range stay safe
* **Build historical records** — use Append mode to accumulate data over time without losing previous runs
* **Centralize data from any source** — send data from CRMs, ad platforms, databases, spreadsheets, and more into a single Excel workbook
* **Works with your existing OneDrive setup** — no new tools to install; your file stays where your team already accesses it
## Prerequisites
* A Microsoft account with OneDrive or OneDrive for Business
* Edit permissions on the destination Excel file
* The file must be stored in OneDrive (offline files are not supported)
* File format must be **.xlsx** (`.xlsm` files are not currently supported as a destination)
* Workbook size must be under **25 MB**
## Quick start
{% hint style="success" %}
Create your destination Excel file in OneDrive before setting up the data flow.\
It's easier to select an existing file than to create one mid-setup.
{% endhint %}
## How to connect
{% stepper %}
{% step %}
**Add a source to your data flow.** In Coupler.io, create a new data flow and configure at least one source — this can be any supported integration, such as HubSpot, Facebook Ads, Google Sheets, Airtable, or others.
{% endstep %}
{% step %}
**Select Microsoft Excel as the destination.** In the Destination section of your data flow, choose Microsoft Excel from the list of available destinations.
{% endstep %}
{% step %}
**Connect your Microsoft account.** Click **Connect** and sign in with the Microsoft account that has edit access to your destination file. When prompted, review the requested permissions and click **Allow** to authorize Coupler.io.
{% endstep %}
{% step %}
**Select your workbook and sheet.** Use the file picker to choose an `.xlsx` file from your OneDrive. Then select an existing sheet tab or type a new sheet name — Coupler.io will create the sheet automatically if it doesn't exist yet.
{% endstep %}
{% step %}
**Run your data flow.** Click **Save and Run** to execute the first manual run. Verify that your data appears in the correct sheet and cell range before setting up a schedule.
{% endstep %}
{% endstepper %}
## Supported features
| Feature | Supported |
| -------------------- | --------- |
| Replace mode | Yes |
| Append mode | Yes |
| Automatic scheduling | Yes |
| Type enforcement | No |
| Templates | No |
## Microsoft Excel Online common issues
### Connection issues
The file picker shows files from the wrong Microsoft account
If you have multiple Microsoft accounts, the OneDrive file picker displays files from whichever account is currently active at microsoft.com — not necessarily the one you connected in Coupler.io.
To switch accounts:
1. Close the file picker
2. Go to [microsoft.com](https://microsoft.com) and click your profile icon
3. Sign out, then sign back in with the correct account
4. Return to Coupler.io and reopen the file picker
If you see a **103 error** in OneDrive, simply close and reopen the file picker.
The file picker window doesn't open
The picker window may have opened in the background rather than closing. Check your taskbar, click your browser icon, and look for the OneDrive window — it's likely minimized.
"This workbook is not accessible through Microsoft Excel API" error
{% hint style="warning" %}
This is a known Microsoft API limitation that can affect personal OneDrive accounts. It occurs intermittently and is not caused by Coupler.io.
{% endhint %}
Try these steps in order:
1. Confirm the file is on the same OneDrive account you connected in Coupler.io
2. Disconnect and reconnect your Microsoft Excel destination
3. Try again in an Incognito/Private browser window
4. Create a brand-new `.xlsx` file directly in OneDrive and use that as the destination instead
5. If using a personal OneDrive, try switching to a OneDrive for Business account
If none of these work, the issue is with Microsoft's API. You can contact Microsoft Support at support.microsoft.com or consider using Google Sheets as an alternative destination.
"BrowserAuthError: popup_window_error" when connecting
This means the OAuth sign-in popup was blocked. Fix it by allowing popups for Coupler.io in your browser:
* **Chrome:** Settings → Privacy and security → Site Settings → Pop-ups and redirects
* **Firefox:** Tools → Settings → Privacy & Security → Block pop-up windows (add exception)
* **Edge:** Settings → Cookies and site permissions → Pop-ups and redirects
If you're on Internet Explorer, switch to Chrome, Firefox, or Edge. If your organization manages browser settings, check with your IT team about firewall or policy restrictions.
The connected Microsoft account has been deactivated
{% hint style="danger" %}
If the Microsoft account used to authenticate the destination is disabled or removed (for example, when an employee leaves), all data flows using that connection will fail.
{% endhint %}
You'll need to reconnect the destination using an active Microsoft account that has edit access to the same Excel file. Go to your data flow's Destination settings, disconnect the current account, and sign in with a valid account.
### Data issues
The data flow hits Excel's row limit in Append mode
Excel supports a maximum of **1,048,576 rows per sheet**. If you're using Append mode and your cumulative data across all runs exceeds this limit, the run will fail.
To avoid this, monitor your row count over time. Options include switching to a new sheet periodically, archiving old data, or switching to Replace mode if historical accumulation is no longer needed.
Numbers or dates are formatted incorrectly after import
Coupler.io writes raw values — Excel applies its own formatting based on cell format settings. If numbers appear as text or dates display unexpectedly, check the cell format in Excel (right-click → Format Cells) and adjust accordingly.
For values that need a leading apostrophe to display correctly (such as numeric strings like product codes), you can add a formula in your source data or preprocessing step to prepend a `'` character.
Formulas are being overwritten on each run
Coupler.io replaces all data starting from the specified cell address, including everything to the right and below it. If your formulas are in that range, they'll be overwritten.
The fix is to reposition your formulas **to the left** of your imported data range, then update the **Cell address** setting to start your import in a column to the right of your formulas. For example, if your formulas are in column A, set your cell address to B1 or B2.
The last row of data is missing after import
If a specific row consistently doesn't appear in the destination sheet, check whether the source data actually includes that row at the time of the run. Verify the source query or filter settings aren't excluding the final record.
### Permission errors
"Microsoft Excel Online temporarily unavailable" error
{% hint style="warning" %}
This error comes from Microsoft's API, not Coupler.io. It typically happens when a file contains heavy formulas or the file size makes API updates slow or impossible.
{% endhint %}
Try the following:
* Remove or simplify complex formulas in the workbook
* Reduce the overall file size (remove unused sheets, images, or pivot tables)
* Create a new, clean Excel workbook as the destination and re-run the data flow
409 error — resource conflict
A 409 error means two write operations are conflicting. This usually happens when multiple data flows write to the same file at the same time, or when a data flow is triggered multiple times before the previous run finishes.
To prevent this:
* Stagger the schedules of data flows that write to the same workbook
* Avoid manually triggering a run while another is already in progress
* Don't edit the file in Excel while a data flow is running
## Microsoft Excel Online FAQ
What file types does Coupler.io support for the Excel destination?
Coupler.io supports **.xlsx** files stored in OneDrive or OneDrive for Business. Files must be under **25 MB**.
**.xlsm** files (macro-enabled workbooks) are **not currently supported** as a destination. If you need macros, consider keeping them in a separate sheet and referencing the Coupler.io destination sheet from there.
Does my Excel file need to be online?
Yes. The file must be stored in **OneDrive or OneDrive for Business**. Coupler.io uses the Microsoft Excel API to write data, which requires the file to be accessible online. Locally saved files are not supported.
What's the best write mode for my use case?
**Replace mode** is best when you want your sheet to always reflect the latest snapshot of your data — for example, a live CRM pipeline, current ad performance, or an up-to-date inventory list. Each run wipes the previous data and writes fresh.
**Append mode** is best when you want to build a historical log — for example, recording weekly metrics, tracking changes over time, or accumulating event data. Each run adds new rows below the existing ones.
Remember that Append mode is subject to Excel's **1,048,576 row limit per sheet**. Plan accordingly if you're running frequent imports.
How do I keep my formulas safe when importing data?
Place your formulas **to the left** of your imported data range. Then set the **Cell address** in your destination settings to start your import in the column immediately to the right of your formulas.
For example, if your formula column is A, set your cell address to B1. Your imported data fills columns B onward, and your formulas in column A reference those values without ever being overwritten.
{% hint style="info" %}
See the article **"How to keep formulas and import data into the same Excel sheet"** for a step-by-step walkthrough with a practical example.
{% endhint %}
Can I control where in the sheet Coupler.io writes data?
Yes. Use the **Cell address** field in the Destination settings to specify the top-left cell where your data should begin. The default is A1, but you can set it to any cell — for example, B2 if you want a header row or formula column to stay untouched.
All data below and to the right of the specified cell will be replaced on each run.
Can I send data from multiple sources into the same Excel workbook?
Yes — you can create multiple data flows that each write to different sheets within the same workbook. Each data flow targets one sheet, so you can organize data from different sources (e.g., HubSpot deals on one sheet, Facebook Ads on another) within a single file.
{% hint style="warning" %}
Avoid configuring two data flows to write to the **same sheet** at the same time. Simultaneous writes to the same destination can cause 409 conflict errors.
{% endhint %}
Can I send data from Google Sheets to Excel using Coupler.io?
Yes. Google Sheets is a supported source in Coupler.io, and Microsoft Excel is a supported destination. You can set up a data flow that reads from one or more Google Sheets tabs and writes the data into an Excel workbook on OneDrive.
What happens if the sheet I specify doesn't exist yet?
Coupler.io will automatically create a new sheet with the name you entered. You don't need to create it manually in Excel beforehand.
Why can't I see my file in the OneDrive file picker?
The most common reason is that the file picker is showing files from a **different Microsoft account** than the one your file is stored in. Sign out of microsoft.com, sign back in with the correct account, and reopen the picker.
Also check that the file is in **.xlsx format** and under **25 MB** — files outside those parameters won't appear as selectable destinations.
What happens to my data flow if the connected Microsoft account is deactivated?
The data flow will fail. If the Microsoft account used to set up the destination is disabled (for example, when a team member leaves), you'll need to reconnect the destination with an active account that has edit permissions on the same file. Update this in the Destination settings of your data flow.
How is Microsoft Excel Desktop different from the Microsoft Excel Online destination?
The **Microsoft Excel Online** destination writes data directly into an Excel workbook stored in OneDrive using the Microsoft API. It requires an OAuth connection, a Microsoft account with OneDrive, and the file must be online at all times.
The **Microsoft Excel Desktop** destination generates a downloadable file that you save to your computer and open locally in Excel. It does not require OneDrive, a Microsoft account, or any OAuth connection on the destination side.
Use Excel Online if you want automatic, hands-off updates to a cloud workbook. Use Excel Desktop if you prefer to work with files locally or don't have OneDrive.
---
# 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/destinations/categories/spreadsheets/microsoft_excel.md?ask=&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.