Comparison of spreadsheet software

Last updated

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.

Contents

General

NameDeveloperInitial releasePlatformLatest release License
VersionDate
Apache OpenOffice Calc Apache Software Foundation 2012-05-08Linux4.1.15 [1]   OOjs UI icon edit-ltr-progressive.svg 2023-12-22 Apache-2.0
macOS
Windows
AppleWorks Apple Inc. 1991macOS6.2.9 [2]   OOjs UI icon edit-ltr-progressive.svg 2004-01-14 Proprietary
Windows6.2.2 [3]   OOjs UI icon edit-ltr-progressive.svg 2004-01-20
Calligra Sheets KOffice KSpread TeamBSD3.2.1 [4]   OOjs UI icon edit-ltr-progressive.svg 2020-05-14 LGPL
Linux
macOS
Windows
Collabora Online Calc Collabora 2019 [a] Android24.04.6 [5]   OOjs UI icon edit-ltr-progressive.svg 2024-08-26 MPL-2.0
2021 [b] BSDBuild your ownBuild your own
2019 [a] ChromeOS24.04.6 [5]   OOjs UI icon edit-ltr-progressive.svg 2024-08-26
2019 [a] iOS24.04.6 [6]   OOjs UI icon edit-ltr-progressive.svg 2024-09-09
2019 [a] iPadOS24.04.6 [6]   OOjs UI icon edit-ltr-progressive.svg 2024-09-09
2016 [c] LinuxOnline server: 24.04.8.5 [7]   OOjs UI icon edit-ltr-progressive.svg 2024-11-06
2015 [d] Desktop app: 24.04.4 [8]   OOjs UI icon edit-ltr-progressive.svg 2024-07-12
2015 [d] macOS24.04.4 [8]   OOjs UI icon edit-ltr-progressive.svg 2024-07-12
2015 [d] Windows24.04.4 [8]   OOjs UI icon edit-ltr-progressive.svg 2024-07-12
Google Sheets Google 2006 [e] Android [f] RollingRolling Proprietary
ChromeOS [g]
iOS [f]
Linux [g]
macOS [f]
Windows [f] }
GNU Oleo Tom Lord1992Linux1.6.16 [9]   OOjs UI icon edit-ltr-progressive.svg 1999-03-10 GPL-3.0-or-later
Gnumeric GNOME community1998 [h] BSD1.12.57 [10]   OOjs UI icon edit-ltr-progressive.svg 2024-02-12 GPL-2.0-only
or
GPL-3.0-only
Linux
macOS
Windows [i]
Gobe Productive Gobe Software 1998-08BeOS2.0.1 [11] 2000-02-29 Proprietary
2001-12-12 [12] Windows3.04 [13] 2003-07-08
IBM Lotus Symphony IBM 2008Linux3.0.1 FP2 [14] [15]   OOjs UI icon edit-ltr-progressive.svg 2012-11-29 Proprietary
macOS
Windows
LibreOffice Calc The Document Foundation 2011-01-25 [j] BSD24.2 [16]   OOjs UI icon edit-ltr-progressive.svg 2024-01-31 MPL-2.0
Linux
macOS
Unix
Windows
Mariner CalcMariner Software1989 [k] iOS?5.6.0Dropped Proprietary
Microsoft Excel [l] Microsoft 2015-06-25Android16.0.15128.202062022-09-30 Proprietary
2017-11 [17] ChromeOS ?Dropped 2021-09-18 [18]
2013-06 [19] iOS2.662022-10-10
2014-02 [20] iPadOS ? ?
1985macOS16.652022-09-13
1989OS/23.0Dropped
1987Windows22092022-09-26
Microsoft Works Microsoft 1987-09-14DOS3.0b  OOjs UI icon edit-ltr-progressive.svg 1993 Proprietary
1988macOS4.0b  OOjs UI icon edit-ltr-progressive.svg 1994
1991Windows9 [21]   OOjs UI icon edit-ltr-progressive.svg 2007-09-28
Numbers Apple, Inc.2010-01-27iOS12.12022-06-21 Proprietary
2007-08-07macOS12.12022-06-21
OnlyOffice Ascensio System SIA2014 [m] Linux8.2.0 [22]   OOjs UI icon edit-ltr-progressive.svg 2024-10-21 AGPL-3.0-only
macOS
Windows
OpenOffice.org Calc Sun Microsystems [n]
Oracle Corporation [o]
2002-05BSD3.3.0 [23]   OOjs UI icon edit-ltr-progressive.svg 2011-01-17 Apache-2.0
Linux
macOS
Solaris/Illumos
Unix
Windows
PlanMaker SoftMaker Software GmbH 1994 [24] [25] Android20242023-06-20 Proprietary
Linux
macOS
Windows
Pyspread Martin Manns2008 [p] BSD2.2.3 [26]   OOjs UI icon edit-ltr-progressive.svg 2023-12-22 GPL-3.0-or-later
Linux
Unix
Windows
Quattro Pro Corel 1988 [k] Windows20202020 Proprietary
Resolver OneResolver Systems2008-01-16 [q] Windows1.92010-06-04 Proprietary
sc James Gosling et al19817.16 [27]   OOjs UI icon edit-ltr-progressive.svg 2002-09-20 Public domain
Siag Ulric Eriksson [r] BSD3.6.1 [28]   OOjs UI icon edit-ltr-progressive.svg 2006-11-10 GPL-2.0-or-later
Linux
Unix
Windows
Sourcetable [29] Sourcetable Inc.2020 [s] ChromeOSRollingRolling Proprietary
StarOffice StarCalc Sun Microsystems 1994Linux9.0U3 [30] [31] [32]   OOjs UI icon edit-ltr-progressive.svg 2009-09-09 Proprietary
macOS
Windows
WPS Office Kingsoft 2012-03-23Android16.3.72022-07-22 Proprietary
1988DOSDropped
2014Linux11.1.0.116642022-06-08
2014iOS11.24.12022-07-14
2019macOS4.2.12022-07-15
1995?Windows11.2.0.111912022-07-05
NameDeveloperInitial releasePlatformLatest release License
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.

