Import, export and print

What it is

Import turns an Excel or CSV file into a new spreadsheet or into the sheets of an open workbook. Export downloads the current sheet as Excel, CSV, TSV or a web page. Printing prepares A4 pages with a preview and hands them to the browser. From there you can print them or save them as a PDF.

How to use it

Import to a new spreadsheet

In the Spreadsheets section, click From file, or drag the file onto the page.
In the Import from file window, drag the file into the frame or click Choose a file. The formats .xlsx, .xlsm, .xltx, .csv, .tsv and .txt are accepted.
Reading the file… appears, then a preview: the first 50 rows and 30 columns, the sheet size, and the number of formulas. In an Excel workbook with several sheets, the sheets switch by tabs, and hidden ones are marked (hidden). For CSV, you can change the Separator, the Encoding (Automatic, UTF-8, Windows-1251 or GB18030 (Chinese)) and the checkbox First row contains headers.
If there are N warnings, expand them. They show what could not be transferred as it is.
Set the Spreadsheet name and click Import. The window closes by itself, and the new spreadsheet opens. It is separate: it does not appear in Chats.

Import into an open workbook

Below the sheets, next to them: Spreadsheet menu → Import from file…. Choose the file.
In Sheets in file, tick the sheets you need. In the column Where, choose New sheet or an existing sheet of the workbook. An existing sheet is replaced entirely, and its earlier state stays in the version history.
Import → Imported N sheets: “Sheet1” to a new sheet… → Done.

Export

On the right of the toolbar (on a phone, under More tools), click Download spreadsheet, and choose Microsoft Excel (.xlsx), CSV format (.csv), TSV format (.tsv) or Web page (.html). The file takes the name of the spreadsheet.
The current sheet is downloaded over its filled area. Charts and photos from cells go into Excel as pictures. A photo stands in its cell at the height of a row (for a merged cell, at its full height), and several photos stand in a row. While the photos are being collected, the button shows Adding photos to the file… (on a phone, below the header).
A separate chart can be downloaded with the Download PNG button of the selected chart.

Printing

Download spreadsheet → Print and PDF, or Ctrl+P (⌘P) when the focus is in the spreadsheet rather than in an input field.
On the left there are two groups: Page (the area, the portrait and landscape cards, the margins, Fit to width) and Content (Header rows, the grid, the row and column numbers, and the page numbers).
On the right are centred A4 sheets. The preview zoom adjusts to the window; the paper size and the print layout do not change. On a phone, the settings and the pages scroll as one block, and the Print button stays at the bottom. After printing, focus returns to it.
Click Print: the system window opens. For a PDF, choose Save as PDF. An error stays next to the action; fixing the parameters returns the preview.

Limits

Import is available to company members with write rights. Guests with a link cannot import.
A file can be up to 60 MB. Formula cells: up to 4 000 000. Filled cells: up to 4 000 000.
A sheet can have up to 99 999 rows and 999 columns. A CSV beyond that is not imported; from Excel, extra rows and columns are discarded with a warning. A workbook can have up to 50 sheets.
The plan limits the number of spreadsheets, the file uploads per month and the number of rows in one spreadsheet. An upload counts only if the import created a spreadsheet or changed the workbook. A refusal, a conflict or a file error does not use it up.
The reasons for refusal and the import warnings are shown in your interface language.
ZIP64 archives are not supported.
The Import from file and Print windows also close with a click on the dimming. On a phone they are bottom sheets: swipe the handle down; there is no × or Close button there. While printing is being prepared, the Print window does not close. While the file is going into the workbook (Importing…), the import window cannot be closed in any way: the dimming, the handle and Escape do not work, and Cancel and × are disabled. While the file is only being read, the window can be closed.
Export and print are hidden if the owner of the link has forbidden copying. A watermark may be on the print if the owner of the link has enabled it.
Photos from cells go into Excel and into print, but not into CSV, TSV or a web page. In Excel, photos total no more than 200 MB per file. Each one goes out as JPEG, or as PNG if it has a transparent background, and is no more than 2048 pixels on the long side. A photo in an empty cell beyond the edge of the data also goes into the file: the exported area reaches it.
CSV and TSV carry values in the cell’s format. Fractional numbers always use a dot. Month and weekday names, and ИСТИНА/ЛОЖЬ, are always in Russian, regardless of the interface language. Printing and chart pictures in Excel are in the interface language.
Print is A4 only, up to 100 000 cells and up to 200 pages at a time. The Header rows field takes values from 0 to 50.

If something goes wrong

What you see on the screen	Why	What to do
File is larger than 60 MB	The file exceeds the limit	Split the file, or delete unneeded content
The file is empty…, The file is not like XLSX: it is not a ZIP archive, or Sheet “…” is damaged	The file is empty or damaged	Re-save the file in Excel
The file has more than 99 999 rows, or The file has more than 999 columns	The CSV does not fit into a sheet	Split the file
A workbook can have no more than 50 sheets, N free	There is too little room for new sheets	Delete some sheets, or import fewer
Select at least one sheet	No sheet of the file is ticked	Tick a sheet
File uploads for this month are used up — upgrade the plan or wait for the update	The monthly limit is used up	Upgrade the plan, or wait for the new month
Your plan allows no more than N spreadsheets — delete extra ones or upgrade the level	The spreadsheet limit has been reached	Delete a spreadsheet, or upgrade the plan
The file has N rows, but your plan allows M in one spreadsheet	The plan’s row limit	Shorten the file, or upgrade the plan
The spreadsheet was just changed — import again, or The workbook changed during the import, try again	Someone edited the workbook during the import	Repeat the import
The sheet is protected, or The range is protected	The import replaces a protected sheet	Choose New sheet, or ask the owner of the protection
The file’s data does not fit into the spreadsheet	The sheet after the import would exceed the limits	Shorten the file
Too many cells. Select a range., or Too many pages. Select a range.	More than 100 000 cells, or more than 200 pages	Choose Selection or a smaller range
Column does not fit. Turn on “Fit to width”.	A column is wider than the page	Turn on Fit to width, or Landscape
The row does not fit. Reduce the height., The merge does not fit…, or The header does not fit…	An element is taller or wider than the page	Reduce the row, the merge or Header rows
Images are loading. Try printing again.	Photos are still loading	Wait, and click Print again
Some photos were left out of the file: N — could not load, in Download spreadsheet	A photo did not download, or did not convert to the needed format. The file was downloaded without it	Refresh the page and download again
Some photos were left out of the file: N — the file would exceed 200 MB	The sheet’s photos together exceed 200 MB. The file was downloaded without the extra ones	Move some photos to another sheet