Last week we added a new feature in Zoho Sheet which helps you to sync up with data available in the form of HTML tables in public web pages. We had this syncing up with public CSV files earlier, and now we have added support for tables of data in web pages. So if you want to have your spreadsheet filled in with data automatically updated from a particular web page and do some analysis on it, then this would be quite useful. If you have used Web Query in Excel, then you will be able to relate to this feature.
Here is a sample spreadsheet which makes use of web query:
In the above spreadsheet, the exchange rates are fetched daily from http://x-rates.com. Based on the exchange rate, the total sales in USD is calculated (refer cell F21).
And here is how you can configure your spreadsheet to make use of this feature. Use the ‘Link External Data’ feature available under the ‘More Actions’ menu.
How are you using this feature? Share your story on our discussion forums.
Apart from this, we have improved the page loading speed (especially when you login). More performance improvements are coming.