Name Windows macOS Linux BSD Unix Android ChromeOS optimized iOS iPadOS optimized
Apache OpenOffice Calc YesYesYesNoNoNoNoNoNo
Calligra Sheets YesYesYesYesNoNoNoNoNo
Collabora Online Calc YesYesYesYesYesYesYes [33] YesYes
Google Sheets YesYesYesNoNoYesYesYesYes
Gnumeric Old versionsNoYesYesYesNoNoNoNo
IBM Lotus Symphony YesYesYesNoNoNoNoNoNo
LibreOffice Calc YesYesYesYesYesNoNoNoNo
Mariner CalcNoUnsupportedNoNoNoNoNoYesNo
Microsoft Excel YesYesNoNoNoYesDropped 2021-09-18 [34] YesYes
Numbers NoYesNoNoNoNoNoYesYes
PlanMaker YesYesYesNoNoYes?NoNo
Pyspread YesUnsupportedYesYesYesNoNoNoNo
Quattro Pro YesNoNoNoNoNoNoNoNo
Resolver OneYesNoNoNoNo????
Siag NoYesYesYesYesNoNoNoNo
WPS Office YesYesYesNoNoYes?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.

Name CSV Excel
(xls)
HTML LaTeX ODF
(ods)
OOXML
(xlsx)
PDF DIF OpenOffice.org XML
(sxc)
Apache OpenOffice Calc YesYesYesExport [35] YesImportExportYesYes
Calligra Sheets YesImportExportExportYesNoExport ?Yes
Collabora Online Calc - online and mobile YesYesNoNoYesYesExportNoNo
Collabora Online Calc - desktop YesYesYesExport [36] [37] YesYesExportYesYes
Google Sheets ImportImportNoNoYesYesExportNoNo
Gnumeric YesYesYesExportYesYesExportImportImport
IBM Lotus Symphony YesYesExportNoYesImportExportYes
LibreOffice Calc YesYesYesExport [38] [39] YesYesExportYesYes
Mariner CalcYesYesNoNoNoNoExportNo
Microsoft Excel YesYesPartialNoYesYesExportYesNo
WPS Office YesYesPartialNoYesYesExportImportNo
Numbers YesYesNoNoImportImportExportNo
Quattro Pro YesYesYesNoNoYesExportNo
PlanMaker YesYesExportNoNoYesExportNo
Pyspread YesYesNoNoImportImportExportNo
Resolver OneYesYesNoNoNoNoNoNo
Siag YesImport partialYesExportNoNoExportImport partial
Sourcetable [40] YesYesImport 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,576 [41] 16,38417,179,869,184 [42] 1,02417,592,186,044,400
Gnumeric 16,777,21616,384274,877,906,944142,648603,103
Google Sheets 1,048,57618,27810,000,00020010,000,000
KSpread 32,76732,7671,073,676,289130,645953,923
LibreOffice Calc 5.4.5 – 7.31,048,5761,0241,073,741,824 1,0241,099,511,627,776
LibreOffice Calc 7.4, or later versions1,048,576 [43] 16,38417,179,869,184 [44] 1,02417,592,186,044,400
Lotus 1-2-3 [45] 65,53625616,777,2162564,294,967,296
Microsoft Excel 200365,53625616,777,21665,5311,099,427,741,696
Microsoft Excel 2007, or later versions [46] [47] [48] 1,048,57616,38417,179,869,184Limited by available memoryLimited by available memory
OpenOffice.org Calc 2 [49] 65,53625616,777,2162564,294,967,296
OpenOffice.org Calc 3.0, 3.1 and 3.2 [50] [51] 65,536102467,108,86425617,179,869,184
OpenOffice.org Calc 3.3 [52] 1,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 One limited by machine memory*limited by machine memory*limited machine memory*limited by machine memory*limited by machine memory*
Sourcetable [53] 1,048,57618,27810,000,00020010,000,000

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

