Skip to main content

Troubleshooting Spreadsheets

At a glance​

This guide covers common issues with Spreadsheets: import errors, editing problems, export failures, and synchronization.

Import issues​

CSV import: special characters displayed incorrectly​

Cause: The file encoding does not match the one selected.

Solutions:

  1. Retry the import by selecting Latin-1 (ISO 8859-1) instead of UTF-8.
  2. Open the file in a text editor and check the actual encoding.
  3. Convert the file to UTF-8 before importing.

CSV import: misaligned columns​

Cause: The detected delimiter does not match the actual file delimiter.

Solutions:

  1. Retry the import by manually selecting the correct delimiter (comma, semicolon, tab).
  2. Verify that values containing commas are enclosed in quotes in the source file.

Excel import: "Unsupported format"​

Possible causes:

  • The file is in the old .xls format (Excel 97-2003)
  • The file is password-protected
  • The file exceeds the maximum size (50 MB)

Solutions:

  1. Convert the file to .xlsx (modern Excel format).
  2. Remove the password protection before importing.
  3. Split the file into smaller parts.

Import: skipped rows​

Cause: Some rows contain values incompatible with the defined column type.

Solutions:

  1. Review the import report to see the rows with errors.
  2. Fix the values in the source file and re-import.
  3. Change the column type to Text to accept all values, then correct manually.

Editing issues​

Unable to edit a cell​

Possible causes:

  • The spreadsheet is a synchronized spreadsheet (read-only)
  • You do not have editing permissions

Solutions:

  1. Check if the spreadsheet is in the Synchronized data tab (read-only) or My spreadsheets (editable).
  2. Contact the workspace administrator to obtain editing permissions.

Modification not saved​

Cause: A connection issue occurred during saving.

Solutions:

  1. Check your internet connection.
  2. Refresh the page and verify if the modification was saved.
  3. Re-enter the value if necessary.

Export issues​

CSV export: missing accents​

Cause: The application opening the file does not use UTF-8 encoding.

Solutions:

  1. In Excel: use Data > From Text File and select UTF-8 as the encoding.
  2. In Google Sheets: import the file with File > Import (UTF-8 is the default).

Export: empty file​

Cause: A filter is active and no rows match.

Solution: Disable all filters before exporting, or verify that the active filter returns results.

Synchronization issues​

Synchronized spreadsheet not updated​

Possible causes:

  • The Live Data source is disconnected
  • The last synchronization failed

Solutions:

  1. Check the source status in Live Data.
  2. Click Refresh to force a resynchronization.
  3. See Troubleshooting Live Data for synchronization errors.

Missing columns in a synchronized spreadsheet​

Cause: The source schema has changed since the last synchronization.

Solution: Run a schema discovery again from the Live Data source configuration.

Form issues​

Public form inaccessible​

Possible causes:

  • The Public form option is disabled
  • The link has been regenerated

Solutions:

  1. Verify that the Public form option is enabled in the form settings.
  2. Retrieve the new public link and redistribute it.

Responses not saved​

Cause: The form references columns that have been deleted from the spreadsheet.

Solution: Edit the form and verify that all fields are linked to existing columns.

See also​

Need help?​

Contact us: Support and contact.