Install this add-on for Free from the G Suite Marketplace

Is it free?

For the moment the function is free. Premium plans will be disclosed soon.

When I write =IMPORTFROMWEB() in a cell, it shows the error #NAME?

Your add-on might not be activated.
In Google Sheets, go to Add-ons > Manage add-ons

  • If IMPORTFROMWEB is displayed in the list, check that it has been added to your document by clicking on the 3 dots in the add-on card, then “Use in this document”.
  • If IMPORTFROMWEB is not in the list, go to the menu Add-ons > Get add-ons and search for IMPORTFROMWEB.

If you’re still seeing the #NAME? error, try a clean install:
Go to https://myaccount.google.com/permissions and remove the add-on from the lists.

Then go to the add-on page in the G Suite Marketplace, click Uninstall and reinstall it again.

  • We have noticed that some users could experience this issue with spreadsheets already created.
    Create a new spreadsheet and try to enable the add-on for the new spreadsheet.

If you followed all the steps with no success, please contact us.

Note that this issue is not a failure from the add-on. We are currently in touch with Google to resolve the issue

There is no “Build function” item in the menu?

Check the previous answer.

How can I tell Google Sheets to handle imported data as values?

For the moment, IMPORTFROMWEB() handles imported content as text. Hence you will receive an error if you try to make calculations with some numerical content.
There are two ways to proceed so Google Sheets parses the content as numerical values.

Basic: Keep the raw range returned by IMPORTFROMWEB and use the VALUE() function by referencing imported cells

Let’s say you have imported content from the web in column B. In Column C, for each cell you can set the formula =VALUE(cell_to_reference).

In case you are familiar with ARRAYFORMULA(), use =ARRAYFORMULA(VALUE(B6:B)) only in C6 to achieve the same result

Advanced: Use VALUE() directly into the formula containing the IMPORTFROMWEB() function

The definition of the formula that involves IMPORTFROMWEB should look like

=ARRAYFORMULA(IFERROR(VALUE( your_importfromweb_formula ), your_importfromweb_formula))
  • ARRAYFORMULA applies the transformation to each cell of the array
  • For each cell, we check if the result can be a value. If it cannot, it will return an error
  • In case it returns an error, we return the unmodified result

In many cases the imported data might not be clean enough for Google Sheets to convert it into values.
IMPORTFROMWEB accepts regular expressions to fix that. Check out this article about useful regular expressions you need in your toolbox

How can I uninstall a Google Sheets add-on?

If you are the administrator of a Google Suite domain and have installed the add-on for the whole domain, got to the second part.

Uninstall the add-on installed for individual use

  • In Google Sheets, open the apps manager from the menu Add-ons > Manage add-ons,
  • click on “Uninstall” as described in the screenshot.

Uninstall the add-on for your Google Suite domain

If are the administrator of a premium Google Suite account and have installed the app for your whole domain, you will have to follow the following steps.
Otherwise, the administrator of the domain should be able to do it.

  • From Google.com, display the services from the top right button
  • Select “Admin”
  • From the admin console, select “Apps”
  • From the Apps panel, select “Marketplace Apps”
  • A list should display the add-ons installed for the domain. Click on the add-on you want to uninstall
  • On the top right corner you should see a button with a trash icon. Click on it and confirm removal.

If the