Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

Office licenses are expensive. What features of Microsoft Office are missing from Google Spreadsheets that would be of value in ordinary personal or business use?

share|improve this question

closed as off-topic by jonsca Mar 5 at 6:46

  • This question does not appear to be about web applications within the scope defined in the help center.
If this question can be reworded to fit the rules in the help center, please edit the question.

1  
Possible duplicate: webapps.stackexchange.com/questions/538/… –  Tal Galili Jul 1 '10 at 20:35
1  
Not a dupe, that question was geared directly to college students. This one is more general in nature. –  Evan Plaice Jul 7 '10 at 21:52
    
@TalGalili hat question is generally about Google Docs and this is particularly about Speardsheets. –  user221287 Jun 1 '12 at 7:59
    
It has really bothered me that there is no CLEAN() function in Google Spreadsheets. See webapps.stackexchange.com/questions/33989/… –  Ryan Nov 1 '12 at 15:26
    
This question appears to be off-topic because it is about an older version of Google Spreadsheets, and many of the answers have become outdated. –  jonsca Mar 5 at 6:46
add comment

8 Answers 8

The Google spreadsheet cells are always collapsed. Information put in those cells with linefeed does not appear properly. This happens when you download those spreadsheets and open them in either Open Office or MS Office.

share|improve this answer
add comment

Besides what's already been said:

Lack of text-to-column parsing.

That is, if I have a raw string like

Blah|2|4|5|www.google.com
Foo|2|1|1.2|www.twitter.com

It's trivial to have Excel quickly do a text-to-columns on that, using | as a delimiter. Making data formatting as simple as possible is crucial to people who need to create or interact with data tables on a regular basis.

(You can get much more creative with its use; I regularly format complex, messy data sets with just a few text-to-column interations.)

Update (Evan): This isn't built-in feature but it can be added

The first technique uses some spreadsheet function magic

In cell B2 paste the following:

=ARRAYFORMULA(IFERROR(SPLIT(A1:A;"|")))

Then paste your data starting with cell A2. As soon as you enter the data it will automatically split the combined values to a value-per-column using the '|' as a delimiter.

Here's credit to the original author of this approach.

The second approach uses some scripting magic to extend Docs

Goto:

Tools -> Script editor...

Paste the following:

function onOpen() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var menuEntries = [];
  menuEntries.push({ name:"Text to column", functionName:"textToColumn" });
  menuEntries.push({ name:"Text to column (custom separator)", functionName:"txtToColumnCustom" });
  ss.addMenu("Advanced", menuEntries);
}

function txtToColumnCustom() {
  var separator = Browser.inputBox("Text to column","Enter the the separator",Browser.Buttons.OK);
  textToColumn(separator);
}

function textToColumn(separator) {
  var sep = typeof(separator) != 'undefined' ? separator : ',';
  var ss = SpreadsheetApp.getActiveSheet(); 
  var c = ss.getActiveCell();
  var input = c.getValue();
  var values = input.split(sep);
  var row = c.getRow();
  var col = c.getColumn();
  ss.getRange(row,col,1,values.length).setValues(new Array(values));
}

Save and close the script editor. Then, refresh the spreadsheet. It'll take a second to load but you should see a menu called 'Advanced' popup after 'Help' in the toolbar.

To use it:

  • Select the cell containing the values
  • Select 'Advanced' -> 'Text to column (custom separator)'
  • When the prompt pops up enter '|' (without quotes) into the field and hit enter

It's magic, it'll automatically split the values out into columns. If you were wondering the non-custom 'Text to column' function uses commas as separators.

This version only works on one row at a time. I have been doing a lot of custom Google Apps Scripting lately so it literally only took about 20-30 minutes to get this from concept to working. If you want one where you can select and split multiple rows just request it in the comments or use the formula above.

Whatever you do, don't underestimate the power of Google Apps Scripting. In the right hands, it is capable of doing amazing things.

share|improve this answer
    
=split() is almost exactly equivalent to Text to Columns. –  pnuts Feb 21 at 3:15
add comment

I would say the two that I notice are:

  • Lack of spell check
  • Not as many chart types built in, in particular, basic charts for stocks.
share|improve this answer
    
If you mean the likes of error bars, these are available in New Google Sheets. –  pnuts Feb 21 at 3:18
add comment

I find the inability of Google spreadsheets to select noncontiguous rows or columns a serious limitation, particularly when formatting a spreadsheet. Keyboard shortcuts that will work on one platform but not another seriously hinders my use of Google docs in general. (That said, I use Google Documents a lot and wish I could use it for more.)

share|improve this answer
    
New Google Sheets allows selection of non-contiguous ranges. –  pnuts Feb 21 at 3:14
add comment

If you're just looking for rows/columns to insert data, then Google Spreadsheets are the way to go. Two really cool applications for Google Spreadsheets is using it to create a live Feedback form for any website (if you know how to edit HTML, then you can even take the attributes from the Google Form and use your own website's HTML and CSS to format the form). Also, Google allows for great collaboration (although if you're on a local network, sharing an Excel workbook does the same thing).

A webapp that is, in my opinion, more powerful than Google Spreadsheet is Zoho Sheets. Zoho has both very good VBA support as well as pivot tables.

For anything else, sorry, but you're going to have to shell out the money to Microsoft.

share|improve this answer
add comment

Google spreadsheets formatting is limited compared to the newer versions of Excel (2007+). I have found it much easier to create usable spreadsheets with a decent UI using Excel than Google Spreadsheets - everything I do with the latter looks like Excel 2003!

Google spreadsheets does web interaction much better than Excel (retrieving info from the web such as share prices, web searches etc).

share|improve this answer
add comment

I can't speak to a specific limitation but Google Spreadsheets do things differently than MS Excel. For instance if you need to program in excel you will use VBA. If you are going to program in Google Spreadsheets you will need to use javascript.

I am pretty sure that you will not get to keep your macro's when you import a spreadsheet from Excel into Google Spreadsheets. If that is an issue for you then you might not want to convert.

In general Google Spreadsheets can do a lot of the same things but you may find ease of use things like Conditional Formatting or some of the advanced chart and graph features that exist in Excel either don't exist and must be built, require an app from the marketplace, or are just harder to use.

Since Google apps are free, I would spend about a 2 weeks trying out Spreadsheet. If you haven't run into anything stopping you then you are probably not going to have any issues.

share|improve this answer
1  
I won't downvote, but I wouldn't consider GSpreadsheet using Javascript over VB a limitation. Neither would I consider the lack of macro cross compatibility with Excel a limitation either, I'd consider it a limitation of Excel that it doesn't support the more widely used and universal Javascript for macros. –  Evan Plaice Jul 7 '10 at 22:05
    
@Evan - I Agree with you. My point was when you have code in one language it takes time and/or money to convert to another language. In this case from VBA to JavaScript. In general, I would assume JavaScript can do everything (and probably much more) than VBA but I don't know the differences well enough to say for sure. Regardless effort would be involved in converting macros. –  RandomBen Jul 8 '10 at 13:27
    
The only reason I brought it up is. In a 1-1 comparison of Google Spreadsheets to Excel this isn't a feature limitation. It's only a disadvantage if you're migrating an Excel spreadsheet containing macros to Google Spreadsheets. –  Evan Plaice Jul 8 '10 at 17:34
    
Er... the first sentence in Ben's paragraph says, "I can't speak to a specific limitation but Google Spreadsheets do things differently", so he pretty clearly isn't saying that it's a feature limitation, just a difference. –  Matt Parker Jul 20 '10 at 5:12
    
Sorry, I downvoted because you gave incorrect advice. You said "Conditional Formatting ... either don't exist and must be built". Just yesterday I was working in Excel and shocked that I could not do Conditional Formatting on text content in a cell when Google Docs does allow "Change colors with rules" which has more rules available. –  Bernhard Hofmann Jul 20 '10 at 6:38
add comment

Google Spreadsheets doesn't have Pivot Tables built in. For any serious data analysis that could be a real deal breaker.

However, it does appear that there are apps in the marketplace that add this functionality in, for example:

http://www.google.com/enterprise/marketplace/viewListing?productListingId=3466+14613093613005114004

share|improve this answer
2  
-1 This is no longer true. Google Spreadsheets fully supports pivot tables now by default. –  Evan Plaice Jan 14 '12 at 2:48
1  
It doesn't even have a decent cell format for dates... dd/mm/yyyy (dddd), etc. for 21/09/2013 (Sunday)... with Weekday... you need to have a long hack to make a simple date format... and many more.. Google Spreadsheet is for simple use only... not for anything so serious. –  ihightower May 29 '13 at 10:38
    
@ihightower New Google Sheets allows dddd dd mmm yyyy format, and more. –  pnuts Feb 21 at 3:12
    
@pnuts thanks for the info.. yes that's great. i haven't checked other new features.. but am sure it will still have a long way to go to reach MS Excel. –  ihightower Feb 22 at 4:27
add comment

Not the answer you're looking for? Browse other questions tagged or ask your own question.