当前位置:首页 > 未分类 > 正文内容

Google Tables for Viewing Large Excel Spreadsheets on the Web

ceacer3周前 (05-02)未分类3923

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

相关文章

How to Email Google Sheets Automatically on a Recurring Schedule

How to Email Google Sheets Automatically on a Recurring Schedule

The Email Spreadsheets add-on for Google Sheets can save office workers a ton of time by automating...

Google Maps Formulas for Google Sheets

Google Maps Formulas for Google Sheets

You can bring the power of Google Maps to your Google Sheets using simple formulas with no coding. Y...

How to Transcribe Audio and Video Attachments in Gmail

How to Transcribe Audio and Video Attachments in Gmail

The Save Gmail to Google Drive add-on lets you automatically download email messages and file attach...

How to Use Conditional Logic in Google Documents

How to Use Conditional Logic in Google Documents

Conditional content allows you to customize your Google Docs template and generate different version...

Send WhatsApp Messages with a Google Sheets Function

Send WhatsApp Messages with a Google Sheets Function

In a previous tutorial, you learned how to send WhatsApp messages from Google Sheets using the offic...

How to Play an MP3 File in Google Sheets

How to Play an MP3 File in Google Sheets

You can put the link of any MP3 audio file in Google Sheets but when you click the file link, the au...