Does it get the numbers right?
We converted real workbooks, opened them in the real products, and compared every formula's result with the value the original calculated. Here's what came out.
Almost every cell, every time
126,268 formula cells in 27 real workbooks, each converted file opened by Google Sheets' own import, the way you'll open yours. What's left over, the 0.01%, is explained on the page about how we test.
Real workbooks, start to finish
- A Spanish payroll196 / 196formulas matchIts locale, Spanish (Spain), was detected from the file. Opened with US settings instead, 46 of these cells would have come out different.
- A large model1,916 / 1,916formulas matchEvery formula matches. Two conditional-formatting rules couldn't be carried over, and the report lists them.
- A workbook built on Excel tables280 / 280formulas matchFormulas like =SUM(Sales[Amount]) are rewritten as ordinary ranges Google Sheets understands.
- A workbook linked to other files73 / 73formulas matchIts 270 links to another workbook can't work in Google Sheets: they keep Excel's values, so everything that reads them still adds up, and they're listed.
What still needs you
The locale
Google's import gives the new Sheet your own settings, not the author's. We detect the right one from the file and show you where to set it.
Circular references
Models that calculate in circles show #REF! in Google Sheets until iterative calculation is on. We give you the exact setting, only when your workbook needs it.
Links to other workbooks, web lookups, data cubes, What-If tables. They keep their value, so the formulas that read them still work.
Pivot tables, images, macros, data bars, icon sets, dropdowns that grow with a list, chart trendlines. The Report tab lists any your workbook has.
Don't take our word for it
The file you get back checks itself. Open it in Google Sheets, and its Report tab compares every converted cell with Excel's value, calculated by Google Sheets in your own file. Try it on a workbook you know well.
How we test, and every result →For anyone signing off on a migration: six collections of real workbooks, whether the Report tab can be trusted, and what still differs.