Menu
Home Explore People Places Arts History Plants & Animals Science Life & Culture Technology
On this page
Comparison of spreadsheet software
List article

Spreadsheet is a class of application software design to analyze tabular data called "worksheets". A collection of worksheets is called a "workbook". Online spreadsheets do not depend on a particular operating system but require a standards-compliant web browser instead. One of the incentives for the creation of online spreadsheets was offering worksheet sharing and public sharing or workbooks as part of their features which enables collaboration between multiple users. Some on-line spreadsheets provide remote data update, allowing data values to be extracted from other users' spreadsheets even though they may be inactive at the time.

General

NameDeveloperInitial releasePlatformLatest releaseLicense
VersionDate
Apache OpenOffice CalcApache Software Foundation2012-05-08Linux4.1.151 2023-12-22Apache-2.0
macOS
Windows
AppleWorksApple Inc.1991macOS6.2.92 2004-01-14Proprietary
Windows6.2.23 2004-01-20
Calligra SheetsKOffice KSpread TeamBSD4.0.14 2024-09-02LGPL
Linux
macOS
Windows
Collabora Online CalcCollabora20195Android24.04.11.46 2025-03-03MPL-2.0
20217BSDBuild your ownBuild your own
20198ChromeOS24.04.11.49 2025-03-03
201910iOS24.04.1211 2025-03-04
201912iPadOS24.04.1213 2025-03-04
201614LinuxOnline server: 24.04.12.415 2025-02-21
201516Desktop app: 24.04.1217 2025-01-30
201518macOS24.04.1219 2025-01-30
201520Windows24.04.1221 2025-01-30
Google SheetsGoogle200622Android23RollingRollingProprietary
ChromeOS24
iOS25
Linux26
macOS27
Windows28}
GNU OleoTom Lord1992Linux1.6.1629 1999-03-10GPL-3.0-or-later
GnumericGNOME community199830BSD1.12.5931 2025-03-01GPL-2.0-onlyorGPL-3.0-only
Linux
macOS
Windows32
Gobe ProductiveGobe Software1998-08BeOS2.0.1332000-02-29Proprietary
2001-12-1234Windows3.04352003-07-08
IBM Lotus SymphonyIBM2008Linux3.0.1 FP23637 2012-11-29Proprietary
macOS
Windows
LibreOffice CalcThe Document Foundation2011-01-2538BSD24.239 2024-01-31MPL-2.0
Linux
macOS
Unix
Windows
Mariner CalcMariner Software198940iOS?5.6.0DroppedProprietary
Microsoft Excel41Microsoft2015-06-25Android16.0.15128.202062022-09-30Proprietary
2017-11 42ChromeOS?Dropped 2021-09-18 43
2013-06 44iOS2.662022-10-10
2014-02 45iPadOS??
1985macOS16.652022-09-13
1989OS/23.0Dropped
1987Windows22092022-09-26
Microsoft WorksMicrosoft1987-09-14DOS3.0b 1993Proprietary
1988macOS4.0b 1994
1991Windows946 2007-09-28
NumbersApple, Inc.2010-01-27iOS12.12022-06-21Proprietary
2007-08-07macOS12.12022-06-21
OnlyOfficeAscensio System SIA201447Linux8.3.048 2025-02-06AGPL-3.0-only
macOS
Windows
OpenOffice.org CalcSun Microsystems49Oracle Corporation502002-05BSD3.3.051 2011-01-17Apache-2.0
Linux
macOS
Solaris/Illumos
Unix
Windows
PlanMakerSoftMaker Software GmbH19945253Android20242023-06-20Proprietary
Linux
macOS
Windows
PyspreadMartin Manns200854BSD2.455 2025-03-19GPL-3.0-or-later
Linux
Unix
Windows
Quattro ProCorel198856Windows20202020Proprietary
Resolver OneResolver Systems2008-01-1657Windows1.92010-06-04Proprietary
scJames Gosling et al19817.1658 2002-09-20Public domain
SiagUlric Eriksson59BSD3.6.160 2006-11-10GPL-2.0-or-later
Linux
Unix
Windows
Sourcetable61Sourcetable Inc.202062ChromeOSRollingRollingProprietary
StarOffice StarCalcSun Microsystems1994Linux9.0U3636465 2009-09-09Proprietary
macOS
Windows
WPS OfficeKingsoft2012-03-23Android16.3.72022-07-22Proprietary
1988DOSDropped
2014Linux11.1.0.116642022-06-08
2014iOS11.24.12022-07-14
2019macOS4.2.12022-07-15
1988Windows11.2.0.111912022-07-05
NameDeveloperInitial releasePlatformLatest releaseLicense
VersionDate

