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