Every table on the page, in CSV and JSON.
Copying a table from a site into a spreadsheet almost never works: the columns scramble and the formatting tags along. Paste the address and take the data clean, ready to open.
- Module
- Collection
- Input
- A URL
- Runs on
- Rovemark server
- Cost
- Free, no signup
Data that sits on a page, but not in a spreadsheet
Prices, rates, rankings, technical specs: a lot of what you need in a spreadsheet lives in a table on a web page, with no download button. Selecting with the mouse and pasting usually brings the columns out of order, the header in the wrong place and a pile of formatting along for the ride.
The tool reads the HTML, finds each table, separates headers from content, aligns rows with different cell counts, and returns everything in CSV and JSON. A field with commas or quotes is escaped correctly, without that, the spreadsheet opens with columns scrambled.
- 01
Paste the page address
One page, no signup. If there is more than one table, you choose which to view.
- 02
Each table is read and aligned
The header the site declares is respected; a row with a missing cell is padded so the spreadsheet does not drift.
- 03
Download as CSV or JSON
CSV opens straight in Excel, Sheets or Numbers. JSON comes out as a list of objects, with the column name on every field.
- 01
Why does copying and pasting a table almost never work?
- Because browser selection carries visual formatting with it, and the spreadsheet tries to interpret it as structure. Merged cells, two-line headers, and empty columns become misalignment, and the error only appears later, in the middle of the analysis.
- 02
Does it work with tables built by JavaScript?
- Only if it exists in the served HTML. A table built later in the browser is not seen, the tool reads the page as a crawler does, without running scripts. When it finds none, it says so.
- 03
What if the page has several tables?
- All of them are extracted, up to twenty-five, and you move between them. Tables used purely for layout are discarded, and a table nested inside another is preferred over the outer one, which is usually just the wrapper.
- 04
Does the CSV open correctly in Excel?
- It does. The file is exported in UTF-8, with quotes around fields that contain commas, quotes, or line breaks, and doubled internal quotes, as the format requires. If your Excel is set to a region that uses semicolons, use data import and select commas as the separator.
- 05
Is there a size limit?
- The screen shows the first sixty rows so the browser does not choke, but the downloaded file carries the whole table. Per page, up to twenty-five tables are extracted.
- 06
Can I repeat this daily, across many pages?
- Not here, this is the one-page, on-demand version. Monitoring a list of pages, keeping history, and receiving the result through API is what the Collection module does, with the same extraction engine.
One page today. And tomorrow, again?
Extracting once is easy. Extracting every day, from dozens of pages, keeping what changed, is the Collection module, the same engine, with scheduling and API.