How to convert fixed width to Excel

Fixed width (also known as fixed column width or space delimited) and Excel are both widely used formats for storing and exchanging data. You can easily convert fixed width files to Excel .xlsx or .xls format with Easy Data Transform:

import fixed width data

Auto run on

edit the fixed column widths

fixed width to Excel

convert fixed width to Excel

fixed width to Excel converter

Example fixed width input:

ID    Name         Payment   Country  Date
8904  Black, John  12345.67  GB       08/20/2020
3999  Brown, Jane  23456.78  US       08/20/2020
7489  Green, Zadie 34567.89  DE       08/20/2020

Example Excel output:

fixed width to Excel

Use Filter and Remove Cols transforms before output if you want to remove any of the rows or columns.

If you have a large number of files to convert you can do it using batch processing.

As well as changing file format, Easy Data Transform also allows you to combine 66 transforms (such as join, stack, filter and dedupe) to quickly and easily create complex data transformations.

fixed width to Excel

Try it free now!

Windows Logo Windows Download

v1.46.5 for Windows 11 / 10 / 8 / 7 (47 MB)
Zip file version

Apple Logo Mac Download

v1.46.5 for Mac 14.x to 10.13 (79 MB)

No commitments.
You can uninstall any time.
You don't even have to give us your email address.

Questions or problems?