: Why does Indesign combine my csv columns into a single entry, when data merging? I'm data merging a csv file into a indesign file to export buisness cards. However when I select the csv for

I'm data merging a csv file into a indesign file to export buisness cards. However when I select the csv for data merging, Indesign reads the file and should display the columns in the file as seperat entries, but instead it combines them into one:

The data should show up as individual entries for

Name
Rolle
Telefon
Email

Alas, not combined like in the screenshot.

The csv file is set up like this:

for obvious reasons I can't show the data, but there is 25 rows of data below, set up the same way as the sample data here.

Some data-fields contain the danish special-characters æ, ø and å (if that could play a role?).

10.02% popularity Vote Up Vote Down

: Removing an element from text in Illustrator I want to remove the dot above the "i" in Illustrator but still keeping the text as an editable vector object, is this possible?

@Berryessa866

Posted in: #AdobeIllustrator #Text

1 Comments

: As far as I know you can't change the default behaviour of the brush size scrubber. What you can do is use your keyboard up/down keys to change the size in single increments and shift+up/down

@Berryessa866

0 Comments

: Regular panoramic photo to iPhone panoramic How I can change the format or the register of a panoramic photo made in Photoshop to a iPhone panoramic photo, this is because the new feature of

@Berryessa866

Posted in: #AdobePhotoshop #Panorama #Photography

1 Comments

: 5 to 10 color printing I've done very little print work before and now that I'm in need of some product labels, I've come across 5-10 color printing. The local shops haven't been very helpful.

@Berryessa866

Posted in: #PrintDesign

1 Comments

Login to post a comment!

2 Comments

Sorted by latest first Latest Oldest Best

@Miguel516

CSV is comma-separated values. On some windows machines (when win is not English) the comma is changed with semi-colon. And in the result csv files are exported with ";" in place of ",".
You can change it in windows regional settings or just save file as Tabbed Text.

10% popularity Vote Up Vote Down

@Shelley591

No it's because InDesign looks for commas as a separator while Excel will use a semi-colon. Prefer Tabbed Text as export format. InDesign will like this better ;)

10% popularity Vote Up Vote Down

Feed

: Why does Indesign combine my csv columns into a single entry, when data merging? I'm data merging a csv file into a indesign file to export buisness cards. However when I select the csv for

More posts by @Berryessa866

: Removing an element from text in Illustrator I want to remove the dot above the "i" in Illustrator but still keeping the text as an editable vector object, is this possible?

: As far as I know you can't change the default behaviour of the brush size scrubber. What you can do is use your keyboard up/down keys to change the size in single increments and shift+up/down

: Regular panoramic photo to iPhone panoramic How I can change the format or the register of a panoramic photo made in Photoshop to a iPhone panoramic photo, this is because the new feature of

: 5 to 10 color printing I've done very little print work before and now that I'm in need of some product labels, I've come across 5-10 color printing. The local shops haven't been very helpful.

Login to post a comment!

2 Comments

Back to top | Use Dark Theme