How to automatically create a CSV file

For me, writing the mapping between these files is difficult. I have the source files from the equipment manufacturer, but the resulting CSV file always has problems.