InDesign combines all csv separated columns as one field in data merge

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?

Answer

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 😉

Attribution
Source : Link , Question Author : Emma , Answer Author : Loic

Leave a Comment