How to Use IMPORTHTML() in Google Sheets

Description

Imports data from a table or list within an HTML page.

How To Actually Use IMPORTHTML() in Sheets

IMPORTHTML(url, query, index)

Try IMPORTHTML yourself

Use the IMPORTHTML formula to import data from the first table on the webpage 'https://example.com'. Place the result in the range A1:A10.

Your formula

Hints (2)

Locale Separator ,

Official Docs

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas

Transcript-matched member videos for IMPORTHTML(). Click through to watch.

Browse more tutorials

Embed a Headline in a Website from Google Sheets

One of the most requested videos, Ever. How to put data, a number, some ...

Advanced

SUBSTITUTE()

Create Navigation Buttons in Sheets to Other Sheets

Add a button to go to another sheet inside your sheet.

Intermediate

Embed a Number in a Website from a Google Sheet

Ever wanted to display some data from a google sheet on your site? Witho...

Advanced

Hardest Formula: SumIF | Addition Based on Dates / Values

Demystifying the SumIF Formula. Add up your values based on a condition,...

SUMIF() UNIQUE()

Unlock these tutorials

Learn more about the IMPORTHTML() formula:

Generate a IMPORTHTML() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses IMPORTHTML(). 2 free AI generations, no signup. Members get unlimited use.

Generate a IMPORTHTML() formula