Native SheetsGuides
Guides to working with .xlsx files
Practical guides to opening, editing and checking .xlsx workbooks on macOS: what is inside the file format, which formulas recalculate, and what a save keeps.
How to open and edit an .xlsx file on a Mac without Excel
Four ways to open a .xlsx workbook on macOS without a Microsoft 365 subscription, what each one changes about the file, and how to check a workbook in the browser first.
Why charts and pivot tables disappear when you edit someone else's workbook
What is actually inside an .xlsx file, why a save in the wrong app strips charts, pivot caches and conditional formatting, and how to check whether your own workflow does it.
Will my formulas work? The functions Native Sheets evaluates, and the ones it does not
The complete list of the 91 spreadsheet functions Native Sheets evaluates, what happens to a formula it cannot evaluate, and how to test your own workbook before you rely on it.