See also

Notes

  1. 1 2 3 4 The app uses LibreOffice kit technology and is based on Collabora Online for which development started in 2013.
  2. Version 21.11. Using LibreOffice kit technology, development started in 2013.
  3. Version 1.0. Using LibreOffice kit technology, development started in 2013.
  4. 1 2 3 Version 4.4.
  5. Development started 2006.
  6. 1 2 3 4 Offline editing when used with Chrome or Edge web browser.
  7. 1 2 Offline editing when used with Chrome web browser.
  8. Development started 1998.
  9. Old versions.
  10. Version 3.3. Development started 2010.
  11. 1 2 Development started 1988.
  12. Started as Multiplan in 1982.
  13. Development started 2009.
  14. 1999 – 2009.
  15. 2010 – 2011
  16. Development started 2008.
  17. Development started 2005.
  18. Development started 1996.
  19. Development started 2020.

Related Research Articles

In computing, cross-platform software is computer software that is designed to work in several computing platforms. Some cross-platform software requires a separate build for each platform, but some can be directly run on any platform without special preparation, being written in an interpreted language or compiled to portable bytecode for which the interpreters or run-time packages are common or standard components of all supported platforms.

<span class="mw-page-title-main">NeoOffice</span> macOS office suite

NeoOffice was an office suite for the macOS operating system developed by Planamesa Inc. It was a commercial fork of the free and open source LibreOffice office suite, including a word processor, spreadsheet, presentation program, and graphics program. It added some features not present in the macOS versions of LibreOffice and Apache OpenOffice. The last few versions were based on LibreOffice 4.4, which was released mid-2014.

A collaborative real-time editor is a type of collaborative software or web application which enables real-time collaborative editing, simultaneous editing, or live editing of the same digital document, computer file or cloud-stored data – such as an online spreadsheet, word processing document, database or presentation – at the same time by different users on different computers or mobile devices, with automatic and nearly instantaneous merging of their edits.

The following tables compare general and technical information for a number of office suites:

This is a comparison of word processor programs.

