How to copy a table from a website into Excel
For a quick one-off, select the table, copy it and paste it into Excel with "Keep Text Only". For a table you will refresh, use Excel's Data › From Web. For a table that should arrive clean (numbers as numbers, a proper header row, no icons), open the page and export it with NeatCells.
1. Copy and paste
- Drag across the table from the first cell to the last, then press Ctrl+C.
- In Excel, right-click the first cell and choose Keep Text Only under Paste Options, so the page's fonts, colors and pictures stay behind.
This works for small, simple tables. Expect some clean-up: merged header cells, hidden text such as "sort by" labels, and numbers that arrive as text because of currency symbols, spaces or footnote marks ("1,234[2]"). Our guide on numbers stored as text shows how to fix those.
2. Excel's From Web (Power Query)
Excel for Windows (Microsoft 365 and Excel 2016 or later) can read tables from a web address:
- Open the Data tab and click From Web.
- Paste the page's address and click OK.
- The Navigator lists the tables it found (Table 0, Table 1…). Pick one, check the preview, and click Load.
The table stays linked to the page: Data › Refresh All reads it again. Its limits: Excel fetches the page itself, so it cannot see pages that need your login, and it often misses tables that the page builds with JavaScript after it loads. Lists that are not real tables, such as product cards, rarely show up.
3. Export with NeatCells
- Open the page with the table in Chrome.
- Click the NeatCells icon (or press Alt+Shift+E). The panel shows the table it found, with column names and a type for each column.
- Rename, move or remove columns if you like, then click Download Excel.
Because NeatCells reads the page in your own browser, it sees exactly what you see, including tables built by JavaScript and pages behind your login. The file has a bold, frozen header row with filters, numbers and dates as real values, and clickable links. If the table goes on over several pages, Collect next pages adds them to the same sheet.
Which one to use
| Method | Best for | Watch out for |
|---|---|---|
| Copy and paste | A small table, once | Numbers as text, merged cells, page formatting |
| From Web | A public table you refresh often | No logins, misses tables built by scripts |
| NeatCells | Any table or list you can see, cleaned | Works in Chrome; refresh by saving a recipe |
Questions
Why are the numbers left-aligned with a green triangle?
Excel stored them as text, usually because of a currency symbol, a non-breaking space or a footnote mark. Select them and use "Convert to Number", or export with a tool that types each column.
Can I keep the table up to date?
Excel's From Web table refreshes with Data › Refresh All. In NeatCells, save a recipe: next time you open the page, "Use recipe" rebuilds the same table in one click.
Does this work in Excel for the web?
Copy and paste does. From Web is part of Power Query in Excel for Windows. Files exported by NeatCells are standard .xlsx files, so Excel for the web opens them too.