Structured Data Extraction

Structured data already has a shape โ€” rows, fields, records โ€” and the job is almost always the same: get one part of it out cleanly, in a format the next tool can read. These tools take a CSV, a JSON file, an Excel sheet or an HTML table and give you back exactly the columns, fields or rows you asked for, as CSV, without uploading anything.

Which tool do you need?

If you…Use
You have a CSV and want only some of its columnsCSV Column Extractor
You want one field from every record in a JSON fileJSON Field Extractor
You have an Excel workbook and want the data as CSVExcel Data Extractor
You have an HTML page with a table in itHTML Table Extractor
You want to extract tables from a Markdown fileMarkdown Table Extractor
You want to extract tables from a SQL dump fileSQL Data Extractor

If your data is trapped in a PDF rather than a data file, start with the PDF table extractor, which detects columns from the page layout and also writes CSV.

Why the output is always CSV

These four formats store the same idea โ€” records with fields โ€” in different shapes. A CSV is rows of plain text, JSON is nested key-value data, an .xlsx is a ZIP of XML sheets, and an HTML table is markup. What they have in common is that the useful part is tabular, and the format everything else can read is CSV: spreadsheets open it, databases import it, and every other tool on this site that takes a table accepts it.

So each tool here converges on the same output. The work is in reading the input correctly โ€” honouring quoted fields in a CSV, walking a nested path in JSON, resolving formulas to values in Excel, handling merged cells in an HTML table โ€” and then writing clean, predictable CSV out the other side.

Every structured data tool

Frequently asked questions

Why does everything export as CSV instead of the original format?

Because CSV is the one format every spreadsheet, database and data tool reads. Converting a JSON field list or an Excel range to CSV makes it usable in the next step, which is almost always the actual goal.

What is the difference between the Excel tool and the CSV tool?

The Excel tool reads a whole .xlsx workbook โ€” multiple sheets, formulas resolved to values โ€” and turns it into CSV. The CSV tool starts from a CSV you already have and pulls specific columns out of it. Excel in, CSV refined.

Is my data uploaded?

No. Every tool here parses the file in your browser. A customer list or an export full of personal data never leaves your device.

Other extraction groups