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

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.

How to connect

1

Create a new data flow. In Coupler.io, click Add data flow and select Microsoft Excel as your source.

2

Authorize your Microsoft account. Click Connect and sign in with your Microsoft 365 account. Grant Coupler.io permission to access your OneDrive files.

3

Pick your Excel file. Use the file picker to browse your OneDrive or SharePoint and select the workbook you want to import data from.

4

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.

5

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.

6

Run your data flow. Click Run to execute a manual sync and confirm everything is working correctly.

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

Microsoft Excel data overview

Coupler.io reads data directly from the sheets and ranges you specify in your Excel workbook. There are no pre-defined entities or report types — the data you get is exactly what's in your spreadsheet.

What's available

Configuration option	Description
Workbook	The Excel file stored in OneDrive or SharePoint
Sheet(s)	One or more tabs within the workbook
Range	A specific cell range to limit the import (e.g., A1:Z50)
Skip header	Option to skip the first row when combining data from multiple sheets

Because Excel is a flexible, freeform source, Coupler.io imports whatever columns and rows exist in your selected sheet. Column names are taken from the first row of your data (unless you enable Skip header).

Data types supported

Type	Notes
Text	Imported as-is
Numbers	Preserved as numeric values
Dates	Imported as date values; formatting may vary by destination
Formulas	The calculated result is imported, not the formula itself
Booleans	TRUE/FALSE values are supported

Data types not supported

Type	Notes
Images	Images embedded in worksheets are not imported
Charts	Chart objects are ignored
Pivot tables	Raw pivot table output may be inconsistent — export the underlying data instead

Common data combinations

Because Excel workbooks often contain related data across multiple sheets, Coupler.io's transformations are especially useful here:

• Append multiple sheets from the same workbook (or different workbooks) into a single table — great for combining monthly reports

• Join Excel data with data from another source (e.g., a CRM or database) to enrich your spreadsheet records

• Aggregate raw transactional rows into summary metrics before sending to a dashboard

Use cases by role

Finance

• Consolidate monthly budget sheets from multiple Excel files into a single BigQuery table

• Append quarterly P&L tabs into one continuous dataset for trend analysis

• Sync actuals from Excel to Google Sheets for live budget vs. forecast dashboards

Operations

• Pull inventory or logistics data from Excel into Looker Studio for real-time reporting

• Combine data from multiple regional workbooks using Append into a single operations view

• Feed Excel tracking sheets into AI tools like ChatGPT or Gemini for automated summaries

Analysts

• Extract raw data from Excel into BigQuery for SQL-based analysis

• Join Excel data with CRM or ad platform data to build unified reports

• Use scheduled syncs to keep downstream dashboards current without manual exports

Platform-specific notes

• Your Excel file must be stored in OneDrive or SharePoint — Coupler.io cannot access locally saved files

• Files shared with you via SharePoint should appear in the file picker as long as you have read access

• Only the calculated values of formulas are exported, not the formula expressions themselves

• Images, embedded objects, and charts are not included in the export

• Very large workbooks (hundreds of thousands of rows) may hit memory limits — use the Range parameter to limit the import to the rows you actually need

• If your sheet names contain special characters, enter them exactly as they appear in the Excel tab

Microsoft Excel common issues

Connection issues

I can't sign in or authorize my Microsoft account

Make sure you're signing in with a Microsoft 365 account that has access to OneDrive. Personal Microsoft accounts (e.g., outlook.com) may have limited OneDrive API access. If your organization uses conditional access policies or restricts third-party app permissions, ask your IT admin to allow Coupler.io in your Microsoft 365 tenant settings.

My Excel file doesn't appear in the file picker

The file picker only shows files stored in OneDrive or SharePoint. If your file is saved locally on your computer, upload it to OneDrive first. For SharePoint files, make sure you have at least read access to the document library where the file is stored. Try navigating to the SharePoint site directly in the file picker if the file doesn't appear in your default OneDrive view.

I get a "Cannot read properties of undefined" error

This error typically occurs when Coupler.io tries to read a sheet that is empty, has an unexpected structure, or when the sheet name entered doesn't exactly match the tab name in your workbook. Double-check the sheet name for typos, extra spaces, or special characters. Also verify the sheet contains at least one row of data.

Missing data

Some rows or columns are missing after the import

If you specified a Range (e.g., A1:Z50), data outside that range won't be imported. Expand the range or remove it to import the full sheet. Also check if any rows are hidden in Excel — hidden rows may not be exported. If you're using Skip header, make sure that setting is only enabled when you're combining sheets and don't need the header row duplicated.

Data from a specific sheet isn't coming through

Sheet names are case-sensitive and must match the tab name exactly. Go back to your data flow settings and verify the sheet name. If your workbook has multiple sheets listed and one is blank, that blank sheet may cause the import to return no data for that tab.

Images or charts from my workbook aren't imported

Coupler.io imports cell values only. Images, embedded charts, shapes, and other visual objects are not included in the export. This is a platform limitation.

Permission errors

I get a permissions error when trying to access a SharePoint file

You need at least read access to the SharePoint document library containing the file. Ask the file owner to share it with you directly, or ask your SharePoint admin to grant access. If your Microsoft 365 tenant restricts third-party app access, an admin may need to approve Coupler.io in the Azure Active Directory app permissions settings.

Data discrepancies

Formula results look different from what I see in Excel

Coupler.io exports the calculated value of a formula, not the formula itself. If a formula references external workbooks or real-time data feeds (e.g., stock prices), the exported value reflects what was last calculated in OneDrive. Values that depend on your local Excel add-ins or volatile functions may differ.

Dates are importing as numbers or in the wrong format

Excel stores dates as serial numbers internally. Depending on your destination, these may appear as raw numbers. In Google Sheets, you can apply a date format to the column after import. In BigQuery, map the column to a DATE type in your schema settings.

Rate limits

My data flow fails with a memory or size limit error

Very large workbooks can exceed Coupler.io's processing limits. Use the Range parameter to restrict the import to only the rows and columns you need (e.g., A1:J5000). Avoid importing entire sheets with hundreds of thousands of rows if only a subset is needed.

Microsoft Excel FAQ

Can I import an Excel file saved on my local computer?

No. Coupler.io can only access Excel files stored in OneDrive or SharePoint. If your file is saved locally, upload it to OneDrive first, then connect it through the file picker. Once it's in OneDrive, any changes you save locally (if OneDrive sync is enabled) will be reflected in future Coupler.io runs.

Can I import multiple sheets from the same workbook?

Yes. In the Sheet(s) field, enter each sheet name on a new line. Coupler.io will pull data from all listed tabs. If you want to stack the data from multiple sheets into one table, enable the Append transformation and turn on Skip header so column headers aren't repeated.

Can I connect Excel files stored in SharePoint (not just personal OneDrive)?

Yes. SharePoint files appear in the file picker as long as you have read access to the document library. If a file isn't showing up, check that it's been shared with your account and that your Microsoft 365 admin hasn't restricted third-party app access to SharePoint.

Does Coupler.io sync formulas or just the values?

Only the calculated values are exported — not the formula expressions. So if a cell contains =SUM(A1:A10), Coupler.io will import the resulting number, not the formula itself.

Can I do a two-way sync between Excel and Google Sheets?

Coupler.io supports one-way data flows — from Excel to your chosen destination. It does not write data back to Excel. If you need to keep both files in sync bidirectionally, that's not a use case Coupler.io currently supports.

Why is data missing after my import runs?

The most common causes are: the sheet name doesn't match exactly (check for typos or extra spaces), the Range parameter is too narrow and excludes some rows, or the sheet contains hidden rows that aren't exported. See the Common Issues article for a full troubleshooting guide.

Can I import images or charts from my Excel workbook?

No. Coupler.io imports cell values only. Images, embedded charts, shapes, and other visual objects are not included.

Can I connect multiple Excel workbooks in one data flow?

Yes. You can add multiple sources to a single data flow — each pointing to a different Excel file. Use the Append transformation to combine their data into one unified table, or Join to merge them on a common key.

Can I send Excel data to an AI tool like ChatGPT or Gemini?

Yes. Coupler.io supports AI destinations including ChatGPT, Claude, Gemini, Perplexity, Cursor, and OpenClaw. You can route your Excel data directly to these tools for analysis, summarization, or other AI-powered tasks.

For details on what data types and fields are supported, see the Data Overview article. For setup recommendations and tips on handling large files, check Best Practices.