# Common Issues

## Connection issues

<details>

<summary>I can't find my file in the file picker</summary>

This usually means you're connected to the wrong Dropbox account. Coupler.io shows files from the Dropbox account you authorized during setup.

**Fix:** Sign out of all Dropbox accounts in your browser, then sign back in to the account that contains your file. Return to Coupler.io, refresh the file picker, and try again. If you need to switch accounts, you may need to disconnect and reconnect Dropbox in your Coupler.io account settings.

</details>

<details>

<summary>"File is no longer available to the current connection"</summary>

This error appears when the Dropbox connection has expired or the file has been moved/deleted since you set up the data flow.

**Fix:**

1. Check that the file still exists in Dropbox at the same location
2. If the file was moved, update the file selection in your data flow
3. If the connection has expired, disconnect Dropbox and reconnect by clicking "Connect to Dropbox" again in your data flow settings

</details>

<details>

<summary>I'm seeing a login screen when I try to connect</summary>

Dropbox is asking you to authenticate. Make sure you're signing in with the account that has access to the files you want to import.

**Fix:** Sign in with your Dropbox credentials and grant Coupler.io permission to access your files. If you're having trouble, try clearing your browser cache or using an incognito window.

</details>

## Missing data

<details>

<summary>Only part of my spreadsheet is being imported</summary>

You may have set a custom range (like A1:Z100) that's limiting the import, or the sheet contains blank rows that are being skipped.

**Fix:**

1. Check your data flow settings and look at the "Range" field
2. If a range is set and you want all data, clear it
3. Ensure your spreadsheet has headers in the first row — data without headers may not import correctly
4. Run a manual test to see exactly what's being pulled

</details>

<details>

<summary>Columns are missing from my import</summary>

This can happen if columns are formatted strangely, hidden, or contain only blank values.

**Fix:**

1. Open the original file in Dropbox and verify the columns exist and contain data
2. Check that no columns are hidden in the spreadsheet
3. If using a custom range, make sure all columns you need are included in the range (e.g., A1:Z100 covers columns A through Z)
4. Run a manual test to see which columns are being detected

</details>

<details>

<summary>Data from multiple sheets isn't being appended</summary>

You may have selected only one sheet, or the sheets have different column structures.

**Fix:**

1. Return to your data flow and select all sheets you want to import
2. Ensure all sheets have the same column headers in the same order — if column names differ, Coupler.io treats them as separate columns
3. If sheets have different structures, consider running separate data flows or aligning the sheet headers first

</details>

## Permission errors

<details>

<summary>"Permission denied" or "Access forbidden"</summary>

The Dropbox account you're connected with doesn't have permission to access the file.

**Fix:**

1. Verify you're signed in to the correct Dropbox account (the one with access to the file)
2. If the file is shared with you, make sure the sharing permission level allows reading/access
3. Disconnect Dropbox and reconnect with the account that has the proper permissions

</details>

## Data discrepancies

<details>

<summary>Formula values aren't appearing in my destination</summary>

Coupler.io imports the calculated value of a formula, not the formula itself. However, sometimes calculated values may not display correctly if the spreadsheet isn't saved in the right format.

**Fix:**

1. Save your Excel file in .xlsx format (not .xls or other formats)
2. Open the file in Excel or Excel Online and ensure formulas are recalculated and saved
3. Run a manual test in Coupler.io to see if the values now appear
4. If using a Google Sheet exported to Dropbox, ensure it was exported with current values calculated

</details>

<details>

<summary>Numbers are being imported as text</summary>

This happens when your spreadsheet cells are formatted as text instead of numbers, or if your CSV uses a comma as a decimal separator.

**Fix:**

1. In the original spreadsheet, select the numeric columns and change their format to "Number"
2. Re-save the file and run another import
3. If using a CSV, check that your locale settings match (e.g., comma vs. period for decimals)
4. In your destination, you can also format columns after import

</details>

<details>

<summary>Dates are showing incorrectly in my destination</summary>

Date formats can vary by locale and spreadsheet application. Coupler.io imports the date value but your destination may interpret it differently.

**Fix:**

1. In your Dropbox spreadsheet, ensure dates are formatted as actual date cells (not text)
2. After import, manually format the date columns in your destination to match your preferred format
3. If dates are still wrong, check your Coupler.io account timezone settings

</details>

## Rate limits

<details>

<summary>My data flow is running slowly or timing out</summary>

Large files or frequent refreshes can cause slowdowns. Dropbox rate limits may also apply if you're running many data flows simultaneously.

**Fix:**

1. If importing a very large file (100,000+ rows), consider splitting it into smaller ranges or files
2. Avoid running multiple data flows on the same Dropbox account at the same time
3. Space out scheduled refreshes — instead of running every 15 minutes, try hourly or daily
4. Use a data warehouse like BigQuery as your destination for better performance with large datasets

</details>