Fixed width (also known as fixed column width or space delimited) and CSV are both widely used formats for storing and exchanging data. You can easily convert fixed width files to CSV 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 CSV output:
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
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 52 transforms (such as merge, filter and dedupe) to quickly and easily create complex data transformations. See our quick start guide for more details.
v1.18.0 for Windows 10 / 8 / 7 (36 MB)
v1.18.0 for Mac 11.x to 10.13 (36 MB)
Questions or problems?