Use case · Scraping

Scrape a web table to Excel in one click

Need a leaderboard, a product list, an order table or a report grid in a spreadsheet? Click one row with EasyAgent’s Extract Table and it finds the rest, however many there are, and gives you a CSV.

FREE · NO CODE · WORKS ON PAGES YOU’RE SIGNED IN TO

Not just <table> tags. Most modern sites draw their tables and lists from plain divs. EasyAgent climbs from the row you click to find the repeating pattern itself, so card grids and list views work too.

Walkthrough

From web page to spreadsheet

Four steps

  1. 1

    Open the page and start recording. Do anything needed to get the table showing: pick a date range, apply a filter, open a tab.

  2. 2

    Click Extract Table, then click one row. Any cell in it will do. Nothing on the page is clicked for real.

  3. 3

    Stop recording and replay. On replay EasyAgent captures every row that matches, however many there are that day.

  4. 4

    Download or copy the CSV. Each table gets its own card with the row and column count and a Download button. Open it in Excel or Google Sheets.

Pick the right tool

Three ways to pull data off a page

Extract Table→Every row of a table, list or grid, each cell as a column
Extract→One value, like a total, a status or a confirmation number
Fetch URL→A number from the API endpoint the page itself calls, with an optional JSON path such as data.count
A URL column + Extract→One value from each of many pages: put the page links in a sheet and every row’s value lands in your results sheet
Keep it fresh

Run the same export on a timer

Hourly, daily, or your own interval

The Schedule tab runs a saved macro every 15 minutes up to every 24 hours, or a custom number of minutes.

A log that builds itself

Each run’s captured rows are added to one CSV in your Downloads folder, with the date and time of the run.

Pages behind a login

It runs in your own browser, so it can read pages you’re signed in to, like admin reports or dashboards.

Options

Ways to get a web table into Excel

 EasyAgentCopy and pasteExcel “From Web”Scraper script
Tables drawn with divsYesOften messyOnly real <table>sYes
Pages behind a loginYes, your sessionYesUsually notHard
Filters and clicks firstYes, recordedBy handNoIf you code it
Repeats on a timerYes, Schedule tabNoRefresh by handWith a server
SetupClick one rowNoneA few clicksA developer

Good to know: Extract Table reads the rows the page shows. For results split over several pages, record the Next click and an Extract Table step for each page you need, or set the site to show more rows per page first.

FAQ

Common questions

How do I scrape a table from a website into Excel?
Install EasyAgent, start a recording, click Extract Table, then click any row of the table. Stop recording and replay, then download the CSV and open it in Excel.
Does it work if the table isn’t a real HTML table?
Yes. EasyAgent looks for the repeating row pattern from the row you click, whether that’s a table row, a list item or a repeating card built from divs.
Will it get new rows that weren’t there when I recorded?
Yes. Replay captures every row that matches the pattern at that moment, not just the number there were when you recorded.
Can it scrape a page I have to log in to?
Yes. It runs in your own browser with your own session, so if you can see the page, it can read it.
Can I scrape the same table every day?
Yes. Save the macro and pick it on the Schedule tab. Each run adds its rows to one CSV log in your Downloads folder. Chrome needs to be running for it to fire.
Is the data sent anywhere?
No. Everything stays in your browser and your Downloads folder. EasyAgent has no server.

Click one row. Get the whole table.

Free for Chrome and Firefox. Nothing leaves your computer.