Comparison of spreadsheet software

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

Online versus Desktop[edit]

Web-based spreadsheets do not in general depend on a particular operating system or similar constraints and are therefore generally more portable by their nature than desktop applications.

Collaborative spreadsheets[edit]

Generally, online spreadsheets offer spreadsheet sharing and public sharing as part of their features which enables collaboration between multiple users.

Remote data update[edit]

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.

Gnumeric (listed below as a desktop spreadsheet) is also used as the "back-end" processor in at least one on-line spreadsheet application (Editgrid).

Online spreadsheets[edit]

The following tables only provide a comparison of desktop spreadsheet applications.

For a list and links to comparisons of online (web-based) spreadsheets, see List of online spreadsheets.

Google spreadsheets[edit]

See also: Google Docs

Google spreadsheets can be accessed from the documents window Google docs. To create a spreadsheet, the user must create an account.

Once with an account, the user can create a spreadsheet from scratch, or import data from an external spreadsheet or other sources. An example spreadsheet can be found here.

The spreadsheet has the capability of being read and worked on directly by using a web link. If the originating author elects that option, multiple authors can work on the same spreadsheet.

The capabilities of the spreadsheet have been perceived to be quite limited in comparison to, for example, Microsoft Excel. Google spreadsheet does not allow the use of named variables, and until recently had nothing comparable to Excel's programming feature (Visual Basic for Applications), but now Google Spreadsheets supports Javascript-based formulas that are quite powerful and expressive.

Desktop spreadsheets[edit]

General[edit]

Screenshot Creator Development started First public release Latest stable version Cost (USD) License
Calligra Sheets Calligra Sheets 2.4 screenshot.png KOffice KSpread Team 2.8.5 (5 July 2014; 45 days ago (2014-07-05)[1]) [±] Free LGPL
Gnumeric Gnumeric GNOME community 1998 1998 1.12.17 (June 10, 2014; 2 months ago (2014-06-10)[2]) [±] Free GPL
IBM Lotus Symphony IBM 2008 1.3 / 2009 Free Proprietary
LibreOffice Calc LibreOffice Calc The Document Foundation 2010 3.3 / 2011-01-25
Fresh

4.3.0 (30 July 2014; 20 days ago (2014-07-30)[3]) [±]

Stable

4.2.6 (2 August 2014; 17 days ago (2014-08-02)[3]) [±]

Free LGPL
Mariner Calc Mariner Calc Mariner Software 1988 1989 5.6.0 $49.95 Proprietary
Mesa P&L Software 1990 1991 3.1 / 2006-08 $34 Proprietary
CellPro Crystal Office Systems 2008 2008 1.33 Free Proprietary
Microsoft Excel Microsoft Excel Microsoft 1982 1985 15(64-bit) / January 2013 $239 (Standalone price; also can be purchased in various Microsoft Office bundles with varying prices) Proprietary
Numbers Numbers Apple, Inc. August 7, 2007 3.0 / October 23, 2013 Free Proprietary
OpenOffice Calc OpenOffice Calc Oracle Corporation 2000 Build 638c / October 2001 4.0 (July 23, 2013; 12 months ago (2013-07-23)) [±] Free Apache License v2
PlanMaker SoftMaker Software GmbH 1994[4][5] 2012 Free - 1 Month Test Version SoftMaker Office 2012,
or € 69.95 - SoftMaker Office 2012
Proprietary
Pyspread Martin Manns 2008 2008 0.2.7 / 2014-02-05 Free GPL
Quantrix Quantrix  ? Early 1990s 4.0 / 1Q 2011 $1,549, or more Proprietary
Quattro Pro Corel 1988 1988 X6  ? Proprietary
Resolver One Resolver One Resolver Systems 2005 2008-01-16 1.9 / 2010-06-04 Free as part of an open source project or to create open source spreadsheet systems or $99 open source / Proprietary
Siag Siag Office Ulric Eriksson 1996 3.6.1 / 2006 Free GPL
SSuite Accel Van Loo Software 2002 2005 8.1 Free Freeware
Tables Daniel Schwill 2004 First Public Beta / 2005-12 1.5.3 / 2009-05-01 $42 Proprietary
Screenshot Creator Development started First public release Latest stable version Cost (USD) License

Operating system support[edit]

The operating systems the software can run on natively (without emulation).