<span class="mw-page-title-main">Quickoffice</span> Discontinued freeware proprietary productivity suite for mobile devices

Quickoffice, Inc. is a discontinued freeware proprietary productivity suite for mobile devices which allows viewing, creating and editing documents, presentations and spreadsheets. It consists of Quickword, Quicksheet, QuickPoint and QuickPDF. The programs are compatible with Microsoft Office file formats, but not the OpenDocument file format.

<span class="mw-page-title-main">ChromeOS</span> Linux-based operating system developed by Google

ChromeOS, sometimes styled as chromeOS and formerly styled as Chrome OS, is a Linux distribution developed and designed by Google. It is derived from the open-source ChromiumOS operating system and uses the Google Chrome web browser as its principal user interface.

<span class="mw-page-title-main">LibreOffice</span> Free and open-source office software suite

LibreOffice is a free and open-source office productivity software suite, a project of The Document Foundation (TDF). It was forked in 2010 from OpenOffice.org, an open-sourced version of the earlier StarOffice. It consists of programs for word processing; creating and editing spreadsheets, slideshows, diagrams, and drawings; working with databases; and composing mathematical formulae. It is available in 120 languages. TDF does not provide support for LibreOffice, but enterprise-focused editions are available from companies in the ecosystem.

The following is a comparison of major desktop publishing software.

Chromebook is a line of laptops, desktops, tablets and all-in-one computers that run ChromeOS, a proprietary operating system developed by Google.

<span class="mw-page-title-main">LibreOffice Writer</span> Open-source word processor

LibreOffice Writer is the free and open-source word processor and desktop publishing component of the LibreOffice software package and is a fork of OpenOffice.org Writer. Writer is a word processor similar to Microsoft Word and Corel's WordPerfect with many similar features, and file format compatibility.

<span class="mw-page-title-main">LibreOffice Calc</span> Spreadsheet component of LibreOffice

LibreOffice Calc is the spreadsheet component of the LibreOffice software package.

<span class="mw-page-title-main">LibreOffice Draw</span> Vector graphics editing software

LibreOfficeDraw is a free and open source vector graphics editor. It is one of the applications included in the LibreOffice suite, developed by The Document Foundation.

<span class="mw-page-title-main">Google Sheets</span> Cloud-based spreadsheet software

Google Sheets is a spreadsheet application and part of the free, web-based Google Docs Editors suite offered by Google. Google Sheets is available as a web application; a mobile app for: Android, iOS, and as a desktop application on Google's ChromeOS. The app is compatible with Microsoft Excel file formats. The app allows users to create and edit files online while collaborating with other users in real-time. Edits are tracked by which user made them, along with a revision history. Where an editor is making changes is highlighted with an editor-specific color and cursor. A permissions system regulates what users can do. Updates have introduced features that use machine learning, including "Explore", which offers answers based on natural language questions in the spreadsheet. Sheets is one of the services provided by Google that also includes Google Docs, Google Slides, Google Drawings, Google Forms, Google Sites and Google Keep.

<span class="mw-page-title-main">Collabora Online</span> Online office suite based on LibreOffice

Collabora Online is an open source online office suite based on LibreOffice, enabling web-based collaborative real-time editing of word processing documents, spreadsheets, presentations, and vector graphics. Optional apps are available for desktops, laptops, tablets, smartphones, and Chromebooks.

