Comparison of spreadsheet software

Short description: None

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

* 1 General
* 2 Operating system support
* 3 Supported file formats
* 4 Rows and Columns
* 5 See also
* 6 Notes
* 7 References

## General

Name  | Developer  | Initial release  | Platform  | Latest release  | License

|
|
|
|
|

Version  | Date
Apache OpenOffice Calc | Apache Software Foundation  | 2012-05-08  | GNU/Linux  |  |  | Apache-2.0
macOS
Windows
AppleWorks | Apple Inc. | 1991  | macOS  |  |  | Proprietary
Windows  |  |
Calligra Sheets | KOffice KSpread Team  |  | BSD  |  |  | LGPL
GNU/Linux
macOS
Windows
Collabora Online Calc | Collabora | 2019[lower-alpha 1] | Android  |  |  | MPL-2.0
2021[lower-alpha 2] | BSD  | Build your own  | Build your own
2019[lower-alpha 1] | ChromeOS  |  |
2019[lower-alpha 1] | iOS  |  |
2019[lower-alpha 1] | iPadOS  |  |
2016[lower-alpha 3] | Linux  | Online server:  |
2015[lower-alpha 4] | Desktop app:  |
2015[lower-alpha 4] | macOS  |  |
2015[lower-alpha 4] | Windows  |  |
Google Sheets | Google | 2006[lower-alpha 5] | Android[lower-alpha 6] | Rolling  | Rolling  | Proprietary
ChromeOS[lower-alpha 7]
iOS[lower-alpha 6]
Linux[lower-alpha 7]
macOS[lower-alpha 6]
Windows[lower-alpha 6]}
GNU Oleo | Tom Lord  | 1992  | GNU/Linux  |  |  | GPL-3.0-or-later
Gnumeric | GNOME community  | 1998[lower-alpha 8] | BSD  |  |  | GPL-2.0-only

GPL-3.0-only
GNU/Linux
macOS
Windows[lower-alpha 9]
Gobe Productive  | Gobe Software  | 1998-08  | BeOS  | 2.0.1[1] | 2000-02-29  | Proprietary
2001-12-12[2] | Windows  | 3.04[3] | 2003-07-08
IBM Lotus Symphony | IBM | 2008  | GNU/Linux  |  |  | Proprietary
macOS
Windows
LibreOffice Calc | The Document Foundation | 2011-01-25[lower-alpha 10] | BSD  |  |  | MPL-2.0
GNU/Linux
macOS
Unix
Windows
Mariner Calc  | Mariner Software  | 1989[lower-alpha 11] | iOS?  | 5.6.0  | Dropped  | Proprietary
Microsoft Excel[lower-alpha 12] | Microsoft | 2015-06-25  | Android  | 16.0.15128.20206  | 2022-09-30  | Proprietary
2017-11 [4] | ChromeOS  | ?  | Dropped 2021-09-18 [5]
2013-06 [6] | iOS  | 2.66  | 2022-10-10
2014-02 [7] | iPadOS  | ?  | ?
1985  | macOS  | 16.65  | 2022-09-13
1989  | OS/2  | 3.0  | Dropped
1987  | Windows  | 2209  | 2022-09-26
Microsoft Works | Microsoft | 1987-09-14  | DOS  |  |  | Proprietary
1988  | macOS  |  |
1991  | Windows  |  |
Numbers  | Apple, Inc.  | 2010-01-27  | iOS  | 12.1  | 2022-06-21  | Proprietary
2007-08-07  | macOS  | 12.1  | 2022-06-21
OnlyOffice | Ascensio System SIA  | 2014[lower-alpha 13] | GNU/Linux  |  |  | AGPL-3.0-only
macOS
Windows
OpenOffice.org Calc | Sun Microsystems[lower-alpha 14]
Oracle Corporation[lower-alpha 15] | 2002-05  | BSD  |  |  | Apache-2.0
GNU/Linux
macOS
Solaris/Illumos
Unix
Windows
PlanMaker | SoftMaker Software GmbH | 1994[8][9] | Android  | 2024  | 2023-06-20  | Proprietary
GNU/Linux
macOS
Windows
Pyspread | Martin Manns  | 2008[lower-alpha 16] | BSD  |  |  | GPL-3.0-or-later
GNU/Linux
Unix
Windows
Quattro Pro | Corel | 1988[lower-alpha 11] | Windows  | 2020  | 2020  | Proprietary
Resolver One  | Resolver Systems  | 2008-01-16[lower-alpha 17] | Windows  | 1.9  | 2010-06-04  | Proprietary
sc | James Gosling et al  | 1981  |  |  |  | Public domain
Siag | Ulric Eriksson  | [lower-alpha 18] | BSD  |  |  | GPL-2.0-or-later
GNU/Linux
Unix
Windows
StarOffice StarCalc | Sun Microsystems | 1994  | GNU/Linux  |  |  | Proprietary
macOS
Windows
WPS Office | Kingsoft | 2012-03-23  | Android  | 16.3.7  | 2022-07-22  | Proprietary
1988  | DOS  |  | Dropped
2014  | GNU/Linux  | 11.1.0.11664  | 2022-06-08
2014  | iOS  | 11.24.1  | 2022-07-14
2019  | macOS  | 4.2.1  | 2022-07-15
1995?  | Windows  | 11.2.0.11191  | 2022-07-05
Name  | Developer  | Initial release  | Platform  | Latest release  | License
Version  | Date

