Best Practices

Recommended setup

Store your file in OneDrive or SharePoint before connecting

Coupler.io only works with cloud-stored Excel files. Upload your workbook to OneDrive first — trying to connect a locally saved file is the most common setup mistake.

Use the Range parameter for large workbooks

If your sheet has thousands of rows but you only need a portion of them, set a specific range (e.g., A1:M2000). This reduces processing time and avoids memory limit errors.

Name your sheets clearly before connecting

Sheet names are entered manually and are case-sensitive. Rename ambiguous tabs (like "Sheet1") to descriptive names before setting up your data flow — it's harder to fix later without breaking the configuration.

Data refresh and scheduling

Run a successful manual sync first

You must complete a successful manual run before you can schedule your data flow. Use the manual run to confirm the right sheets and ranges are loading correctly.

Don't rely on Coupler.io to detect Excel changes automatically

Coupler.io syncs on a schedule — it doesn't watch for changes in your Excel file. Set a refresh interval that matches how often your source data actually updates (e.g., daily for weekly reports).

Performance optimization

Combine multiple sheets using Append instead of separate data flows

If you need data from several tabs (e.g., monthly sheets), add them all in a single source using the Sheets field and enable Append. This is more efficient than creating one data flow per tab.

Remove volatile formulas from sheets used as sources

Functions like NOW(), TODAY(), or RAND() recalculate constantly and can produce inconsistent results on export. Replace them with static values in a dedicated export sheet if consistency matters.

Common pitfalls

Local files won't work. If your Excel file is only saved on your computer and not synced to OneDrive, the file picker won't find it and your data flow will fail. Always confirm the file is accessible via OneDrive or SharePoint before setting up a connection.

Do

• Enter sheet names exactly as they appear in the Excel tab (case-sensitive)

• Use the Range parameter to limit large imports

• Upload your file to OneDrive before connecting

• Use Append to consolidate multiple sheets into one dataset

Don't

• Try to import local Excel files not stored in OneDrive or SharePoint

• Import entire sheets with hundreds of thousands of rows if only a portion is needed

• Rely on embedded images or charts being included in the export

• Expect two-way sync — Coupler.io exports data from Excel, it does not write back to it