Operating system support

The operating systems the software can run on natively (without emulation). Android and iOS apps can be optimized for Chromebooks and iPads which run the operating systems ChromeOS and iPadOS respectively, the operating optimizations include things like multitasking capabilities, large and multi-display support, better keyboard and mouse support.

NameWindowsmacOSLinuxBSDUnixAndroidChromeOS optimizediOSiPadOS optimized
Apache OpenOffice CalcYesYesYesNoNoNoNoNoNo
Calligra SheetsYesYesYesYesNoNoNoNoNo
Collabora Online CalcYesYesYesYesYesYesYes66YesYes
Google SheetsYesYesYesNoNoYesYesYesYes
GnumericOld versionsNoYesYesYesNoNoNoNo
IBM Lotus SymphonyYesYesYesNoNoNoNoNoNo
LibreOffice CalcYesYesYesYesYesNoNoNoNo
Mariner CalcNoUnsupportedNoNoNoNoNoYesNo
Microsoft ExcelYesYesNoNoNoYesDropped 2021-09-18 67YesYes
NumbersNoYesNoNoNoNoNoYesYes
PlanMakerYesYesYesNoNoYes?NoNo
PyspreadYesUnsupportedYesYesYesNoNoNoNo
Quattro ProYesNoNoNoNoNoNoNoNo
Resolver OneYesNoNoNoNo????
SiagNoYesYesYesYesNoNoNoNo
WPS OfficeYesYesYesNoNoYes?Yes?

Supported file formats

This table gives a comparison of what file formats each spreadsheet can import and export. "Yes" means can both import and export.

NameCSVExcel(xls)HTMLLaTeXODF(ods)OOXML(xlsx)PDFDIFOpenOffice.org XML(sxc)
Apache OpenOffice CalcYesYesYesExport68YesImportExportYesYes
Calligra SheetsYesImportExportExportYesNoExport?Yes
Collabora Online Calc - online and mobileYesYesNoNoYesYesExportNoNo
Collabora Online Calc - desktopYesYesYesExport6970YesYesExportYesYes
Google SheetsImportImportNoNoYesYesExportNoNo
GnumericYesYesYesExportYesYesExportImportImport
IBM Lotus SymphonyYesYesExportNoYesImportExportYes
LibreOffice CalcYesYesYesExport7172YesYesExportYesYes
Mariner CalcYesYesNoNoNoNoExportNo
Microsoft ExcelYesYesPartialNoYesYesExportYesNo
WPS OfficeYesYesPartialNoYesYesExportImportNo
NumbersYesYesNoNoImportImportExportNo
Quattro ProYesYesYesNoNoYesExportNo
PlanMakerYesYesExportNoNoYesExportNo
PyspreadYesYesNoNoImportImportExportNo
Resolver OneYesYesNoNoNoNoNoNo
SiagYesImport partialYesExportNoNoExportImport partial
Sourcetable73YesYesImport partialNoImport partialYesNoNo

Rows and Columns

ProgramRows (per sheet)Columns (per sheet)Total cells (per sheet)SheetsTotal cells (per workbook)
Collabora Online 22.05, or later versions – Online, Desktop, Tablet, Mobile1,048,5767416,38417,179,869,184751,02417,592,186,044,400
Gnumeric16,777,21616,384274,877,906,944142,648603,103
Google Sheets1,048,57618,27810,000,00020010,000,000
KSpread32,76732,7671,073,676,289130,645953,923
LibreOffice Calc 5.4.5 – 7.31,048,5761,0241,073,741,8241,0241,099,511,627,776
LibreOffice Calc 7.4, or later versions1,048,5767616,38417,179,869,184771,02417,592,186,044,400
Lotus 1-2-37865,53625616,777,2162564,294,967,296
Microsoft Excel 200365,53625616,777,21665,5311,099,427,741,696
Microsoft Excel 2007, or later versions7980811,048,57616,38417,179,869,184Limited by available memoryLimited by available memory
OpenOffice.org Calc 28265,53625616,777,2162564,294,967,296
OpenOffice.org Calc 3.0, 3.1 and 3.2838465,536102467,108,86425617,179,869,184
OpenOffice.org Calc 3.3851,048,57610241,073,741,824256274,877,906,944
Pyspread~80 000 000 (limited by sum of row heights)~30 000 000 (limited by sum of column widths)Limited by available memoryLimited by available memoryLimited by available memory
Resolver Onelimited by machine memory*limited by machine memory*limited by machine memory*limited by machine memory*limited by machine memory*
Sourcetable861,048,57618,27810,000,00020010,000,000