References

  1. "Announcing Apache OpenOffice 4.1.15". 22 December 2023. Retrieved 25 February 2024.
  2. "AppleWorks 6.2.9 for Mac". 14 January 2004.
  3. "AppleWorks 6.2.2 for Windows". 20 January 2004.
  4. "Calligra 3.2.1".
  5. 1 2 "Collabora Office".
  6. 1 2 "Collabora Office".
  7. "Collabora Online 24.04 Release Notes".
  8. 1 2 3 "Collabora Office 24.04 Release Notes".
  9. "ChangeLog". 22 November 2000. Archived from the original on 8 January 2001.
  10. "Gnumeric 1.12.57 aka "TBD" is now available". 12 February 2024. Retrieved 15 February 2024.
  11. "Productive BeOS". Archived from the original on 2001-12-23.
  12. "Windows Release". Archived from the original on 2002-02-04.
  13. "Gobe Corporation". Archived from the original on 2003-10-04.
  14. "IBM Lotus Symphony - Buzz: Symphony 3.0.1 FIXPACK 2 is Now AVAILABLE". 29 November 2012. Archived from the original on 29 January 2013.
  15. "IBM Lotus Symphony - Release Notes". Archived from the original on 26 April 2011.
  16. https://wiki.documentfoundation.org/ReleaseNotes/24.2.{{cite web}}: Missing or empty |title= (help)
  17. "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.
  18. "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.
  19. "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.
  20. "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.
  21. "Microsoft Works - Microsoft Lifecycle". Archived from the original on 23 January 2022.
  22. "Release 8.2.0". 21 October 2024. Retrieved 22 October 2024.
  23. "3.3.0 - Release Notes".
  24. "Infos zu PlanMaker 97". 1997-06-03. Archived from the original on 1997-06-03. Retrieved 2010-03-28.
  25. 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.
  26. https://pypi.org/project/pyspread/.{{cite web}}: Missing or empty |title= (help)
  27. http://www.ibiblio.org/pub/Linux/apps/financial/spreadsheet/!INDEX.html.{{cite web}}: Missing or empty |title= (help)
  28. "Siag Office 3.6.1". 10 November 2006. Archived from the original on 23 April 2017.
  29. AI Spreadsheet. Sourcetable Inc., 2024. Retrieved 2024-11-14.
  30. "StarOffice Software". Archived from the original on 27 September 2009.
  31. "StarOffice Patches". Archived from the original on 22 September 2009.
  32. "StarOffice/StarSuite Updates". Archived from the original on 23 September 2009.
  33. "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).
  34. "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.
  35. Through extensions: "Calc2LaTeX". 2009-07-15. Archived from the original on 2012-04-29. Retrieved 2012-05-06.
  36. Through extensions: "TexMaths". 2021-03-14. Archived from the original on 2024-08-17. Retrieved 2021-08-09.
  37. Through extensions: "Writer2LaTeX". 2018-10-19. Archived from the original on 2021-08-04. Retrieved 2021-08-09.
  38. Through extensions: "TexMaths". 2021-03-14. Archived from the original on 2024-08-17. Retrieved 2021-08-09.
  39. Through extensions: "Writer2LaTeX". 2018-10-19. Archived from the original on 2021-08-04. Retrieved 2021-08-09.
  40. AI Spreadsheet. Sourcetable Inc., 2024. Retrieved 2024-11-14.
  41. "16,777,216 row limit is a setting under experimental features". websetnet.net.
  42. "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.
  43. "16,777,216 row limit is a setting under experimental features". websetnet.net.
  44. "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.
  45. "Limitations of 1-2-3 for Windows". IBM. Archived from the original on 2013-01-03. Retrieved 2008-04-10.
  46. "Excel specifications and limits". MS Office Support. Microsoft. Archived from the original on 2016-11-28. Retrieved 2016-11-28.
  47. "Excel specifications and limits". MS Office Support. Microsoft. Archived from the original on 2020-04-28. Retrieved 2016-11-28.
  48. "Excel specifications and limits". MS Office Support. Microsoft. Archived from the original on 2024-08-17. Retrieved 2016-11-28.
  49. "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.
  50. "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.
  51. "OpenOffice.org 3.0 New Features". 3.0 Features. OpenOffice.org. Archived from the original on 2021-01-25. Retrieved 2008-11-10.
  52. "OpenOffice.org 3.3 New Features". 3.3 Features. OpenOffice.org. Archived from the original on 2024-08-17. Retrieved 2010-12-13.
  53. AI Spreadsheet. Sourcetable Inc., 2024. Retrieved 2024-11-14.
  1. AI Spreadsheet. Sourcetable Inc., 2024. Retrieved 2024-11-14.