Google Docs now understands .xlsx format & further improvements in Spreadsheets

A new version of Google Spreadsheets is here! And it can import files in XLSX format also :) …..

In November 2006, Office 2007 introduced a new file format: Office Open XML. Now, nearly 2.5 years later, Google can import XLSX files into Google Docs. Besides this change, Google has even more updates in Google Spreadsheets, released.

Make sure to check out the following new features in Google Docs:

• XLSX import. Excel ’07 files (xlsx) can now be successfully imported into Google spreadsheets, supporting cell data, formatting, formulas, font style, background color, named ranges, frozen panes, and horizontal merges. And currently there is no option to export files as .xlsx.
• Google Tournament function. The GoogleTournament() function allows users to query NCAA data (including team names, records, scores, seedings, game times, etc) in a Google spreadsheet (ideal for creating automatic brackets). More info here: http://docs.google.com/support/bin/answer.py?answer=142595 and in this blog post:  http://googledocs.blogspot.com/2009/03/new-template-2009-college-basketball.html Also check out GoogleTournament Google has added to our templates gallery: http://docs.google.com/previewtemplate?id=0As3tAuweYU9QcHlVM3hrY2tocEkxaU12Q01UZmlvRUE
• Updated GoogleLookup. The GoogleLookup() function will now attempt to find answers to questions it couldn’t answer before. In addition, there’s now a dialog box to help you pick from among a handful of possible answers if GoogleLookup isn’t sure. Just select the cell and click ‘More Options…’ to choose a different value. More info here: http://docs.google.com/support/bin/answer.py?answer=54199
• Updated Motion Chart. The Motion Chart team recently added new features like bar charts and zoom. More info is in our Help Center at: http://docs.google.com/support/bin/answer.py?hl=en&answer=91610 You can also check out this example here: http://spreadsheets.google.com/pub?key=pCQbetd-CptE1ZQeQk8LoNw
• Google Apps automatic identity in Forms. This feature enables the optional collection of the user’s email address when filling out a form on a Google Apps domain. More info here: http://docs.google.com/support/bin/answer.py?answer=87809
• Form summary page printing. The form summary page can now be printed through your browser’s “Print” menu.

For more information on bug fixes and notable fixes, visit the Google Docs blog here!