## 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 | GNU/Linux | BSD | Unix | Android | ChromeOS optimized  | iOS | iPadOS optimized

|
|
|
|
|
|
|
|
|

Apache OpenOffice Calc | Yes  | Yes  | Yes  | No  | No  | No  | No  | No  | No
Calligra Sheets | Yes  | Yes  | Yes  | Yes  | No  | No  | No  | No  | No
Collabora Online Calc | Yes  | Yes  | Yes  | Yes  | Yes  | Yes  | Yes[10] | Yes  | Yes
Google Sheets | Yes  | Yes  | Yes  | No  | No  | Yes  | Yes  | Yes  | Yes
Gnumeric | Old versions  | No  | Yes  | Yes  | Yes  | No  | No  | No  | No
IBM Lotus Symphony | Yes  | Yes  | Yes  | No  | No  | No  | No  | No  | No
LibreOffice Calc | Yes  | Yes  | Yes  | Yes  | Yes  | No  | No  | No  | No
Mariner Calc  | No  | Unsupported  | No  | No  | No  | No  | No  | Yes  | No
Microsoft Excel | Yes  | Yes  | No  | No  | No  | Yes  | Dropped 2021-09-18 [11] | Yes  | Yes
Numbers  | No  | Yes  | No  | No  | No  | No  | No  | Yes  | Yes
PlanMaker | Yes  | Yes  | Yes  | No  | No  | Yes  | ?  | No  | No
Pyspread | Yes  | Unsupported  | Yes  | Yes  | Yes  | No  | No  | No  | No
Quattro Pro | Yes  | No  | No  | No  | No  | No  | No  | No  | No
Resolver One  | Yes  | No  | No  | No  | No  | ?  | ?  | ?  | ?
Siag | No  | Yes  | Yes  | Yes  | Yes  | No  | No  | No  | No
WPS Office | Yes  | Yes  | Yes  | No  | No  | Yes  | ?  | 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 | Yes  | Yes  | Yes  | Export[12] | Yes  | Import  | Export  | Yes  | Yes
Calligra Sheets | Yes  | Import  | Export  | Export  | Yes  | No  | Export  | ?  | Yes
Collabora Online Calc - online and mobile | Yes  | Yes  | No  | No  | Yes  | Yes  | Export  | No  | No
Collabora Online Calc - desktop | Yes  | Yes  | Yes  | Export[13][14] | Yes  | Yes  | Export  | Yes  | Yes
Google Sheets | Import  | Import  | No  | No  | Yes  | Yes  | Export  | No  | No
Gnumeric | Yes  | Yes  | Yes  | Export  | Yes  | Yes  | Export  | Import  | Import
IBM Lotus Symphony | Yes  | Yes  | Export  | No  | Yes  | Import  | Export  |  | Yes
LibreOffice Calc | Yes  | Yes  | Yes  | Export[15][16] | Yes  | Yes  | Export  | Yes  | Yes
Mariner Calc  | Yes  | Yes  | No  | No  | No  | No  | Export  |  | No
Microsoft Excel | Yes  | Yes  | Partial  | No  | Yes  | Yes  | Export  | Yes  | No
WPS Office | Yes  | Yes  | Partial  | No  | Yes  | Yes  | Export  | Import  | No
Numbers  | Yes  | Yes  | No  | No  | Import  | Import  | Export  |  | No
Quattro Pro | Yes  | Yes  | Yes  | No  | No  | Yes  | Export  |  | No
PlanMaker | Yes  | Yes  | Export  | No  | No  | Yes  | Export  |  | No
Pyspread | Yes  | Yes  | No  | No  | Import  | Import  | Export  |  | No
Resolver One  | Yes  | Yes  | No  | No  | No  | No  | No  |  | No
Siag | Yes  | Import partial  | Yes  | Export  | No  | No  | Export  |  | Import partial

## Rows and Columns

Program  | Rows (per sheet) | Columns (per sheet) | Total cells (per sheet) | Sheets  | Total cells (per workbook)

|
|
|
|
|

