Skip to content
TextArray1.41.0
100% local

Fixed-width column splitter

Split lines with fixed-width fields into columns using widths or cut positions.

Input
Output
Related tools
Extract columnText manipulation
Change CSV delimiterDeveloper tools
Split textText manipulation
Subtitle overlap fixerText manipulation
Truncate at wordText manipulation
Sort wordsText manipulation
Fixed-width column splitter
Paste text where every line packs its fields into fixed character widths — bank statements, mainframe exports, legacy flat files, EDI records — and this tool cuts each line into columns and writes them out with the delimiter of your choice. Set the widths directly (10,8,12) or, if you know where the fields end instead, switch to cut positions (10,18,30) and the tool works out the widths for you.
Turn on trim cell whitespace to strip the padding spaces those formats use to keep every field a fixed size, so "NYC       " comes out as "NYC". If the first line of your file is a column header rather than data, mark first line is a header so it isn't flagged by the length check. Pick the output delimiter — comma, semicolon, tab or pipe — to match whatever you're pasting the result into next, whether that's a spreadsheet or a CSV-only script.
Not every export is clean. Reverse: delimited text to fixed width runs the conversion the other way, padding each delimited field back out to its column width so you can rebuild a fixed-width record from a CSV — useful when a downstream system still expects the old layout. Turn on warn about lines with a different length and the live tally flags rows whose length doesn't add up to the total of your column widths, which is usually a sign of a corrupted row, a wrapped line, or the wrong widths.
Everything runs locally in your browser: nothing you paste is uploaded anywhere, so it's safe to use with account numbers, statements or other sensitive flat-file data. Copy the result, download it as a .txt file, or send the output straight back into the input to run it through another tool.
FAQ
What is the difference between widths and cut positions?
Widths are how many characters each column takes (10,8,12). Positions are where each column ends, counted from the start of the line (10,18,30) — the tool converts them to widths for you, so both describe the same layout.
What happens to characters after the last width?
Anything left over past the last column becomes one extra trailing column, so no data at the end of a line is silently dropped.
Can I convert CSV back to a fixed-width file?
Yes. Turn on reverse: delimited text to fixed width and each field is padded with spaces up to its column width, rebuilding the original fixed-width layout.
How does the tool detect bad rows?
With warn about lines with a different length on, the tally counts rows whose total length does not match the sum of your column widths — a quick way to spot truncated or malformed lines in a large file.
Is my file uploaded anywhere?
No. Splitting and rebuilding fixed-width lines runs entirely in your browser — your file never leaves your device.