Convert a text file with one record per line into a structured CSV
Convert plain-text newline-delimited records into structured CSV tables.
🛡️ Your rows never leave your browser.
Why Onfyt: Handles fixed-width text files (not just delimited) by letting you define column start positions and widths—useful for mainframe output.
Interactive Sample Data
| id | name | |
|---|---|---|
| 1 | Grace Kerubo | grace@corp.com |
| 2 | Peter Njoroge | peter@corp.com |
How this tool works
Legacy system exports, log files, and ETL outputs often produce newline-delimited flat files where each line represents one record with fields separated by a non-comma delimiter (pipe, tab, colon, fixed-width spaces). Converting these to proper CSV enables them to be loaded into any spreadsheet or data tool.
DataFix lets you specify the field separator, provide column header names (or auto-generate them), and handles edge cases like fields containing the separator character when properly quoted.
Converting line-delimited text files into structured CSV formats parses unstructured logs, raw barcode scanner feeds, and clipboard text into aligned tabular records with configurable column boundaries.
Transforming raw line-delimited text into structured tabular CSV files allows developers to parse raw barcode scanner outputs, server access logs, and copy-pasted spreadsheet fragments into aligned columns. Configurable delimiter parsing, custom header injection, and quote escape validation ensure that messy unstructured text becomes clean tabular data.
When parsing unstructured text feeds into columns, handling uneven token lengths, trailing line breaks, and multi-line comments prevents ragged table dimensions. DataFix validates column balance across every row, automatically populating missing fields with clean default placeholders.
Parsing raw line-delimited records into structured tabular columns transforms unstructured scanner inputs, log snippets, and copied text into aligned rows. Automatic delimiter parsing and header injection restore tabular order to unstructured text. Empty lines can be ignored or preserved as blank rows based on user preference, maintaining row index alignment with original source log files.
Things that usually go wrong
- Lines containing commas are not automatically quoted — enable 'auto-quote' if values may contain commas.
- Blank lines in the input produce empty rows — enable 'skip blank lines'.
Edge cases we tested
🧪 Lines with different numbers of fields
Ragged rows padded with empty values or flagged as errors.
🧪 Line ending with delimiter ('1|Grace|')
Trailing empty field included as empty string in final column.
Frequently Asked Questions
Can I convert multiple columns of lines at once?
Paste lines for each column, one per column, separated by tabs. The tool detects the tab delimiter and produces multiple columns.
Is the header auto-detected?
No — enter the header name before converting.
Related tools
Transform
Column to Comma-Separated List
Extract a CSV column and convert it to a comma-separated list for SQL IN clauses or code arrays.
Open Tool →
Transform
Comma-Separated List to Column
Convert a comma-separated, line-separated, or SQL IN list into a single-column CSV.
Open Tool →
Transform
CSV to Lines
Convert a CSV to a newline-delimited text file with configurable field separators.
Open Tool →