Hi Flor1,

welcome to the support forum.

If it’s always the same layout you need to merge data to, you can

• Import both your (prepared) layout and datasource (Excel directly) to MyDataMerge
• Configure MyDataMerge how to merge your data
• Sort your data

The options above will not change your original Excel file but will create a new, InDesign compatibe CSV file – taking care of escapes, linebreaks and so on. If you need to do this regulary you can save a project file and just swap the datasource the next time you get one.

Then MyDataMerge can:

• Create the CSV file for you – for manual usage
• Create the CSV file for you and LINK all placeholders for a data merge – for manual usage
• Do the merge for you

Trying MyDataMerge is FREE, Get your copy here