: 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

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?

10.02% popularity Vote Up Vote Down

: Indesign: how to customize a numbered list I want to change all "autonumbering" of sentences in my document that have about 1000 pages to an objecct e.g. a triangle, that contains the same

@Frith110

Posted in: #AdobeIndesign #HowTo #Numbering

3 Comments

: Match line color I made a drawing, scanned and everything, but the remnants of my sketch (blue) have popped up and the lines of my final drawing are too indefinite. I want a solid black final

@Frith110

Posted in: #AdobePhotoshop #PhotoEditing

3 Comments

: How to mask a layer from a channel in GIMP with Python? I've been 3 days searching for documentation about python-fu for GIMP 2.8, and the one I find is great, but deprecated. So I'm now

@Frith110

Posted in: #Gimp #Layers #Mask #Python

1 Comments

: Corel Draw - Join two nodes to erase a vector line to vinyl cut I'm somewhat new to Corel Draw and I have an image (see below) which I want to cut with a vinyl cutter. It includes the

@Frith110

Posted in: #CorelDraw #Diecut #Dieline

1 Comments

Login to post a comment!

2 Comments

Sorted by latest first Latest Oldest Best

@Voss6371140

Drop your CSV into a text editor and replace all ; with ,. Here's a sample of a CSV i recently used to build a photo grid in InDesign. So make sure you have commas everywhere separating the values, otherwise it doesn't work.
@image ,name,where
1anton.jpg,Anton,NO
1gabriela.jpg,Gabriele,FI
1carla.jpg,Carla,SE

Note: CSV actually stands for Comma-Separated Values, so i really don't see why Excel saves CSV with the ; separator.

10% popularity Vote Up Vote Down

@Odierno310

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 ;)

10% popularity Vote Up Vote Down

Feed

: 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

More posts by @Frith110

: Indesign: how to customize a numbered list I want to change all "autonumbering" of sentences in my document that have about 1000 pages to an objecct e.g. a triangle, that contains the same

: Match line color I made a drawing, scanned and everything, but the remnants of my sketch (blue) have popped up and the lines of my final drawing are too indefinite. I want a solid black final

: How to mask a layer from a channel in GIMP with Python? I've been 3 days searching for documentation about python-fu for GIMP 2.8, and the one I find is great, but deprecated. So I'm now

: Corel Draw - Join two nodes to erase a vector line to vinyl cut I'm somewhat new to Corel Draw and I have an image (see below) which I want to cut with a vinyl cutter. It includes the

Login to post a comment!

2 Comments

Back to top | Use Dark Theme