Microsoft Excel Desktop

The Microsoft Excel Desktop destination in Coupler.io generates a downloadable file that you can open directly in Microsoft Excel on your computer. Every time your data flow runs, Coupler.io produces a fresh file ready for download — no OneDrive, no cloud sync, no API credentials required.

This destination is designed for users who work with Excel locally rather than through Excel Online. If you need data pushed directly into a cloud-hosted workbook, use the Microsoft Excel Online destination instead.

Why use Microsoft Excel Desktop as a destination?

• No cloud account required — no OneDrive, no Microsoft 365 subscription, no OAuth sign-in on the destination side

• Works with any local Excel installation — open the downloaded file in Excel for Windows, Mac, or any spreadsheet app that reads Excel-compatible files

• Excel-friendly by default — built-in BOM (byte order mark) support ensures special characters display correctly when you open the file

• Minimal configuration — just select the destination, run the flow, and download

• Works with any Coupler.io source — pull data from HubSpot, Shopify, Google Ads, Airtable, or any other supported source and export it for local use

Prerequisites

• Microsoft Excel or any spreadsheet application that can open CSV/Excel-compatible files installed on your computer

Quick start

The Microsoft Excel Desktop destination requires almost no configuration. Focus on getting your source data right — once the data flow runs, you just download the file and open it in Excel.

How to connect

1

Add a source to your data flow. Log in to Coupler.io and create a new data flow. Select your data source (for example, HubSpot, Shopify, or Google Analytics) and configure it to pull the data you need.

2

Select Microsoft Excel Desktop as the destination. In the destination step of your data flow setup, choose Microsoft Excel Desktop from the list of available destinations.

3

Run the data flow. Click Save and Run to execute the data flow. Once the run completes, the file is ready for download.

4

Download and open the file. After the run completes, download the generated file from the Coupler.io interface. Open it in Microsoft Excel on your computer. Your data is ready to use.

Each time the data flow runs, a new file is generated. Download the latest version after each run to get the most current data.

Supported features

Feature	Supported
Replace mode	Yes
Append mode	No
Automatic scheduling	Yes
Type enforcement	No
Templates	No

Microsoft Excel Desktop common issues

Data issues

Special characters appear garbled when opening the file in Excel

If accented characters, currency symbols, or non-Latin text appear as garbled characters when you open the downloaded file in Microsoft Excel, the Excel-friendly mode (BOM) may be turned off.

Fix: Open your data flow's destination settings and make sure Excel-friendly mode is enabled. This adds a byte order mark (BOM) to the file, which tells Excel to interpret the file as UTF-8. Re-run the data flow and download the file again.

This setting is enabled by default. If you previously disabled it and are opening the file in Excel, turn it back on.

Column headers are missing from the downloaded file

If your file starts directly with data rows and has no header row, the Include headers setting may be turned off.

Fix: Open your data flow's destination settings and make sure Include headers is enabled. Re-run the data flow and download the file again. The first row will contain column names.

Numbers or dates are formatted incorrectly in Excel

Excel applies its own formatting rules when opening files. Numbers may appear as text, dates may display in an unexpected format, or leading zeros may be stripped from values like ZIP codes or product codes.

Fix: After opening the file, select the affected column, right-click, choose Format Cells, and set the appropriate number or date format. For values that need leading zeros preserved (such as ZIP codes), format the column as Text before pasting or importing the data.

Large files are slow to open or cause Excel to freeze

If your data flow exports a very large number of rows, the downloaded file may take a long time to open or cause Excel to become unresponsive.

Fix: Reduce the amount of data exported by applying filters or limiting the date range in your source configuration. If you regularly work with large datasets (hundreds of thousands of rows), consider using a database destination like BigQuery or PostgreSQL instead.

Excel supports a maximum of 1,048,576 rows per sheet. If your export exceeds this limit, some data will be truncated when opened in Excel.

Download issues

No file available for download after the data flow run

If you don't see a download option after the data flow finishes, the run may not have completed successfully.

Fix: Check the data flow run history in Coupler.io. If the run shows an error, fix the source configuration and re-run the flow. The download is only available after a successful run.

The downloaded file is empty

If the file downloads but contains no data (or only headers), the source query may have returned zero rows.

Fix: Verify that the source configuration is correct — check filters, date ranges, and access permissions on the source side. Preview the data in Coupler.io before running the flow to confirm rows are being returned.

Microsoft Excel Desktop FAQ

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.

Do I need OneDrive or a Microsoft 365 subscription?

No. The Microsoft Excel Desktop destination generates a file for download — it does not connect to any Microsoft cloud service. You only need a copy of Microsoft Excel (or any compatible spreadsheet application) installed on your computer.

What format is the downloaded file?

The file is generated as a CSV-compatible file optimized for Microsoft Excel. With the default settings (Excel-friendly mode enabled), it includes a UTF-8 BOM so that Excel correctly interprets special characters when you open it.

What does the Excel-friendly mode (BOM) setting do?

When enabled, this setting adds a byte order mark (BOM) at the beginning of the file. The BOM tells Microsoft Excel to interpret the file as UTF-8, which ensures that special characters — accented letters, currency symbols, non-Latin scripts — display correctly. This setting is on by default.

If you are opening the file in a tool other than Excel that has trouble with the BOM character, you can safely disable this setting.

What does the Include headers setting do?

When enabled (the default), the first row of the file contains column names. If you disable this setting, the file starts directly with data rows. Most workflows expect headers in the first row, so keep this on unless your use case specifically requires raw data without headers.

Can I automate the download?

Coupler.io automatically generates a new file each time the data flow runs, and you can schedule runs at regular intervals. However, the download step itself is manual — you need to go to the Coupler.io interface to download the file after each run.

If you need a fully automated pipeline where data is delivered without manual downloads, consider using a different destination such as Google Sheets, BigQuery, or the CSV destination (which provides a stable URL you can fetch programmatically).

Is there an Append mode for the Microsoft Excel Desktop destination?

No. The Microsoft Excel Desktop destination only supports Replace mode — each run generates a new file with the latest data. If you need to accumulate historical data over time, consider using a database destination like BigQuery or PostgreSQL, or use the Microsoft Excel Online destination which supports Append mode.

Can any Coupler.io source send data to the Microsoft Excel Desktop destination?

Yes. The Microsoft Excel Desktop destination works with any source available in Coupler.io, including HubSpot, Google Ads, Facebook Ads, Pipedrive, Airtable, and more. You can also combine multiple sources in a single data flow using Join, Append, or Aggregate transformations.

Can I open the downloaded file in applications other than Excel?

Yes. The generated file can be opened in any application that reads CSV or Excel-compatible files, including Google Sheets, LibreOffice Calc, Numbers, and text editors. If you are not using Microsoft Excel, you may want to disable the Excel-friendly mode (BOM) setting to avoid a stray character at the start of the file.

Does running the data flow update the file already in my computer?

No — each run produces a fresh file for you to download. There is no sync back to a local file.