Collabora Online 22.05, or later versions – Online, Desktop, Tablet, Mobile | 1,048,576[17] | 16,384  | 17,179,869,184[18] | 1,024  | 17,592,186,044,400
Gnumeric | 16,777,216 | 16,384 | 274,877,906,944 | 142,648 | 603,103
Google Sheets | 1,048,576  | 18,278  | 10,000,000  | 200  | 10,000,000
KSpread | 32,767 | 32,767 | 1,073,676,289 | 130,645 | 953,923
LibreOffice Calc 5.4.5 – 7.3 | 1,048,576 | 1,024 | 1,073,741,824  | 1,024 | 1,099,511,627,776
LibreOffice Calc 7.4, or later versions | 1,048,576[19] | 16,384 | 17,179,869,184[20] | 1,024 | 17,592,186,044,400
Lotus 1-2-3[21] | 65,536 | 256 | 16,777,216 | 256 | 4,294,967,296
Microsoft Excel 2003 | 65,536 | 256 | 16,777,216 | 65,531 | 1,099,427,741,696
Microsoft Excel 2007, or later versions[22][23][24] | 1,048,576 | 16,384 | 17,179,869,184  | Limited by available memory  | Limited by available memory
OpenOffice.org Calc 2[25] | 65,536 | 256 | 16,777,216 | 256 | 4,294,967,296
OpenOffice.org Calc 3.0, 3.1 and 3.2[26][27] | 65,536 | 1024 | 67,108,864 | 256 | 17,179,869,184
OpenOffice.org Calc 3.3[28] | 1,048,576 | 1024 | 1,073,741,824 | 256 | 274,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 memory | Limited by available memory | Limited by available memory
Resolver One | limited by machine memory* | limited by machine memory* | limited machine memory* | limited by machine memory* | limited by machine memory*

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

## See also

* List of spreadsheet software
* Comparison of word processors

## Notes

1. ↑ 1.0 1.1 1.2 1.3 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. ↑ 4.0 4.1 4.2 Version 4.4.
5. ↑ Development started 2006.
6. ↑ 6.0 6.1 6.2 6.3 Offline editing when used with Chrome or Edge web browser.
7. ↑ 7.0 7.1 Offline editing when used with Chrome web browser.
8. ↑ Development started 1998.
9. ↑ Old versions.
10. ↑ Version 3.3. Development started 2010.
11. ↑ 11.0 11.1 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.

## References

