I am trying to import an Excel CSV into InDesign Data Merge. Everytime I try to export the csv, it appears in Data Merge as only one field, with fields separated by semicolons, although in Excel I have multiple, comma separated fields.
I’ve done this plenty of times and have never experienced this problem. I have checked the language and regional settings on my laptop and these are set as comma separated. I’ve tried to use a txt file version, but Indesign won’t accept it. I am now very much stuck! any suggestions?
Your problem is that Excel uses semi-colon separators when InDesign looks for comas.
Prefer tabbed text format on export and everything will be fine 😉