Comparison of spreadsheet software
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
[edit ]| Name | Developer | Initial release | Platform | Latest release | License | |
|---|---|---|---|---|---|---|
| Version | Date | |||||
| Apache OpenOffice Calc | Apache Software Foundation | 2012年05月08日 | Linux | 4.1.15[1] Edit this on Wikidata | 2023年12月22日 | Apache-2.0 |
| macOS | ||||||
| Windows | ||||||
| AppleWorks | Apple Inc. | 1991 | macOS | 6.2.9[2] Edit this on Wikidata | 2004年01月14日 | Proprietary |
| Windows | 6.2.2[3] Edit this on Wikidata | 2004年01月20日 | ||||
| Calligra Sheets | KOffice KSpread Team | BSD | 4.0.1[4] Edit this on Wikidata | 2024年09月02日 | LGPL | |
| Linux | ||||||
| macOS | ||||||
| Windows | ||||||
| Collabora Online | Collabora | 2019[a] | Android | 25.04.6[5] Edit this on Wikidata | 2025年11月06日 | MPL-2.0 |
| 2021[b] | BSD | Build your own | Build your own | |||
| 2019[a] | ChromeOS | 25.04.6[5] Edit this on Wikidata | 2025年11月06日 | |||
| 2019[a] | iOS | 25.04.6[6] Edit this on Wikidata | 2025年11月07日 | |||
| 2019[a] | iPadOS | 25.04.6[6] Edit this on Wikidata | 2025年11月07日 | |||
| 2016[c] | Linux | Online server: 25.04.6.3[7] Edit this on Wikidata | 2025年11月03日 | |||
| 2015[d] | Desktop app: 25.04.6[8] Edit this on Wikidata | 2025年10月03日 | ||||
| 2015[d] | CODE:[e] 25.04.7.1[9] Edit this on Wikidata | 2025年11月04日 | ||||
| 2015[d] | macOS | 25.04.6[8] Edit this on Wikidata | 2025年10月03日 | |||
| 2015[d] | Windows | 25.04.6[8] Edit this on Wikidata | 2025年10月03日 | |||
| Google Sheets | 2006[f] | Android[g] | Rolling | Rolling | Proprietary | |
| ChromeOS[h] | ||||||
| iOS[g] | ||||||
| Linux[h] | ||||||
| macOS[g] | ||||||
| Windows[g] | ||||||
| GNU Oleo | Tom Lord | 1992 | Linux | 1.6.16[10] Edit this on Wikidata | 1999年03月10日 | GPL-3.0-or-later |
| Gnumeric | GNOME community | 1998[i] | BSD | 1.12.59[11] Edit this on Wikidata | 2025年03月01日 | GPL-2.0-only or GPL-3.0-only |
| Linux | ||||||
| macOS | ||||||
| Windows[j] | ||||||
| Gobe Productive | Gobe Software | 1998-08 | BeOS | 2.0.1[12] | 2000年02月29日 | Proprietary |
| 2001年12月12日[13] | Windows | 3.04[14] | 2003年07月08日 | |||
| IBM Lotus Symphony | IBM | 2008 | Linux | 3.0.1 FP2[15] [16] Edit this on Wikidata | 2012年11月29日 | Proprietary |
| macOS | ||||||
| Windows | ||||||
| LibreOffice Calc | The Document Foundation | 2011年01月25日[k] | BSD | 24.2[17] Edit this on Wikidata | 2024年01月31日 | MPL-2.0 |
| Linux | ||||||
| macOS | ||||||
| Unix | ||||||
| Windows | ||||||
| Mariner Calc | Mariner Software | 1989[l] | iOS? | 5.6.0 | Dropped | Proprietary |
| Microsoft Excel [m] | Microsoft | 2015年06月25日 | Android | 16.0.15128.20206 | 2022年09月30日 | Proprietary |
| 2017-11 [18] | ChromeOS | ? | Dropped 2021年09月18日 [19] | |||
| 2013-06 [20] | iOS | 2.66 | 2022年10月10日 | |||
| 2014-02 [21] | 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 | 3.0b Edit this on Wikidata | 1993 | Proprietary |
| 1988 | macOS | 4.0b Edit this on Wikidata | 1994 | |||
| 1991 | Windows | 9[22] Edit this on Wikidata | 2007年09月28日 | |||
| Numbers | Apple, Inc. | 2010年01月27日 | iOS | 14.4 | 2025年04月03日 | Proprietary |
| 2007年08月07日 | macOS | 14.4 | 2025年04月03日 | |||
| OnlyOffice | Ascensio System SIA | 2014[n] | Linux | 9.1.0[23] Edit this on Wikidata | 2025年10月15日 | AGPL-3.0-only |
| macOS | ||||||
| Windows | ||||||
| OpenOffice.org Calc | Sun Microsystems [o] Oracle Corporation [p] |
2002-05 | BSD | Apache-2.0 | ||
| Linux | ||||||
| macOS | ||||||
| Solaris/Illumos | ||||||
| Unix | ||||||
| Windows | ||||||
| PlanMaker | SoftMaker Software GmbH | 1994[24] [25] | Android | 2024 | 2023年06月20日 | Proprietary |
| Linux | ||||||
| macOS | ||||||
| Windows | ||||||
| Pyspread | Martin Manns | 2008[q] | BSD | 2.4[26] Edit this on Wikidata | 2025年03月19日 | GPL-3.0-or-later |
| Linux | ||||||
| Unix | ||||||
| Windows | ||||||
| Quattro Pro | Corel | 1988[l] | Windows | 2020 | 2020 | Proprietary |
| Resolver One | Resolver Systems | 2008年01月16日[r] | Windows | 1.9 | 2010年06月04日 | Proprietary |
| sc | James Gosling et al | 1981 | 7.16[27] Edit this on Wikidata | 2002年09月20日 | Public domain | |
| Siag | Ulric Eriksson | [s] | BSD | 3.6.1[28] Edit this on Wikidata | 2006年11月10日 | GPL-2.0-or-later |
| Linux | ||||||
| Unix | ||||||
| Windows | ||||||
| Sourcetable[29] | Sourcetable Inc. | 2020[t] | ChromeOS | Rolling | Rolling | Proprietary |
| StarOffice StarCalc | Sun Microsystems | 1994 | Linux | 9.0U3[30] [31] [32] Edit this on Wikidata | 2009年09月09日 | Proprietary |
| macOS | ||||||
| Windows | ||||||
| WPS Office | Kingsoft | 2012年03月23日 | Android | 16.3.7 | 2022年07月22日 | Proprietary |
| 1988 | DOS | Dropped | ||||
| 2014 | Linux | 11.1.0.11664 | 2022年06月08日 | |||
| 2014 | iOS | 11.24.1 | 2022年07月14日 | |||
| 2019 | macOS | 4.2.1 | 2022年07月15日 | |||
| 1988 | Windows | 11.2.0.11191 | 2022年07月05日 | |||
| Name | Developer | Initial release | Platform | Latest release | License | |
| Version | Date | |||||
Operating system support
[edit ]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 | 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[33] | 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日 [34] | 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
[edit ]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) |
DIF | OpenOffice.org XML (sxc) | |
|---|---|---|---|---|---|---|---|---|---|
| Apache OpenOffice Calc | Yes | Yes | Yes | Export[35] | Yes | Import | Export | Yes | Yes |
| Calligra Sheets | Yes | Import | Export | Export | Yes | No | Export | ? | Yes |
| Collabora Online Calc - online and mobile | Yes | Yes | Export | No | Yes | Yes | Export | No | No |
| Collabora Online Calc - desktop | Yes | Yes | Export | Export[36] [37] | 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[38] [39] | 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 | No | Import | No | No | Import | Export | No | No |
| Resolver One | Yes | Yes | No | No | No | No | No | No | |
| Siag | Yes | Import partial | Yes | Export | No | No | Export | Import partial | |
| Sourcetable[40] | Yes | Yes | Import partial | No | Import partial | Yes | No | No |
Rows and Columns
[edit ]| 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[41] | 16,384 | 17,179,869,184[42] | 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[43] | 16,384 | 17,179,869,184[44] | 1,024 | 17,592,186,044,400 |
| Lotus 1-2-3 [45] | 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[46] [47] [48] | 1,048,576 | 16,384 | 17,179,869,184 | Limited by available memory | Limited by available memory |
| OpenOffice.org Calc 2[49] | 65,536 | 256 | 16,777,216 | 256 | 4,294,967,296 |
| OpenOffice.org Calc 3.0, 3.1 and 3.2[50] [51] | 65,536 | 1024 | 67,108,864 | 256 | 17,179,869,184 |
| OpenOffice.org Calc 3.3[52] | 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 by machine memory* | limited by machine memory* | limited by machine memory* |
| Sourcetable[53] | 1,048,576 | 18,278 | 10,000,000 | 200 | 10,000,000 |
-* 32-bit addressable memory on Microsoft Windows, i.e. ~2.5 GB.
See also
[edit ]Notes
[edit ]- ^ a b c d The app uses LibreOffice kit technology and is based on Collabora Online for which development started in 2013.
- ^ Version 21.11. Using LibreOffice kit technology, development started in 2013.
- ^ Version 1.0. Using LibreOffice kit technology, development started in 2013.
- ^ a b c d Version 4.4.
- ^ CODE: Collabora Online Development Edition
- ^ Development started 2006.
- ^ a b c d Offline editing when used with Chrome or Edge web browser.
- ^ a b Offline editing when used with Chrome web browser.
- ^ Development started 1998.
- ^ Old versions.
- ^ Version 3.3. Development started 2010.
- ^ a b Development started 1988.
- ^ Started as Multiplan in 1982.
- ^ Development started 2009.
- ^ 1999 – 2009.
- ^ 2010 – 2011
- ^ Development started 2008.
- ^ Development started 2005.
- ^ Development started 1996.
- ^ Development started 2020.
References
[edit ]- ^ "Announcing Apache OpenOffice 4.1.15". 22 December 2023. Retrieved 25 February 2024.
- ^ "AppleWorks 6.2.9 for Mac". 14 January 2004.
- ^ "AppleWorks 6.2.2 for Windows". 20 January 2004.
- ^ https://github.com/KDE/calligra/releases/tag/v4.0.1.
{{cite web}}: Missing or empty|title=(help) - ^ a b "Collabora Office".
- ^ a b "Collabora Office".
- ^ "Collabora Online 25.04 Release Notes".
- ^ a b c "Collabora Office 25.04 Release Notes".
- ^ "CODE 25.04 Release Notes".
- ^ "ChangeLog". 22 November 2000. Archived from the original on 8 January 2001.
- ^ "Gnumeric 1.12.59 aka "TBD" is now available". 1 March 2025. Retrieved 2 March 2025.
- ^ "Productive BeOS". Archived from the original on 2001年12月23日.
- ^ "Windows Release". Archived from the original on 2002年02月04日.
- ^ "Gobe Corporation". Archived from the original on 2003年10月04日.
- ^ "IBM Lotus Symphony - Buzz: Symphony 3.0.1 FIXPACK 2 is Now AVAILABLE". 29 November 2012. Archived from the original on 29 January 2013.
- ^ "IBM Lotus Symphony - Release Notes". Archived from the original on 26 April 2011.
- ^ https://wiki.documentfoundation.org/ReleaseNotes/24.2.
{{cite web}}: Missing or empty|title=(help) - ^ "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.
- ^ "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.
- ^ "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.
- ^ "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.
- ^ "Microsoft Works - Microsoft Lifecycle". Archived from the original on 23 January 2022.
- ^ "ONLYOFFICE-DesktopEditors-9.1.0". 15 October 2025. Retrieved 15 October 2025.
- ^ "Infos zu PlanMaker 97". 1997年06月03日. Archived from the original on 1997年06月03日. Retrieved 2010年03月28日.
- ^ 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日.
- ^ https://pypi.org/project/pyspread/.
{{cite web}}: Missing or empty|title=(help) - ^ http://www.ibiblio.org/pub/Linux/apps/financial/spreadsheet/!INDEX.html.
{{cite web}}: Missing or empty|title=(help) - ^ "Siag Office 3.6.1". 10 November 2006. Archived from the original on 23 April 2017.
- ^ AI Spreadsheet. Sourcetable Inc., 2024. Retrieved 2024年11月14日.
- ^ "StarOffice Software". Archived from the original on 27 September 2009.
- ^ . Archived from ^ . Archived from ^ "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).
- ^ "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.
- ^ Through extensions: "Calc2LaTeX". 2009年07月15日. Archived from the original on 2012年04月29日. Retrieved 2012年05月06日.
- ^ Through extensions: "TexMaths". 2021年03月14日. Archived from the original on 2024年08月17日. Retrieved 2021年08月09日.
- ^ Through extensions: "Writer2LaTeX". 2018年10月19日. Archived from the original on 2021年08月04日. Retrieved 2021年08月09日.
- ^ Through extensions: "TexMaths". 2021年03月14日. Archived from the original on 2024年08月17日. Retrieved 2021年08月09日.
- ^ Through extensions: "Writer2LaTeX". 2018年10月19日. Archived from the original on 2021年08月04日. Retrieved 2021年08月09日.
- ^ AI Spreadsheet. Sourcetable Inc., 2024. Retrieved 2024年11月14日.
- ^ "16,777,216 row limit is a setting under experimental features". Websetnet. 5 August 2020.
- ^ "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日.
- ^ "16,777,216 row limit is a setting under experimental features". Websetnet. 5 August 2020.
- ^ "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日.
- ^ "Limitations of 1-2-3 for Windows". IBM. Archived from the original on 2013年01月03日. Retrieved 2008年04月10日.
- ^ "Excel specifications and limits". MS Office Support. Microsoft. Archived from the original on 2016年11月28日. Retrieved 2016年11月28日.
- ^ "Excel specifications and limits". MS Office Support. Microsoft. Archived from the original on 2020年04月28日. Retrieved 2016年11月28日.
- ^ "Excel specifications and limits". MS Office Support. Microsoft. Archived from the original on 2024年08月17日. Retrieved 2016年11月28日.
- ^ "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日.
- ^ "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日.
- ^ "OpenOffice.org 3.0 New Features". 3.0 Features. OpenOffice.org. Archived from the original on 2021年01月25日. Retrieved 2008年11月10日.
- ^ "OpenOffice.org 3.3 New Features". 3.3 Features. OpenOffice.org. Archived from the original on 2024年08月17日. Retrieved 2010年12月13日.
- ^ AI Spreadsheet. Sourcetable Inc., 2024. Retrieved 2024年11月14日.