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

Official MyDataMerge Team