IMPORTXML

IMPORTXML fetches a URL and extracts matching nodes using an XPath expression, returning the results as a range in the sheet. It works with XML feeds, RSS, sitemaps, and structured HTML, allowing you to pull specific elements like article titles, prices, or metadata without writing custom scripts.

Excel

=IMPORTXML("https://example.com/feed.xml","//title")

Google Sheets

=IMPORTXML("https://example.com/feed.xml","//title")

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

Cell row 1 column 1	Cell row 1 column 2
Cell row 2 column 1	Cell row 2 column 2
Cell row 3 column 1	Cell row 3 column 2
Cell row 4 column 1	Cell row 4 column 2

Formula

Runs server-side · free · no signup

How it works

1Provide the full URL of a publicly accessible XML or HTML document.
2Write an XPath expression that targets the nodes you want (e.g., //item/title for RSS feed titles).
3The function returns each matching node value in a separate row, spilling downward automatically.

Need a version for your data?

Try: “Extract all article titles from an RSS feed URL into my sheet”

IMPORTRANGE IMPORTHTML IMPORTDATA

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

Last reviewed: May 28, 2026

IMPORTXML

Try it with your data

How it works

Related