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