How to extract data from a website into Excel, without code
It depends on how the page shows its data. A real table on a public page: Excel's Data › From Web can read it. Anything else, such as product cards, search results, lists that load as you scroll or pages behind your login: open the page in Chrome and export it with NeatCells, which reads what you see and gives one row per item.
First, look at the page
- A table: rows and columns under a header row, such as rankings, sports standings or the tables in a Wikipedia article.
- Repeated items: search results, products, jobs or property listings, where each item is a small block with a title, a price, a rating and a link.
- More than one page: numbered pages, a Next link, a "Load more" button, or items that keep appearing as you scroll.
- Behind a login: data you see only when you are signed in.
Match the method to the page
| The page shows | Use | Guide |
|---|---|---|
| A table on a public page | Excel's From Web, or NeatCells | Table to Excel |
| A table you want in Google Sheets | IMPORTHTML, or copy with NeatCells | Table to Google Sheets |
| Search results, products, listings | NeatCells | Search results to Excel |
| Several pages of results | NeatCells, Collect next pages | Several pages, one sheet |
| Items that load as you scroll | NeatCells, Scroll to load more | Pages that load as you scroll |
| A page behind your login | NeatCells, which reads your own browser | The steps below |
Excel's From Web and Google Sheets' IMPORTHTML fetch the page themselves, without your login and usually without running the page's scripts. Many modern pages build their lists with scripts after they load, so those tools see an empty page. A browser extension reads the page after it has loaded, exactly as you see it.
Step by step with NeatCells
- Add NeatCells to Chrome. It is free and needs no account.
- Open the page with the data. Set the site's own filters and sorting first.
- Click the NeatCells icon, or press Alt+Shift+E. The side panel shows what it found as a table, with named columns such as Title, Price, Rating and URL.
- Not the list you wanted? Click Select on the page, then one item: every item like it is found.
- Remove the columns you don't need (×), rename others by clicking their names, and click Remove duplicate rows if the page repeats items.
- For more than one page, click Collect next pages (up to 5 pages for free) or Scroll to load more.
- Click Download Excel, CSV, or Copy to paste into Google Sheets.
The Excel file has a bold, frozen header row with filters, numbers and dates as real values, and clickable links.
Why not just copy and paste?
Copying works for a small, simple table. On a page of cards it gives one long column of text, and numbers arrive as text: "₹1,23,456", "4.6 out of 5 stars" or "(1,284)" will not add up until you clean them. Our guide on numbers stored as text shows the fixes.
Is it allowed?
Reading a page you can see in your own browser is like copying it by hand. Some websites' terms limit automated collection, and data about people is protected by privacy laws, so collect only what you need. NeatCells waits between pages and stops at any CAPTCHA or sign-in page.
Questions
Do I need to know how to code?
No. Excel's From Web and NeatCells are point and click. Writing a scraper in a programming language is worth it only for large jobs that repeat across many sites.
Can Excel update the data on a schedule?
A From Web table refreshes with Data › Refresh All, and its query properties can refresh it every few minutes or when the file opens. In NeatCells, save a recipe; with NeatCells Pro, a watched recipe checks the page on a schedule while Chrome is open and marks new and changed rows.
Does this work on a Mac?
Yes. NeatCells runs in Chrome on Windows, Mac, Linux and ChromeOS, and saves standard .xlsx and CSV files.