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.

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.

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.

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.

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.