plotiq

CSV Data Extractor

Lab reports, dashboard exports, and instrument dumps stuff metadata and measurement arrays into the same CSV. This tool detects the array rows, transposes them into proper columns, rounds the numbers, and emits a chart-ready table.

Ideal for permeability tests, sensor logs, and analytics dumps that mix key-value rows with long numeric arrays.

1. Paste or upload a vertical-metric CSV

Drop a file or paste raw text. Works on lab exports, LinkedIn analytics dumps, Grafana CSVs, or any mix of metadata + numeric arrays.

2. Check the columns you want

Every array row the extractor finds shows up as a checkbox chip. Tick only the ones you need — the output rebuilds instantly.

3. Dial in precision + download

Round every number to 0–10 decimal places, pad or truncate short arrays, then copy or save the chart-ready CSV.

What kind of CSV is this extractor designed for?

Vertical / metric-dump CSVs where each row is `label,value(s)` and some rows contain long numeric arrays (sensor readings, flow rates, pressure curves). The extractor detects those array rows and transposes them into a proper chart-ready table.

How does the extractor decide which rows become columns?

Any row whose first cell is a non-numeric label and whose remaining cells contain at least N numeric values (configurable — default 3) becomes a column. Key-value metadata rows (one value) are preserved as comment lines in the header.

Can I control decimal precision?

Yes. The Precision dropdown lets you round every extracted value to 0, 1, 2, 3, 4, 5, 6, 8, or 10 decimals, or keep the original full precision untouched.

What happens when the detected columns have different lengths?

Two options: "Pad" fills missing cells with blanks (default — charting libraries skip blanks cleanly), or "Truncate" clips every column to the shortest selected one so the output is fully rectangular.

Is my CSV uploaded to a server?

No. Parsing, extraction, and CSV emission all run inside your browser — the file never leaves your device.

Can I feed the extracted CSV straight into the chart tools?

Yes. The output is a standard rectangular CSV with a header row — drop it into CSV → Line Chart, Bar Chart, or Scatter Plot and pick your axes.