Import and export

Import CSV into a sheet, export a sheet as CSV, and export a whole workbook as Excel.

Bring data into a workbook from CSV or Excel files and take it out again. For text and TSV files, OpenDocument, Google Sheets links, .ods export and printing to PDF, see Import, export and print.

Before you start: importing a CSV into a workbook needs Can edit. Creating a workbook from Excel needs Full control. Exporting needs Can view.

Import a CSV as a new sheet

  1. Open the workbook.
  2. Click Import in the sheet strip, choose From a file (.csv, .tsv, .txt)… and pick the file.
  3. A new sheet is added, named after the file.

How it works:

  • The first row is the header and becomes the column labels. An empty header cell gets its column letter.
  • Column types are guessed from up to 200 values: Number, Date, Checkbox (TRUE or FALSE) or Text.
  • A value that cannot be read into its column is left empty. The import does not stop.

Import an Excel file as a new workbook

See Create and import workbooks.

Export a sheet as CSV

Open the sheet's tab menu › Export CSV. The file is named after the sheet. Row one holds the column labels. Formula cells export their results.

Export the whole workbook as Excel

Choose Export → Excel workbook (.xlsx) in the top bar. The file includes values and formula sources so Excel can recalculate.

Limits and errors

Message Meaning
empty file The CSV has no rows.
too many columns More than 200 columns.
too many rows (max N) Over your plan's rows per sheet. See Limits.
tab limit reached The workbook already has 20 sheets.
bad csv / bad xlsx The file could not be read.

To get every row of a large query into a new workbook, see Export all rows of a query.

Troubleshooting

The import button is missing You only have Can view.

Export failed Try again. If it keeps failing, check that you can still open the workbook.