# Data Overview

## What data can you import from OneDrive?

OneDrive is a file storage service, so the data you can import depends entirely on what's in your Excel files. Coupler.io treats each Excel file as a data source and pulls the contents of any sheets you specify.

## How it works

When you connect an Excel file from OneDrive, you choose:

1. **Which file** — The specific Excel workbook in your OneDrive
2. **Which sheet(s)** — One or more tabs/sheets within that workbook
3. **Which range** (optional) — A specific cell range, or leave blank to import everything

The data is then synced to your destination on your schedule.

## Data structure

OneDrive Excel files typically have:

* **Headers** — The first row usually contains column names
* **Data rows** — The rows below headers contain your actual data
* **Multiple sheets** — You can consolidate data from different sheets using the Append transformation

## Common use cases

### Marketers

Sync campaign performance data from an Excel tracking sheet in OneDrive to a live Google Sheets dashboard. Pull metrics like impressions, clicks, and conversions, then send them to Claude for automated performance summaries.

### Finance teams

Import expense reports or budget tracking spreadsheets from OneDrive to BigQuery for centralized analysis. Use the Append transformation to combine multiple team budgets into one dataset.

### Sales operations

Keep a CRM data export from OneDrive in sync with Looker Studio for real-time sales dashboards. Append data from multiple regional teams or time periods for unified reporting.

### Product teams

Pull user feedback or bug tracking data from OneDrive, then send it to Perplexity or ChatGPT for automated categorization and summary generation.

## Platform-specific notes

* **Personal OneDrive and OneDrive for Business work the same way** — Just sign in with your Microsoft account and pick your file
* **Shared files are supported** — If someone has shared an Excel file with you, it will appear in the file picker
* **Sheet names matter** — If you rename a sheet after setting up your data flow, you'll need to update the sheet name in the configuration
* **Large files may take longer** — Excel files over 10 MB might take extra time to process
* **Headers are required** — Your Excel sheets should have header rows so Coupler.io knows what each column represents