-* 32-bit addressable memory on Microsoft Windows, i.e. ~2.5 GB.

See also

Notes

References

  1. "Announcing Apache OpenOffice 4.1.15". 22 December 2023. Retrieved 25 February 2024. https://openoffice.apache.org/blog/announcing-apache-openoffice-4-1-15.html

  2. "AppleWorks 6.2.9 for Mac". 14 January 2004. https://support.apple.com/kb/DL617

  3. "AppleWorks 6.2.2 for Windows". 20 January 2004. https://support.apple.com/kb/DL616

  4. https://github.com/KDE/calligra/releases/tag/v4.0.1. {{cite web}}: Missing or empty |title= (help) https://github.com/KDE/calligra/releases/tag/v4.0.1

  5. The app uses LibreOffice kit technology and is based on Collabora Online for which development started in 2013.

  6. "Collabora Office". https://play.google.com/store/apps/details?id=com.collabora.libreoffice&pli=1

  7. Version 21.11. Using LibreOffice kit technology, development started in 2013.

  8. The app uses LibreOffice kit technology and is based on Collabora Online for which development started in 2013.

  9. "Collabora Office". https://play.google.com/store/apps/details?id=com.collabora.libreoffice&pli=1

  10. The app uses LibreOffice kit technology and is based on Collabora Online for which development started in 2013.

  11. "Collabora Office". https://apps.apple.com/us/app/collabora-office/id1440482071

  12. The app uses LibreOffice kit technology and is based on Collabora Online for which development started in 2013.

  13. "Collabora Office". https://apps.apple.com/us/app/collabora-office/id1440482071

  14. Version 1.0. Using LibreOffice kit technology, development started in 2013.

  15. "Collabora Online 24.04 Release Notes". https://www.collaboraoffice.com/collabora-online-24-04-release-notes/

  16. Version 4.4.

  17. "Collabora Office 24.04 Release Notes". https://www.collaboraoffice.com/collabora-office-24-04-release-notes/

  18. Version 4.4.

  19. "Collabora Office 24.04 Release Notes". https://www.collaboraoffice.com/collabora-office-24-04-release-notes/

  20. Version 4.4.

  21. "Collabora Office 24.04 Release Notes". https://www.collaboraoffice.com/collabora-office-24-04-release-notes/

  22. Development started 2006.

  23. Offline editing when used with Chrome or Edge web browser.

  24. Offline editing when used with Chrome web browser.

  25. Offline editing when used with Chrome or Edge web browser.

  26. Offline editing when used with Chrome web browser.

  27. Offline editing when used with Chrome or Edge web browser.

  28. Offline editing when used with Chrome or Edge web browser.

  29. "ChangeLog". 22 November 2000. Archived from the original on 8 January 2001. https://web.archive.org/web/20010108070700/http://www.gnu.org/software/oleo/ChangeLog

  30. Development started 1998.

  31. "Gnumeric 1.12.59 aka "TBD" is now available". 1 March 2025. Retrieved 2 March 2025. http://www.gnumeric.org/announcements/1.12/gnumeric-1.12.59.html

  32. Old versions.

  33. "Productive BeOS". Archived from the original on 2001-12-23. https://web.archive.org/web/20011223101948/http://www.gobe.com/storegobeproductive.html

  34. "Windows Release". Archived from the original on 2002-02-04. https://web.archive.org/web/20020204040701/http://www.gobe.com/press/pr12_12_2001.html

  35. "Gobe Corporation". Archived from the original on 2003-10-04. https://web.archive.org/web/20031004234541/http://gobe.com/

  36. "IBM Lotus Symphony - Buzz: Symphony 3.0.1 FIXPACK 2 is Now AVAILABLE". 29 November 2012. Archived from the original on 29 January 2013. https://web.archive.org/web/20130129154811/http://www-03.ibm.com/software/lotus/symphony/buzz.nsf/web_DisPlayPlugin?open&unid=47F01C7A565AB6B885257AC5004E5713&category=announcements

  37. "IBM Lotus Symphony - Release Notes". Archived from the original on 26 April 2011. https://web.archive.org/web/20110426031236/http://www-03.ibm.com/software/lotus/symphony/help.nsf/ReleaseNotes?OpenForm&version=3%20fix%20pack%202

  38. Version 3.3. Development started 2010.

  39. https://wiki.documentfoundation.org/ReleaseNotes/24.2. {{cite web}}: Missing or empty |title= (help) https://wiki.documentfoundation.org/ReleaseNotes/24.2

  40. Development started 1988.

  41. Started as Multiplan in 1982. /wiki/Multiplan

  42. "Microsoft Office finally available for all Chromebooks". 2017-11-27. Retrieved 2022-12-01. ...Without any fanfare, Microsoft finally made Word, Excel, Outlook, and PowerPoint available for (apparently) all Chromebooks. https://www.notebookcheck.net/Microsoft-Office-finally-available-for-all-Chromebooks.266710.0.html

  43. "Office apps for Chromebook to be stopped". 2021-08-31. Retrieved 2022-12-01. ...it's too expensive to support Office apps on the larger screen Chromebook devices which are rivalling Windows in some markets. https://office-watch.com/2021/office-apps-for-chromebook-to-be-stopped/

  44. "Microsoft launches Office iOS app but no iPad version yet". 2013-06-15. Archived from the original on 2024-08-17. Retrieved 2022-12-01. ...Requires active Office 365 subscription to edit Word, Excel and PowerPoint files, but no iPad version for now. https://www.theguardian.com/technology/appsblog/2013/jun/14/microsoft-office-365-iphone-app/

  45. "Microsoft announces Office for iPad, extending productivity to all iOS devices". 2014-02-27. Archived from the original on 2022-12-02. Retrieved 2022-12-01. ...Office 365 subscription is needed to edit as well as create documents. https://www.pcworld.com/article/444564/microsoft-announces-office-for-ipad-extending-productivity-to-all-ios-devices.html

  46. "Microsoft Works - Microsoft Lifecycle". Archived from the original on 23 January 2022. https://web.archive.org/web/20220123024815/https://docs.microsoft.com/en-us/lifecycle/products/microsoft-works

  47. Development started 2009.

  48. "Release ONLYOFFICE-DesktopEditors-8.3.0 · ONLYOFFICE/DesktopEditors". Retrieved 6 February 2025. https://github.com/ONLYOFFICE/DesktopEditors/releases/tag/v8.3.0

  49. 1999 – 2009.

  50. 2010 – 2011

  51. "3.3.0 - Release Notes". https://www.openoffice.org/development/releases/3.3.0.html

  52. "Infos zu PlanMaker 97". 1997-06-03. Archived from the original on 1997-06-03. Retrieved 2010-03-28. https://web.archive.org/web/19970603185443/http://www.softmaker.de/planmake.htm

  53. Andy Updegrove (2006-07-05). "The Emerging ODF Environment, Part IV: Spotlight on SoftMaker Office 2006". Archived from the original on 2016-12-23. Retrieved 2010-03-28. http://www.consortiuminfo.org/standardsblog/article.php?story=2006070509040463

  54. Development started 2008.

  55. https://pypi.org/project/pyspread/. {{cite web}}: Missing or empty |title= (help) https://pypi.org/project/pyspread/

  56. Development started 1988.

  57. Development started 2005.

  58. http://www.ibiblio.org/pub/Linux/apps/financial/spreadsheet/!INDEX.html. {{cite web}}: Missing or empty |title= (help) http://www.ibiblio.org/pub/Linux/apps/financial/spreadsheet/!INDEX.html

  59. Development started 1996.

  60. "Siag Office 3.6.1". 10 November 2006. Archived from the original on 23 April 2017. https://web.archive.org/web/20170423072333/http://siag.nu/hypermail/siag/0061.html

  61. AI Spreadsheet. Sourcetable Inc., 2024. Retrieved 2024-11-14. https://sourcetable.com

  62. Development started 2020.

  63. "StarOffice Software". Archived from the original on 27 September 2009. https://web.archive.org/web/20090927201415/http://www.sun.com/software/staroffice/index.jsp

  64. "StarOffice Patches". Archived from the original on 22 September 2009. https://web.archive.org/web/20090922191515/http://sunsolve.sun.com/show.do?target=patches/zp-Software_Desktop_Applications_StarOffice

  65. "StarOffice/StarSuite Updates". Archived from the original on 23 September 2009. https://web.archive.org/web/20090923004126/http://sunsolve.sun.com/show.do?target=patches/soffice

  66. "Collabora Office on iOS and Android Just got Better!". Adfinis. 2020-12-15. Retrieved 2021-01-15. ...touch optimized interfaces: one for tablets and one for phone screens. ...(iOS, iPadOS, Chrome OS, Android). https://adfinis.com/en/blog/collabora-office-on-ios-and-android-just-got-better/

  67. "Office apps for Chromebook to be stopped". 2021-08-31. Archived from the original on 2024-08-17. Retrieved 2022-12-01. ...it's too expensive to support Office apps on the larger screen Chromebook devices which are rivalling Windows in some markets. https://office-watch.com/2021/office-apps-for-chromebook-to-be-stopped/

  68. Through extensions: "Calc2LaTeX". 2009-07-15. Archived from the original on 2012-04-29. Retrieved 2012-05-06. http://extensions.openoffice.org/en/project/Calc2LaTeX

  69. Through extensions: "TexMaths". 2021-03-14. Archived from the original on 2024-08-17. Retrieved 2021-08-09. https://extensions.libreoffice.org/en/extensions/show/texmaths-1

  70. Through extensions: "Writer2LaTeX". 2018-10-19. Archived from the original on 2021-08-04. Retrieved 2021-08-09. https://extensions.libreoffice.org/en/extensions/show/writer2latex-1

  71. Through extensions: "TexMaths". 2021-03-14. Archived from the original on 2024-08-17. Retrieved 2021-08-09. https://extensions.libreoffice.org/en/extensions/show/texmaths-1

  72. Through extensions: "Writer2LaTeX". 2018-10-19. Archived from the original on 2021-08-04. Retrieved 2021-08-09. https://extensions.libreoffice.org/en/extensions/show/writer2latex-1

  73. AI Spreadsheet. Sourcetable Inc., 2024. Retrieved 2024-11-14. https://sourcetable.com

  74. "16,777,216 row limit is a setting under experimental features". Websetnet. 5 August 2020. https://websetnet.net/libreoffice-7-0-beta-1-arrives-with-odf-1-3-document-support/

  75. "274,877,906,944 cells when the 16,777,216 experimental row limit is enabled". documentfoundation.org. Archived from the original on 2024-08-17. https://bugs.documentfoundation.org/show_bug.cgi?id=50916

  76. "16,777,216 row limit is a setting under experimental features". Websetnet. 5 August 2020. https://websetnet.net/libreoffice-7-0-beta-1-arrives-with-odf-1-3-document-support/

  77. "274,877,906,944 cells when the 16,777,216 experimental row limit is enabled". documentfoundation.org. Archived from the original on 2023-09-24. https://bugs.documentfoundation.org/show_bug.cgi?id=50916

  78. "Limitations of 1-2-3 for Windows". IBM. Archived from the original on 2013-01-03. Retrieved 2008-04-10. https://archive.today/20130103060417/http://www-1.ibm.com/support/docview.wss?uid=swg27003548

  79. "Excel specifications and limits". MS Office Support. Microsoft. Archived from the original on 2016-11-28. Retrieved 2016-11-28. https://support.office.com/en-gb/article/Excel-specifications-and-limits-16c69c74-3d6a-4aaf-ba35-e6eb276e8eaa

  80. "Excel specifications and limits". MS Office Support. Microsoft. Archived from the original on 2020-04-28. Retrieved 2016-11-28. https://support.office.com/en-us/article/Excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3

  81. "Excel specifications and limits". MS Office Support. Microsoft. Archived from the original on 2024-08-17. Retrieved 2016-11-28. https://support.office.com/en-us/article/Excel-specifications-and-limits-ca36e2dc-1f09-4620-b726-67c00b05040f

  82. "What is the maximum number of cells in an OpenOffice.org spreadsheet?". FAQ. OpenOffice.org. Archived from the original on 2008-04-05. Retrieved 2008-04-10. http://documentation.openoffice.org/faqs/spreadsheet/023.html

  83. "What's the maximum number of rows and cells for a spreadsheet file?". Calc FAQ. OpenOffice.org. Archived from the original on 2009-05-04. Retrieved 2008-11-04. https://web.archive.org/web/20090504095550/http://wiki.services.openoffice.org/wiki/Documentation/FAQ/Calc/Miscellaneous/What's_the_maximum_number_of_rows_and_cells_for_a_spreadsheet_file

  84. "OpenOffice.org 3.0 New Features". 3.0 Features. OpenOffice.org. Archived from the original on 2021-01-25. Retrieved 2008-11-10. http://www.openoffice.org/dev_docs/features/3.0/#1024_Columns_Per_Calc_Sheet_.28Instead_of_256.29

  85. "OpenOffice.org 3.3 New Features". 3.3 Features. OpenOffice.org. Archived from the original on 2024-08-17. Retrieved 2010-12-13. http://www.openoffice.org/dev_docs/features/3.3/#One_Million_Rows_in_a_Spreadsheet

  86. AI Spreadsheet. Sourcetable Inc., 2024. Retrieved 2024-11-14. https://sourcetable.com