Web data in your spreadsheet
Quickly import data from any website in Microsoft Excel and Google Sheets
There are many useful data sets on the Web, including data tables, linked CSV files and the metadata embedded in every web page. With this spreadsheet integration for Google Sheets and Microsoft Excel, you can lookup and import current, on-demand data from the Web without leaving your spreadsheet.
- Lookup and import the web links on a web page
- Import embedded tweets on a web page, including Twitter handles and links
- Import metadata for a web page, such as the page title and keywords
- Import metadata for news articles, such as title, author and published date
Lookup embedded tweets in a web page
Lookup metadata for a set of web pages
Lookup metadata for news and blog posts
Need help with a Web Data function? Check out the Web Data functions and syntax documentation.
Have questions? Need help getting started? Need other Web Data templates or functions for Microsoft Excel or Google Sheets? Chat with us; we're happy to help!