Comparison of spreadsheet software

From Wikipedia, the free encyclopedia

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[]

Name Screenshot Creator Development started First public release Latest stable version License
Apache OpenOffice Calc OpenOffice.org Calc.png Apache Software Foundation 2000 Build 638c / October 2001 4.1.11 (October 6, 2021; 5 months ago (2021-10-06)) Apache-2.0
Calligra Sheets CalligraSheets3.1Screenshot.png KOffice KSpread Team 3.2.1 (14 May 2020; 21 months ago (2020-05-14)[1]) LGPL
Collabora Online Calc
Desktop web browser accessing Collabora Online spreadsheet 6.4.9 with the sidebar toggled on
Web browser accessing Collabora Online 6.4.9 with the sidebar toggled on
 Collabora 2013 2016 21.11.2.4 (3 March 2022; 8 days ago (2022-03-03)[2]) MPL-2.0
Gnumeric Gnumeric 1.8.1.png GNOME community 1998 1998 1.12.50 (11 June 2021; 9 months ago (2021-06-11)[3]) GPL-2.0-only or GPL-3.0-only
IBM Lotus Symphony IBM 2008 1.3 / 2009 Freeware
LibreOffice Calc LibreOffice 5.1 Calc (Tango).png The Document Foundation 2010 3.3 / 2011-01-25
  • Fresh:[4] 7.3.1[5] Edit this on Wikidata (3 March 2022)
  • Still:[4] 7.2.6[6] Edit this on Wikidata (10 March 2022)
MPL-2.0
Mariner Calc Mariner Software 1988 1989 5.6.0 Discontinued
Microsoft Excel Microsoft 1982 1985 16 (64-bit) / September 2015 Freemium
Numbers Apple, Inc. August 7, 2007 3.5 / October 16, 2014 Commercial Proprietary software
OnlyOffice
ONLYOFFICE online spreadsheet editor
 Ascensio System SIA 2009 2014 AGPL-3.0-only
PlanMaker SoftMaker Software GmbH 1994[7][8] 2012 Trialware
Pyspread Pyspread screenshot - sinus large.png Martin Manns 2008 2008 1.1.3 (February 8, 2019; 3 years ago (2019-02-08)) GPL-3.0-or-later
Quattro Pro Corel 1988 1988 2020 / 2020 Trialware
Resolver One Resolver Systems 2005 2008-01-16 1.9 / 2010-06-04 Discontinued
Siag SiagOffice 3.4.9.png Ulric Eriksson 1996 3.6.1 / 2006 GPL-2.0-or-later
WPS Office Kingsoft 1988 1988 2019 Freemium
Name Screenshot Creator Development started First public release Latest stable version License

Operating system support[]

The operating systems the software can run on natively (without emulation). iOS and Android apps can be optimized for iPads and Chromebooks which run different operating systems; iPadOS and Chrome OS respectively, optimizations may include things like multitasking capabilities, large and multiple displays, better keyboard and mouse support.

Name Windows macOS Linux BSD Unix Android Chrome OS optimized iOS iPadOS optimized
Apache OpenOffice Calc Yes Yes Yes Yes Yes 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[9] 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 Yes
Numbers No Yes No No No No No 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[10] 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[11][12] Yes Yes Export Yes Yes
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[13][14] Yes Yes Export Yes Yes
Mariner Calc Yes Yes No No No No Export No
Microsoft Excel Yes Yes Partial No Yes Yes Export Import 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

See also[]

References[]

  1. ^ "Calligra 3.2.1". Retrieved 22 December 2021.
  2. ^ "Collabora Online 21.11 Release Notes". collaboraoffice.com.
  3. ^ "Tags - GNOME / gnumeric". Retrieved 28 August 2021.
  4. ^ a b https://www.libreoffice.org/download/download/
  5. ^ "LibreOffice 7.3.1 Community available for download". 3 March 2022. Retrieved 3 March 2022.
  6. ^ "Announcement of LibreOffice 7.2.6 Community". 10 March 2022. Retrieved 10 March 2022.
  7. ^ "Infos zu PlanMaker 97". 1997-06-03. Archived from the original on 1997-06-03. Retrieved 2010-03-28.
  8. ^ Andy Updegrove (2006-07-05). "The Emerging ODF Environment, Part IV: Spotlight on SoftMaker Office 2006". Retrieved 2010-03-28.
  9. ^ "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).{{cite news}}: CS1 maint: url-status (link)
  10. ^ Through extensions: "Calc2LaTeX". 2009-07-15. Retrieved 2012-05-06.
  11. ^ Through extensions: "TexMaths". 2021-03-14. Retrieved 2021-08-09.
  12. ^ Through extensions: "Writer2LaTeX". 2018-10-19. Retrieved 2021-08-09.
  13. ^ Through extensions: "TexMaths". 2021-03-14. Retrieved 2021-08-09.
  14. ^ Through extensions: "Writer2LaTeX". 2018-10-19. Retrieved 2021-08-09.
Retrieved from ""