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:
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:
Use Filter and Remove Cols transforms before output if you want to remove any of the rows or columns.
If you have 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 50 transforms (such as merge, filter and dedupe) to quickly and easily create complex data transformations. See our quick start guide for more details.
v1.14.0 for Windows 10 / 8 / 7 (30 MB)
v1.14.0 for Mac 11.x to 10.13 (31 MB)
Questions or problems?
Do you have a question?
We would love to help.
This pop-up will not be shown again