1. ↑ "Productive BeOS". http://www.gobe.com/storegobeproductive.html.
2. ↑ "Windows Release". http://gobe.com/press/pr12_12_2001.html.
3. ↑ "Gobe Corporation". http://gobe.com.
4. ↑ "Microsoft Office finally available for all Chromebooks". 2017-11-27. https://www.notebookcheck.net/Microsoft-Office-finally-available-for-all-Chromebooks.266710.0.html. "...Without any fanfare, Microsoft finally made Word, Excel, Outlook, and PowerPoint available for (apparently) all Chromebooks."
5. ↑ "Office apps for Chromebook to be stopped". 2021-08-31. https://office-watch.com/2021/office-apps-for-chromebook-to-be-stopped/. "...it’s too expensive to support Office apps on the larger screen Chromebook devices which are rivalling Windows in some markets."
6. ↑ "Microsoft launches Office iOS app but no iPad version yet". 2013-06-15. https://www.theguardian.com/technology/appsblog/2013/jun/14/microsoft-office-365-iphone-app/. "...Requires active Office 365 subscription to edit Word, Excel and PowerPoint files, but no iPad version for now."
7. ↑ "Microsoft announces Office for iPad, extending productivity to all iOS devices". 2014-02-27. https://www.pcworld.com/article/444564/microsoft-announces-office-for-ipad-extending-productivity-to-all-ios-devices.html. "...Office 365 subscription is needed to edit as well as create documents."
8. ↑ "Infos zu PlanMaker 97". 1997-06-03. Archived from the original on 1997-06-03. https://web.archive.org/web/19970603185443/http://www.softmaker.de/planmake.htm. Retrieved 2010-03-28.
9. ↑ Andy Updegrove (2006-07-05). "The Emerging ODF Environment, Part IV: Spotlight on SoftMaker Office 2006". http://www.consortiuminfo.org/standardsblog/article.php?story=2006070509040463. Retrieved 2010-03-28.
10. ↑ "Collabora Office on iOS and Android Just got Better!". Adfinis. 2020-12-15. https://adfinis.com/en/blog/collabora-office-on-ios-and-android-just-got-better/. "...touch optimized interfaces: one for tablets and one for phone screens. ...(iOS, iPadOS, Chrome OS, Android)."
11. ↑ "Office apps for Chromebook to be stopped". 2021-08-31. https://office-watch.com/2021/office-apps-for-chromebook-to-be-stopped/. "...it’s too expensive to support Office apps on the larger screen Chromebook devices which are rivalling Windows in some markets."
12. ↑ Through extensions: "Calc2LaTeX". 2009-07-15. http://extensions.openoffice.org/en/project/Calc2LaTeX. Retrieved 2012-05-06.
13. ↑ Through extensions: "TexMaths". 2021-03-14. https://extensions.libreoffice.org/en/extensions/show/texmaths-1. Retrieved 2021-08-09.
14. ↑ Through extensions: "Writer2LaTeX". 2018-10-19. https://extensions.libreoffice.org/en/extensions/show/writer2latex-1. Retrieved 2021-08-09.
15. ↑ Through extensions: "TexMaths". 2021-03-14. https://extensions.libreoffice.org/en/extensions/show/texmaths-1. Retrieved 2021-08-09.
16. ↑ Through extensions: "Writer2LaTeX". 2018-10-19. https://extensions.libreoffice.org/en/extensions/show/writer2latex-1. Retrieved 2021-08-09.
17. ↑ "16,777,216 row limit is a setting under experimental features". https://websetnet.net/libreoffice-7-0-beta-1-arrives-with-odf-1-3-document-support/.
18. ↑ "274,877,906,944 cells when the 16,777,216 experimental row limit is enabled". https://bugs.documentfoundation.org/show_bug.cgi?id=50916.
19. ↑ "16,777,216 row limit is a setting under experimental features". https://websetnet.net/libreoffice-7-0-beta-1-arrives-with-odf-1-3-document-support/.
20. ↑ "274,877,906,944 cells when the 16,777,216 experimental row limit is enabled". https://bugs.documentfoundation.org/show_bug.cgi?id=50916.
21. ↑ "Limitations of 1-2-3 for Windows". IBM. http://www-1.ibm.com/support/docview.wss?uid=swg27003548. Retrieved 2008-04-10.
22. ↑ "Excel specifications and limits". MS Office Support. Microsoft. https://support.office.com/en-gb/article/Excel-specifications-and-limits-16c69c74-3d6a-4aaf-ba35-e6eb276e8eaa. Retrieved 2016-11-28.
23. ↑ "Excel specifications and limits". MS Office Support. Microsoft. https://support.office.com/en-us/article/Excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3. Retrieved 2016-11-28.
24. ↑ "Excel specifications and limits". MS Office Support. Microsoft. https://support.office.com/en-us/article/Excel-specifications-and-limits-ca36e2dc-1f09-4620-b726-67c00b05040f. Retrieved 2016-11-28.
25. ↑ "What is the maximum number of cells in an OpenOffice.org spreadsheet?". FAQ. OpenOffice.org. http://documentation.openoffice.org/faqs/spreadsheet/023.html. Retrieved 2008-04-10.
26. ↑ "What's the maximum number of rows and cells for a spreadsheet file?". Calc FAQ. OpenOffice.org. http://wiki.services.openoffice.org/wiki/Documentation/FAQ/Calc/Miscellaneous/What's_the_maximum_number_of_rows_and_cells_for_a_spreadsheet_file?. Retrieved 2008-11-04.
27. ↑ "OpenOffice.org 3.0 New Features". 3.0 Features. OpenOffice.org. http://www.openoffice.org/dev_docs/features/3.0/#1024_Columns_Per_Calc_Sheet_.28Instead_of_256.29. Retrieved 2008-11-10.
28. ↑ "OpenOffice.org 3.3 New Features". 3.3 Features. OpenOffice.org. http://www.openoffice.org/dev_docs/features/3.3/#One_Million_Rows_in_a_Spreadsheet. Retrieved 2010-12-13.

* v
* t
* e

Spreadsheets

Freeware|

| Open source|

* Calligra Sheets
* Gnumeric
* LibreOffice Calc
* NeoOffice
* Pyspread
* Siag

|

Closed source|

* Google Sheets
* Kingsoft Spreadsheets

Retail|

* Apple Numbers
* Microsoft Excel
* PlanMaker
* Quattro Pro

Historical|

* As-Easy-As
* Boeing Calc
* GNU Oleo
* Informix Wingz
* IBM Lotus Symphony
* KCells
* Lotus 1-2-3
* Lotus Improv
* Microsoft Works
* Multiplan
* OpenOffice.org Calc
* StarOffice
* SuperCalc
* VisiCalc

* Category
* Comparison
* List
* Online spreadsheet

0.00

(0 votes)

Original source: https://en.wikipedia.org/wiki/Comparison of spreadsheet software. Read more

|

Retrieved from "https://handwiki.org/wiki/index.php?title=Software:Comparison_of_spreadsheet_software&oldid=752173"
*[v]: View this template
*[t]: Discuss this template
*[e]: Edit this template