Windows Mac OS X Linux BSD Unix
Gnumeric Yes Yes Yes Yes Yes
IBM Lotus Symphony Yes Yes Yes No No
KSpread beta beta Yes Yes Yes
LibreOffice Yes Yes Yes Yes Yes
Mariner Calc No Yes No No No
Mesa No Yes No No No
CellPro Yes No No No No
Microsoft Excel Yes Yes No No No
Numbers No Yes No No No
OpenOffice Calc Yes Yes Yes Yes Yes
PlanMaker Yes No Yes No No
Pyspread Yes No Yes Yes Yes
SSuite Accel Yes No No No No
Quattro Pro Yes No No No No
Resolver One Yes No No No No
Siag No Yes Yes Yes Yes
Tables No Yes No No No
Windows Mac OS X Linux BSD Unix

Import/export capabilities[edit]

This table gives a comparison of what file formats each spreadsheet can import and export. "Yes" means can both import and export.

OpenOffice.org XML
(sxc)
CSV Excel
(xls)
HTML LaTeX ODF
(ods)
OOXML
(xlsx)
PDF DIF
Gnumeric Import Yes Yes Yes Export Yes Yes Export Import
IBM Lotus Symphony Yes Yes Yes Export No Yes Import Export
KSpread Yes Yes Import Export Export Yes No Export
LibreOffice Calc Yes Yes Yes Yes No Yes Yes Export Yes
Mariner Calc No Yes Yes No No No No Export
Mesa No Yes Yes No No No No Export
CellPro No Yes Yes No No No Import Export
Microsoft Excel No Yes Yes Partial No Yes Yes Export Import
Numbers No Yes Yes No No Import Import Export
OpenOffice Calc Yes Yes Yes Yes Export[6] Yes Yes Export Yes
Quattro Pro No Yes Yes Yes No No Import Export
PlanMaker No Yes Yes Export No No Import Export
Pyspread No Yes Import No No No No No
Resolver One No Yes Yes No No No No No
Siag Import partial Yes Import partial Yes Export No No Export
Tables Import partial Yes Yes Export Export Yes No Export
OpenOffice.org XML CSV XLS HTML LaTeX ODF .ods OOXML .xlsx PDF DIF

Spreadsheet comparison tools[edit]

Looking for changes in spreadsheets or checking to see if two copies of a spreadsheet have identical content can be a mind-numbing exercise, especially for the larger and more complex spreadsheets. For Microsoft Excel, at least, the data file is amended each time the file is opened, even if there are no actual changes in the spreadsheet itself. For this reason; using file comparison will always show differences if the two files have different viewing (file opened) histories, even if the contents are identical. The following tools are helpful to find if there are any actual differences between different spreadsheet files.

Creator Development started First public release Latest stable version Cost (USD) License
DiffEngineX DiffEngineX LLC 1997 1997 2.28 / 2012-09-05 $44 to $100 (30-day trial) Proprietary
Spreadsheet Compare 2004  ? 1.16 / 2010-11-10 Free GPL
Compare Excel files Spreadsheet Advantage  ?  ?  ? / ? $299 (30-day trial) Proprietary
Synkronizer Synkronizer 2000-07  ? 9.5 / 2008-02 €29 to €149 Proprietary
Spreadsheet Professional Miricle Solutions  ?  ?  ? / ?  ? (30-day trial) Proprietary
Excel Diff - Excel Compare Tool - SUNTRAP SYSTEMS 2005 2005 4.2.0 / 2013-04-03 $78 to $98 (30-day trial) Proprietary

See also[edit]

References[edit]

  1. ^ "Calligra 2.8.5 Released". 
  2. ^ "Gnumeric 1.12.17 aka "TBD" is now available.". Retrieved 2014-07-23. 
  3. ^ a b "Release Notes". The Document Foundation. 30 July 2014. Retrieved 30 July 2014. 
  4. ^ "Infos zu PlanMaker 97". 1997-06-03. Archived from the original on 1997-06-03. Retrieved 2010-03-28. 
  5. ^ Andy Updegrove (2006-07-05). "The Emerging ODF Environment, Part IV: Spotlight on SoftMaker Office 2006". Retrieved 2010-03-28. 
  6. ^ Through extensions: "Calc2LaTeX". 2009-07-15. Retrieved 2012-05-06.