FormulaCraft

IMPORTHTML

IMPORTHTML fetches HTML content from a specified URL and extracts either a table or an ordered/unordered list by its index on the page. It is ideal for pulling publicly accessible tabular data — such as Wikipedia tables, sports standings, or financial data — directly into your spreadsheet without manual copying.

Excel
=IMPORTHTML("https://en.wikipedia.org/wiki/List_of_countries_by_population_(United_Nations)","table",1)
Google Sheets
=IMPORTHTML("https://en.wikipedia.org/wiki/List_of_countries_by_population_(United_Nations)","table",1)

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Runs server-side · free · no signup

How it works

  1. 1Enter the full URL of the webpage containing the table or list you want to import.
  2. 2Specify the query type as "table" or "list" (must match the HTML element type).
  3. 3Provide the index number (starting at 1) of the specific table or list on that page to import.

Need a version for your data?

Try: “Import a Wikipedia table into my Google Sheet automatically”

Related

IMPORTRANGEIMPORTDATAIMPORTXML

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: