How to extract data from a website, step by step
Pick one kind of page. Product pages, job ads or listings of one site. Different kinds need different rules.
List the fields. Name, price, size, date: the columns you want in the sheet.
Get the rules. Send two to five example pages. You get a rule per field, tested on all of them.
Run the script. Free, in Python, JavaScript, PHP, Go, Ruby, Java, C# or Rust. Give it a list of links or a sitemap.
Open it in Excel. The script writes one JSON line per page; a one-line conversion turns that into CSV.
Free ways first
Excel's own web import. Data > From Web reads tables from a page. Good for one page with a real HTML table.
Google Sheets IMPORTXML. Pulls one value with an XPath. Fine for a handful of pages; it slows down and breaks with more.
A browser extension. Point and click for one page at a time. No help when the next page has a slightly different layout.
Why a script beats copy-paste and point-and-click
It runs on every page in one go, it gets the same field from pages whose layout shifts a little, and it says "none" instead of filling a cell with the wrong text.