Excel and CSV files
Open Excel, OpenDocument and CSV files as spreadsheets, download as Excel or CSV, copy and paste with other spreadsheets, and print or save as PDF.
Open a file
Spreadsheets > Open a file (or File > Open an Excel or CSV file) and choose a file up to 25 MB: .xlsx, .xls, .xlsm, .ods, .csv or .tsv. It becomes a new spreadsheet with:
- every sheet, value and formula;
- number formats, merged cells, column widths, row heights and hidden rows and columns;
- named ranges.
Charts, pictures, macros and pivot tables inside the file are not brought in. Make charts again with Insert > Chart, and pivots from your apps with App data.
Download
- File > Download as Excel (.xlsx) - every sheet, with formulas, number formats, merged cells and column widths. App-data formulas (ELLIBO.) go out as their values, because other spreadsheets can't read your apps.
- File > Download this sheet as CSV - the values of the sheet you're on.
Copy and paste
Copy cells (Ctrl+C) and paste them (Ctrl+V) into Excel, other online spreadsheets or a document - and the other way round. Inside Spreadsheet, formulas and formatting come along; Edit > Paste values only and Paste formatting only paste just one of them. When the selection is bigger than what you copied (and a multiple of it), the copy repeats to fill it.
Print or save as PDF
File > Print or save as PDF opens a page with the sheet (or the cells you selected) and its charts, ready to print. Choose Save as PDF as the printer to keep a PDF.