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.