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 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 merge, filter and dedupe) to quickly and easily create complex data transformations.
v1.46.5 for Windows 11 / 10 / 8 / 7 (47 MB)
Zip file version
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?