Guides: web data to Excel, CSV and Sheets

How to copy a table from a website into Excel

Three ways to get an HTML table from a webpage into Excel: copy and paste, Power Query "From Web", or a one-click export with real numbers and headers.

How to export search results from a website to Excel

Turn a site's search results into a spreadsheet: one row per result, named columns, every page of results, and no duplicates.

How to import a table from a website into Google Sheets

Get a webpage's table into Google Sheets with IMPORTHTML, with copy and paste, or with a clean export that keeps numbers and headers right.

How to turn a list on a webpage into a CSV file

Save search results, directories and product cards from a webpage as a CSV file that opens cleanly in Excel, with the right separator and characters.

How to export product listings with prices to Excel

Get product names, prices, list prices, discounts, ratings and review counts from a shop page into Excel as real numbers you can sort and compare.

How to save job listings to a spreadsheet

Put job titles, companies, locations, salaries and posting dates from a job board into Excel or Google Sheets, and see new jobs as they appear.

How to export property listings to Excel

Get rents or prices, bedrooms, bathrooms, area and addresses from a property site into Excel as numbers, to compare price per square foot.

How to collect data from several pages into one spreadsheet

Combine page 1, 2, 3… of a list into one Excel sheet: follow Next links, page numbers and "Load more" buttons automatically, at a polite pace.

How to export a page that loads more as you scroll

Infinite feeds and lazy-loading lists only hold what you have scrolled past. Collect every item into Excel automatically, even from virtualized lists.

Why numbers copied from a website are stored as text in Excel

Numbers pasted from webpages often refuse to add up. The usual causes (hidden spaces, symbols, separators) and how to fix them in Excel.