Google Tables for Viewing Large Excel Spreadsheets on the Web

Jun

9

2009

If you need to view Excel data without Microsoft Office, just upload the file to Google Docs and it will display the spreadsheet data in the web browser. This sounds like an easy plan but the problem is that you can’t import large volumes of data into Google Docs.

For instance, Google Docs would only allow you to import spreadsheets (or CSV files) that are less than 1 MB in size and have no more than 200,000 cells in 256 columns or less.

These kind of size limits should be sufficient for most spreadsheets but you may find them pretty limiting in case you are planning to view large amounts of data in Google Docs like the population statistics of the world. view large data

Enter Google Fusion Tables – it’s a new product that lets you view Excel files as large as 100 MB in the browser – you can either upload the files from the desktop or pull it directly from your Google Spreadsheets gallery.

Unlike Spreadsheet, Google Tables is primarily for handling tabular data so it can’t understand formulas or cell formatting. However, the system can recognize columns that contain values that can be geo-coded. For instance, if the column contains country names or street addresses, Google Tables can easily plot that data onto a world map.

google tables

You can also apply filters to the data or create views so that only a subset of data is visible to the outside world. Later, you can export the edited data out of Google Fusion Tables as a CSV file.

Related: Google Docs Guide & Tutorial


Asked by wordpress on June 9, 2009

Answer this Question

You must be Logged In to post an Answer.

Not a member yet? Sign Up Now »


Possibly related stories:

 · Exploring Ways to Embed Tables & Spreadsheets in Web Pages
 · Publish Spreadsheets in Google Docs Directly as PDF or Excel Files
 · Extract Tables from PDF files into Excel or HTML
 · Capture Live Text from Web Pages Into Excel Spreadsheets
 · Embed Interactive Excel Spreadsheets in Your HTML Website
 · Now Upload Excel 2007 Files to Google Docs
 · Good Reasons to Use Blist for Web Based Spreadsheets & Databases
 · Google Spreadsheets Screenshots
 · Sharing an Excel Spreadsheet Online with Colleagues in a Collaborative Manner
 · Google Apps, Google Docs and Gmail – New Features