Open and save .xlsx files.
Open and save .xlsx, older .xls and binary .xlsb workbooks, and .csv files, each kept in its own format. Anything Cloud Sheets doesn't edit yet is kept as it was when you save.
Formulas you know.
485 functions, from SUM and VLOOKUP to XLOOKUP, FILTER and the financial and statistical ones, with dynamic arrays that spill. Every function is checked against Excel's own results.
Formatting.
Fonts, fills, borders, alignment and merged cells, number formats for currency, percent and dates, conditional formatting with color scales, data bars and icons, and data validation.
Tables, sort and filter.
Format a range as a table with its own styles and total row. Sort and filter columns, find and replace, remove duplicates, and freeze the rows and columns you want to keep in view.
Charts.
Column, bar, line, pie, area, scatter and radar charts, and combos, made from your cells in a click. They update when the numbers do.
Pictures and shapes.
Put pictures, shapes, arrows and text boxes over your cells, and they move with the cells as you insert rows and columns.
Print and save as PDF.
Margins, paper, orientation, fit to a page, headers and footers and titles repeated on each page, with a preview of the pages before you print or save a PDF.
An assistant, if you want one.
Ask about a workbook or have it build formulas and tables, with your own Claude API key or your ChatGPT plan. Every change it makes is shown to you first and can be undone.
Keeps your work.
A copy of an unsaved workbook is kept every few minutes, so if Cloud Sheets ever closes unexpectedly it's offered when you open it again. It updates itself too.