← All text tools

Fixed width file to CSV converter

Convert fixed width text into CSV by choosing the column start positions on a character ruler or detecting them from the spaces, and trim the padding in each field.

  • Free
  • No sign-up
  • Works on any device

About Fixed width file to CSV converter

Fixed width files, common in mainframe exports, bank statements and government data, line up each field at set character positions with no delimiter. To convert one, show where each column starts. Paste the text, and either let the page detect the columns from character positions that are blank on every line, or click characters on the ruler to add and remove breaks, or type the positions yourself. The output is standard CSV with quotes added when a field contains the separator, and options to trim padding spaces, skip empty lines and use a semicolon or tab.

How to use Fixed width file to CSV converter

  1. Paste the fixed width text into the box.
  2. Press the detect button, or click the ruler to place the column breaks; edit the positions by hand if needed.
  3. Copy or download the CSV once the preview columns look right.

Why use this tool?

Also known as

Frequently asked questions

How do I find where each column starts?

Count characters from the left, starting at 1. Spaces are characters too, so the first character of each header word usually marks the start of a column.

Why did automatic detection merge two columns?

Detection needs a character position that is empty on every line. If values touch or a space inside text aligns on all lines, place that break yourself on the ruler.

Does the first column need a break?

No. The first column always begins at position 1, so list only where the second and later columns begin.

Is Fixed width file to CSV converter free?

Yes. Fixed width file to CSV converter on Toolipedia is free to use, with no sign-up and no watermark.

Is it safe to use?

Yes. Everything is worked out in your browser, and nothing you enter is sent to our server.

Does it work on my phone?

Yes. It works in any modern browser on Android and iPhone, as well as on tablets and computers. There's nothing to install.

Do I need an account?

No. Just open the page and use the tool. There's no sign-up and no email needed.

Can I put Fixed width file to CSV converter on my own website?

Yes. Use the Embed on your site button under the tool to copy a short piece of code and paste it into your page. It is free, needs no account, and the tool keeps working inside your page.

Related tools