SnipSheetHow to copy a table from a website into Excel
Simple web tables often paste fine, but dashboards, charts with tables, and pages that block copying are a different story. Here are the options.
Try copy and paste first. If that fails, or the table is in a dashboard or image, click the SnipSheet icon, drag a box around the table and download Excel.
Option 1: Copy and paste
Select the table, copy it, and in Excel use Paste Special > Text to avoid the website's formatting. This works for plain HTML tables.
Option 2: Excel's From Web import
In Excel for Windows, Data > From Web lets you enter a page address and pick a table. It is great for public pages that you update regularly. It can't log in to pages behind a login, and it doesn't see tables drawn by scripts or shown as images.
Option 3: SnipSheet, for everything else
- Open the page and click the SnipSheet icon (or press Alt+Shift+S).
- Drag a box around the table and click Extract table.
- Download Excel, copy to Google Sheets, or save as CSV.
Because SnipSheet reads what is on your screen, it works on dashboards, reports behind a login, and tables shown as images. It only captures the page when you click the icon.
Try SnipSheet free. 20 tables a month, no sign up. It comes with a sample table so you can see how it works in seconds.
Add to Chrome, it's freeQuestions
Why does a pasted web table look messy in Excel?
Excel keeps the website's formatting, links and hidden elements. Paste Special > Text, or a tool that reads only the table, gives a cleaner result.
Can I get a table from a page that requires a login?
Yes. SnipSheet reads what is visible on your screen, so it works on pages you are logged in to.