How to turn a website table into a usable spreadsheet
A web table becomes much easier to sort, compare and share once each record occupies a spreadsheet row. This tool is useful when you need a selected table with a clear source reference and consistent columns.
Start with the right material.
- What you provide
- one selected HTML table on an open page.
- The intended result
- Export visible rows with original headers and a source URL column.
How the workflow works.
Choose the headers before extracting, then keep each value attached to its original row. A comma inside a product name belongs inside a quoted CSV field; it should never create an extra column.
What to check in the result.
Compare the exported row count and several complete records with the page. Check prices, stock counts and source URLs, then import identifiers as text when leading zeros matter.
Import the CSV with a consistent delimiter and inspect text identifiers, dates and amounts before using spreadsheet totals. Keep the original file available while checking any automatic type conversion.
Learn from the worked example.
The downloadable CSV example uses these columns: Item, Price, In stock, Source URL. Compare a complete record with the source before sorting, combining or importing your own output.
The supplied example is illustrative. It is not a recorded run on your data.
Download the example ↓Use it with your own material.
- Open the source you want to work with and activate WebAct on that tab.
- Copy the task from the hero, add any required fields or preferences, and review the proposed actions.
- Compare the first result with your source. Ask for a specific correction or refinement where needed.