Web
+
Google Sheets
+
Microsoft Excel

The Web in your spreadsheet

Import live, refreshable data from Websites into Microsoft Excel and Google Sheets.

Import website data in your spreadsheet

This Website spreadsheet integration for Google Sheets and Microsoft Excel enables you to import data from Website into your spreadsheet.

For example, with this Excel and Google Sheets add-on you can:

  • Extract links from a web page corresponding to specific text
  • Get summary information for a web page

Click here to learn more about the specific syntax for each of the Web spreadsheet functions.

Getting Started

Flex.io makes it easy to create, use and share custom spreadsheet functions that import data from services you know and love. Click on the button below to use the Web function collection with Microsoft Excel or Google Sheets.

Need Help?

Have questions? Need help with installation? Need other Web functions for Microsoft Excel or Google Sheets? Chat with us; we're happy to help!

Functions and Syntax

This integration for Microsoft Excel or Google Sheets includes the following functions:

Returns information for all hyperlinks on one-or-more web pages matching a search string; information includes domain, link, and matching text.

Syntax

=FLEX("YOUR_TEAM_NAME/web-extract-link", url, search, [properties])

Parameters

Property Type Description Required
url array Urls of web pages to search; parameter can be a single url or a comma-delimited list of urls. true
search string The search string to use to find the corresponding links. true
properties array The properties to return (defaults to all properties). See "Notes" for a listing of the available properties. false

Sample Usage

=FLEX("YOUR_TEAM_NAME/web-extract-link", "https://www.flex.io", "Contact Us")
=FLEX("YOUR_TEAM_NAME/web-extract-link", "https://news.ycombinator.com/news?p=1,https://news.ycombinator.com/news?p=2,https://news.ycombinator.com/news?p=3","Show HN")

Notes

The following properties are allowed:

  • domain: the domain of the link for the matched item
  • link: the link of the matched item
  • text: the text of the matched item

Newspaper

Returns content information from a web page article

Syntax

=FLEX("YOUR_TEAM_NAME/web-newspaper", url, [properties])

Parameters

Property Type Description Required
url string Url for the article for which to get the info true
properties array The properties to return (defaults to all properties). See "Notes" for a listing of the available properties. false

Sample Usage

=FLEX("YOUR_TEAM_NAME/web-newspaper", "https://www.flex.io")
=FLEX("YOUR_TEAM_NAME/web-newspaper", "https://www.flex.io", "text")
=FLEX("YOUR_TEAM_NAME/web-newspaper", "https://www.flex.io", "title, top_image")

Notes

The following properties are allowed:

  • title: the main title of the page article
  • authors: the authors of the page article
  • publish_date: the publish date of the page article
  • text: the text of the page article
  • top_image: the top image url for the page article
  • images: a comma-delimited list of image urls for the page article
  • movies: a comma-delimited list of movie urls for the page article

Use Web in your spreadsheet now!