For a small, simple table, copy it and paste it into Excel. For a table you want to refresh later, use Excel's From Web import. For pages built from cards, grids or search results, or when you just want a clean .xlsx without setup, use a Chrome extension that reads the page you are viewing, such as Pulse Extractor.
Watch it in action.
Turn Webpages Into Usable Data
Extract webpage content and turn it into clean, structured information.
In “Turn Webpages Into Usable Data”: Pulse reads the webpage in front of it, turns the content into a structured result and exports it, for example to Excel, CSV or JSON.
Video previews do not contact YouTube until you press play. When you play a video, YouTube receives the normal information required to deliver the video. Playback uses YouTube's privacy-enhanced mode. All video tutorials
Method 1: Copy and paste
This is the fastest option when the data is a small, ordinary table.
- Select the table on the webpage by dragging from its first cell to its last.
- Copy it with Ctrl+C (Cmd+C on a Mac).
- Click a cell in Excel and paste with Ctrl+V.
- If the website's colours and fonts come along, use Match Destination Formatting from the paste options.
It works well for a few rows in a real HTML table. It gets messy with links, merged cells, product cards and anything that is laid out like a table but is not built as one: values land in a single column or spread across the wrong cells, and you tidy them by hand.
Method 2: Excel's From Web import
Excel for Windows can import tables straight from a URL through Power Query. Whether your copy offers it depends on your Excel version and platform, so check the Data tab first.
- In Excel, open the Data tab and choose From Web.
- Paste the page address and confirm.
- In the Navigator, pick the table you want from the list Excel detected. The preview shows what each one contains.
- Choose Load, or Transform Data to clean columns first.
- Later, Refresh All pulls the latest version of the same table.
The refresh is the real advantage. The weakness is that Excel requests the page itself rather than reading the one in your browser, so pages that build their content with scripts after loading, pages that need you to sign in, and sites that block automated requests often show no tables, or not the table you can see.
Method 3: Google Sheets IMPORTHTML, then download as Excel
Google Sheets has a formula that pulls a table or list from a public page:
=IMPORTHTML("https://example.com/page", "table", 1)
The last number picks which table on the page to import, counting from 1. If you get the wrong one, try 2, 3 and so on. When it looks right, use File, Download, Microsoft Excel (.xlsx).
Google fetches the page from its own servers, not from your browser. It only sees real table and list markup, it cannot use your sign in, and content that a page loads with scripts usually comes back empty or as an error.
Method 4: Extract the page with Pulse Extractor
Pulse is a Chrome extension that reads the page you are viewing and turns it into a structured result you can export as an Excel workbook.
- Add Pulse Extractor to Chrome from the Chrome Web Store and sign in with a free account. No card is required.
- Open the webpage that holds the data and let it finish loading. Content a site has not loaded yet, such as results that only appear after you scroll or press a load more button, is not on the page yet, so bring it onto the page first.
- Click the Pulse icon in the Chrome toolbar and choose Extract Page. If you do not see the icon, pin Pulse from Chrome's extensions menu.
- Review the result. Repeated, comparable items such as rows, product cards, directory entries or search results become rows with their own fields.
- Choose Excel (.xlsx) to download the workbook. The same result also exports as CSV or JSON without extracting again.
Pulse looks for repeated, comparable items rather than for a formal table tag, which is why card grids and listings usually convert as cleanly as real tables. Where a page has no repeated structure, you still get its key fields as one record. The export is a genuine .xlsx workbook with typed cells, not a screenshot or pasted text.
Which method should you use?
| Method | Best for | Setup | Watch out for |
|---|---|---|---|
| Copy and paste | A few rows from a simple table | None | Broken columns on cards, links and merged cells |
| Excel From Web | A public table you want to refresh | A few minutes per page | Pages built by scripts or behind a sign in |
| Google Sheets IMPORTHTML | A public table or list in a shared sheet | One formula | Only real table and list markup; no sign in |
| Pulse Extract Page | Tables, card grids and listings on the page you are viewing | Install once, then one click | One page per extraction; no scheduled refresh |
When Pulse is the right tool, and when it is not
Pulse fits when
- The data is on a page you can see in Chrome, including product grids, supplier lists, directories and search results that are not formal tables.
- You want a clean workbook in seconds, without writing selectors, designing a schema or configuring a query.
- Your pages vary: a supplier list today, a comparison page tomorrow.
Use something else when
- You need the same table refreshed on a schedule. Excel's From Web refresh is built for that.
- You need hundreds or thousands of pages, or a whole site. Look for the site's own export or API first, then a dedicated data collection platform. Pulse works on the page you are actively viewing, when you click. It does not crawl a site, follow pagination on its own or run on a schedule.
- The site already offers a download button or an API. Use it: it is the source's own format.
- You are not authorized to use the data. No tool changes that; see Responsible Use.
Limitations to know
- One page at a time. For paginated results, extract each page, then combine the sheets in Excel.
- Only what the page contains. Pulse structures what it can verify from the page and leaves a field blank rather than inventing a value. Some pages simply do not hold enough structured information.
- Protected browser pages. Chrome does not let extensions run on its own protected pages, such as browser settings or the Chrome Web Store, so Pulse is unavailable there. That is a browser restriction, not a Pulse setting.
- Allowance. The Free plan includes 20 Page Extractions and 10 Professional Exports a month; Starter, Pro and Intelligence make both unlimited.
Questions
Can I extract data from a page I am signed in to?
Extract Page works on the page open in your own browser, so it reads what you can already see there. Whether you may reuse that data depends on the site's terms and the law that applies to you. Research is different: it only uses publicly reachable sources and does not access pages that require signing in.
Is the Excel file a real workbook?
Yes. It is a genuine .xlsx workbook with typed cells that you can sort, filter and write formulas against.
Can I get CSV or JSON instead?
Yes. The same extraction exports as CSV or JSON as well as Excel, so there is nothing to run twice.
Does Pulse keep a copy of the page?
Extract Page is performed by the extension on your device, and Pulse is designed to avoid storing raw page content. The Privacy Policy sets out exactly what is and is not recorded.