Comparison of spreadsheet software

From Wikipedia, the free encyclopedia
Jump to navigation Jump to search

Template:Short description

Script error: No such module "Unsubst". 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 Developer Initial release Platform Latest release License
Version Date
Apache OpenOffice Calc Apache Software Foundation 2012-05-08 Linux Template:Wikidata Template:Wikidata rowspan="3" Template:Open source
macOS
Windows
AppleWorks Apple Inc. 1991 macOS Template:Wikidata Template:Wikidata Proprietary
Windows Template:Wikidata Template:Wikidata
Calligra Sheets KOffice KSpread Team BSD Template:Wikidata Template:Wikidata rowspan="4" Template:Open source
Linux
macOS
Windows
Template:Rh rowspan="10" | Collabora Online Collabora 2019Template:Efn Android Template:Wikidata Template:Wikidata rowspan="10" Template:Open source
2021Template:Efn BSD Build your own Build your own
2019Template:Efn ChromeOS Template:Wikidata Template:Wikidata
2019Template:Efn iOS Template:Wikidata Template:Wikidata
2019Template:Efn iPadOS Template:Wikidata Template:Wikidata
2016Template:Efn Linux Online server: Template:Wikidata Template:Wikidata
2015Template:Efn Desktop app: Template:Wikidata Template:Wikidata
2015Template:Efn CODE:Template:Efn Template:Wikidata Template:Wikidata
2015Template:Efn macOS Template:Wikidata Template:Wikidata
2015Template:Efn Windows Template:Wikidata Template:Wikidata
Google Sheets Google 2006Template:Efn AndroidTemplate:Efn Rolling Rolling Proprietary
ChromeOSTemplate:Efn
iOSTemplate:Efn
LinuxTemplate:Efn
macOSTemplate:Efn
WindowsTemplate:Efn}
GNU Oleo Tom Lord 1992 Linux Template:Wikidata Template:Wikidata Template:Open source
Gnumeric GNOME community 1998Template:Efn BSD Template:Wikidata Template:Wikidata rowspan="4" Template:Open source
Linux
macOS
WindowsTemplate:Efn
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 Linux Template:Wikidata Template:Wikidata Proprietary
macOS
Windows
LibreOffice Calc The Document Foundation 2011-01-25Template:Efn BSD Template:Wikidata Template:Wikidata rowspan="5" Template:Open source
Linux
macOS
Unix
Windows
Mariner Calc Mariner Software 1989Template:Efn iOS? 5.6.0 Dropped Proprietary
Microsoft ExcelTemplate:Efn 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 Template:Wikidata Template:Wikidata Proprietary
1988 macOS Template:Wikidata Template:Wikidata
1991 Windows Template:Wikidata Template:Wikidata
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 2014Template:Efn Linux Template:Wikidata Template:Wikidata rowspan="3" Template:Open source
macOS
Windows
OpenOffice.org Calc Sun MicrosystemsTemplate:Efn
Oracle CorporationTemplate:Efn 		2002-05 BSD Template:Wikidata Template:Wikidata rowspan="6" Template:Open source
Linux
macOS
Solaris/Illumos
Unix
Windows
PlanMaker SoftMaker Software GmbH 1994[8][9] Android 2024 2023-06-20 Proprietary
Linux
macOS
Windows
Pyspread Martin Manns 2008Template:Efn BSD Template:Wikidata Template:Wikidata rowspan="4" Template:Open source
Linux
Unix
Windows
Quattro Pro Corel 1988Template:Efn Windows 2020 2020 Proprietary
Resolver One Resolver Systems 2008-01-16Template:Efn Windows 1.9 2010-06-04 Proprietary
sc James Gosling et al 1981 Template:Wikidata Template:Wikidata Template:Open source
Siag Ulric Eriksson Template:Efn BSD Template:Wikidata Template:Wikidata rowspan="4" Template:Open source
Linux
Unix
Windows
Sourcetable[10] Sourcetable Inc. 2020Template:Efn ChromeOS Rolling Rolling Proprietary
StarOffice StarCalc Sun Microsystems 1994 Linux Template:Wikidata Template:Wikidata 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

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[11] 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 [12] 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[13] 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[14][15] 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[16][17] 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[18] Yes Yes Import partial No Import partial Yes No No

Rows and Columns

Template:Expand list

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[19] 16,384 17,179,869,184[20] 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[21] 16,384 17,179,869,184[22] 1,024 17,592,186,044,400
Lotus 1-2-3[23] 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[24][25][26] 1,048,576 16,384 17,179,869,184 Limited by available memory Limited by available memory
OpenOffice.org Calc 2[27] 65,536 256 16,777,216 256 4,294,967,296
OpenOffice.org Calc 3.0, 3.1 and 3.2[28][29] 65,536 1024 67,108,864 256 17,179,869,184
OpenOffice.org Calc 3.3[30] 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[31] 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

Notes

Template:Notelist

References

<templatestyles src="Reflist/styles.css" />

  1. ↑ Script error: No such module "citation/CS1".
  2. ↑ Script error: No such module "citation/CS1".
  3. ↑ Script error: No such module "citation/CS1".
  4. ↑ Script error: No such module "citation/CS1".
  5. ↑ Script error: No such module "citation/CS1".
  6. ↑ Script error: No such module "citation/CS1".
  7. ↑ Script error: No such module "citation/CS1".
  8. ↑ Script error: No such module "citation/CS1".
  9. ↑ Script error: No such module "citation/CS1".
  10. ↑ AI Spreadsheet. Sourcetable Inc., 2024. Retrieved 2024-11-14.
  11. ↑ Script error: No such module "citation/CS1".
  12. ↑ Script error: No such module "citation/CS1".
  13. ↑ Through extensions: Script error: No such module "citation/CS1".
  14. ↑ Through extensions: Script error: No such module "citation/CS1".
  15. ↑ Through extensions: Script error: No such module "citation/CS1".
  16. ↑ Through extensions: Script error: No such module "citation/CS1".
  17. ↑ Through extensions: Script error: No such module "citation/CS1".
  18. ↑ AI Spreadsheet. Sourcetable Inc., 2024. Retrieved 2024-11-14.
  19. ↑ Script error: No such module "citation/CS1".
  20. ↑ Script error: No such module "citation/CS1".
  21. ↑ Script error: No such module "citation/CS1".
  22. ↑ Script error: No such module "citation/CS1".
  23. ↑ Script error: No such module "citation/CS1".
  24. ↑ Script error: No such module "citation/CS1".
  25. ↑ Script error: No such module "citation/CS1".
  26. ↑ Script error: No such module "citation/CS1".
  27. ↑ Script error: No such module "citation/CS1".
  28. ↑ Script error: No such module "citation/CS1".
  29. ↑ Script error: No such module "citation/CS1".
  30. ↑ Script error: No such module "citation/CS1".
  31. ↑ AI Spreadsheet. Sourcetable Inc., 2024. Retrieved 2024-11-14.

Script error: No such module "Check for unknown parameters".

Template:Spreadsheets

Retrieved from "http://debianws.lexgopc.com/wiki143/index.php?title=Comparison_of_spreadsheet_software&oldid=3956516"