This article may require cleanup to meet Wikipedia's quality standards. The specific problem is: wikidata references are not displaying properly.(August 2023) |
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.
Name | Developer | Initial release | Platform | Latest release | License | |
---|---|---|---|---|---|---|
Version | Date | |||||
Apache OpenOffice Calc | Apache Software Foundation | 2012-05-08 | GNU/Linux | 4.1.14 [1] | 2023-02-27 | Apache-2.0 |
macOS | ||||||
Windows | ||||||
AppleWorks | Apple Inc. | 1991 | macOS | 6.2.9 [2] | 2004-01-14 | Proprietary |
Windows | 6.2.2 [3] | 2004-01-20 | ||||
Calligra Sheets | KOffice KSpread Team | BSD | 3.2.1 [4] | 2020-05-14 | LGPL | |
GNU/Linux | ||||||
macOS | ||||||
Windows | ||||||
Collabora Online Calc | Collabora | 2019 [lower-alpha 1] | Android | 23.05 [5] | 2023-09-21 | MPL-2.0 |
2021 [lower-alpha 2] | BSD | Build your own | Build your own | |||
2019 [lower-alpha 1] | ChromeOS | 23.05 [5] | 2023-09-21 | |||
2019 [lower-alpha 1] | iOS | 23.05 [5] | 2023-09-21 | |||
2019 [lower-alpha 1] | iPadOS | 23.05 [6] | 2023-09-21 | |||
2016 [lower-alpha 3] | Linux | Online server: 23.05.4 [7] | 2023-09-21 | |||
2015 [lower-alpha 4] | Desktop app: 23.05.4 [8] | 2023-09-18 | ||||
2015 [lower-alpha 4] | macOS | 23.05.4 [8] | 2023-09-18 | |||
2015 [lower-alpha 4] | Windows | 23.05.4 [8] | 2023-09-18 | |||
Google Sheets | 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 | 1.6.16 [9] | 1999-03-10 | GPL-3.0-or-later |
Gnumeric | GNOME community | 1998 [lower-alpha 8] | BSD | 1.12.55 [10] [11] | 2023-02-03 | GPL-2.0-only or GPL-3.0-only |
GNU/Linux | ||||||
macOS | ||||||
Windows [lower-alpha 9] | ||||||
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 | GNU/Linux | 3.0.1 FP2 [15] [16] | 2012-11-29 | Proprietary |
macOS | ||||||
Windows | ||||||
LibreOffice Calc | The Document Foundation | 2011-01-25 [lower-alpha 10] | BSD | 7.3.5 [17] | 2022-07-21 | 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 [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 | 1993 | Proprietary |
1988 | macOS | 4.0b | 1994 | |||
1991 | Windows | 9 [22] | 2007-09-28 | |||
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 | 7.5.0 [23] | 2023-10-17 | AGPL-3.0-only |
macOS | ||||||
Windows | ||||||
OpenOffice.org Calc | Sun Microsystems [lower-alpha 14] Oracle Corporation [lower-alpha 15] | 2002-05 | BSD | 3.3.0 [24] | 2011-01-17 | Apache-2.0 |
GNU/Linux | ||||||
macOS | ||||||
Solaris/Illumos | ||||||
Unix | ||||||
Windows | ||||||
PlanMaker | SoftMaker Software GmbH | 1994 [25] [26] | Android | 2024 | 2023-06-20 | Proprietary |
GNU/Linux | ||||||
macOS | ||||||
Windows | ||||||
Pyspread | Martin Manns | 2008 [lower-alpha 16] | BSD | 2.2.2 [27] | 2023-08-30 | 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 | 7.16 [28] | 2002-09-20 | Public domain | |
Siag | Ulric Eriksson | [lower-alpha 18] | BSD | 3.6.1 [29] | 2006-11-10 | GPL-2.0-or-later |
GNU/Linux | ||||||
Unix | ||||||
Windows | ||||||
StarOffice StarCalc | Sun Microsystems | 1994 | GNU/Linux | 9.0U3 [30] [31] [32] | 2009-09-09 | 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 |
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 [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 | ? |
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 | No | No | Yes | Yes | Export | No | No |
Collabora Online Calc - desktop | Yes | Yes | Yes | 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 | 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 |
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 [40] | 16,384 | 17,179,869,184 [41] | 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 [42] | 16,384 | 17,179,869,184 [43] | 1,024 | 17,592,186,044,400 |
Lotus 1-2-3 [44] | 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 [45] [46] [47] | 1,048,576 | 16,384 | 17,179,869,184 | Limited by available memory | Limited by available memory |
OpenOffice.org Calc 2 [48] | 65,536 | 256 | 16,777,216 | 256 | 4,294,967,296 |
OpenOffice.org Calc 3.0, 3.1 and 3.2 [49] [50] | 65,536 | 1024 | 67,108,864 | 256 | 17,179,869,184 |
OpenOffice.org Calc 3.3 [51] | 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.
Microsoft Excel is a spreadsheet editor developed by Microsoft for Windows, macOS, Android, iOS and iPadOS. It features calculation or computation capabilities, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications (VBA). Excel forms part of the Microsoft 365 suite of software.
Microsoft Office, or simply Office, is a discontinued family of client software, server software, and services developed by Microsoft. It was first announced by Bill Gates on August 1, 1988, at COMDEX in Las Vegas. Initially a marketing term for an office suite, the first version of Office contained Microsoft Word, Microsoft Excel, and Microsoft PowerPoint. Over the years, Office applications have grown substantially closer with shared features such as a common spell checker, Object Linking and Embedding data integration and Visual Basic for Applications scripting language. Microsoft also positions Office as a development platform for line-of-business software under the Office Business Applications brand.
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.
The following tables compare general and technical information for a number of office suites:
This is an overview of software support for the OpenDocument format, an open document file format for saving and exchanging editable office documents.
This is a comparison of word processing software.
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.
ChromeOS, sometimes styled as chromeOS and formerly styled as Chrome OS, is a Linux-based operating system developed and designed by Google. It is derived from the open-source ChromiumOS and uses the Google Chrome web browser as its principal user interface.
Chromebook is a brand name and class of laptop and tablet computers that run the Linux-based ChromeOS as its operating system. It is a trademark of Google, who develops and markets ChromeOS.
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.
LibreOffice Calc is the spreadsheet component of the LibreOffice software package.
LibreOfficeDraw is a free and open source vector graphics editor. It is one of the applications included in the LibreOffice office suite, developed by The Document Foundation.
Google Drive is a file storage and synchronization service developed by Google. Launched on April 24, 2012, Google Drive allows users to store files in the cloud, synchronize files across devices, and share files. In addition to a web interface, Google Drive offers apps with offline capabilities for Windows and macOS computers, and Android and iOS smartphones and tablets. Google Drive encompasses Google Docs, Google Sheets, and Google Slides, which are a part of the Google Docs Editors office suite that permits collaborative editing of documents, spreadsheets, presentations, drawings, forms, and more. Files created and edited through the Google Docs suite are saved in Google Drive.
Google Sheets is a spreadsheet application included as 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.
Smartsheet is a software as a service (SaaS) offering for collaboration and work management, developed and marketed by Smartsheet Inc. It is used to assign tasks, track project progress, manage calendars, share documents, and manage other work, using a tabular user interface.
Collabora Online is an open source online office suite built on LibreOffice Technology, 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.
...Without any fanfare, Microsoft finally made Word, Excel, Outlook, and PowerPoint available for (apparently) all Chromebooks.
...it's too expensive to support Office apps on the larger screen Chromebook devices which are rivalling Windows in some markets.
...Requires active Office 365 subscription to edit Word, Excel and PowerPoint files, but no iPad version for now.
...Office 365 subscription is needed to edit as well as create documents.
...touch optimized interfaces: one for tablets and one for phone screens. ...(iOS, iPadOS, Chrome OS, Android).
...it's too expensive to support Office apps on the larger screen Chromebook devices which are rivalling Windows in some markets.