: Datamerge - Excel to Indesign I have a problem with a data merge. On several tutorials if they selected the CSV file, all the data loads up separately but when I select the CSV file, all

I have a problem with a data merge. On several tutorials if they selected the CSV file, all the data loads up separately but when I select the CSV file, all data loads like this:

So I can't load them up separately. What I'm doing wrong?

My steps:

make excel file with all my data
save this file
save the CSV file
open InDesign document
select data source
then I see this...

10.01% popularity Vote Up Vote Down

: Why can't I use keyboard shortcuts with Illustrator? I am unable to use simple key shortcuts while using my wacom pen. For example, when I try to make an image larger by dragging one of its

@Gretchen549

Posted in: #AdobeIllustrator #Shortcuts #Wacom

0 Comments

: Create flair around fonts without pen tablet? Without using a pen tablet, what’s a good alternative way in Photoshop or Illustrator to create variable width flair around fonts like a lettering

@Gretchen549

Posted in: #AdobeIllustrator #AdobePhotoshop #Lettering

1 Comments

: Standard sizes for testing logo readability A logo I made in Illustrator does not distort when you change size, but it is desirable to check whether the details remain readable in all various

@Gretchen549

Posted in: #Logo #Readability #Vector

2 Comments

: Is there alternate open source font for Chevin Light and Chevin Bold? I am working on XSLT and I have to find an open source Font which might be similar to Chevin Light as well as for Chevin

@Gretchen549

Posted in: #FontLicensing #FontRecommendation #OpenSource

2 Comments

Login to post a comment!

1 Comments

Sorted by latest first Latest Oldest Best

@Twilah924

This is very typical.

Indesign expects your CSV fields to be comma separated.
BUT... depending on your regional settings, Excel might export CSV with a semicolon as separator. Errr... we are not (yet) all americans. This seems to be your case... not american right? ^^

Sooo... two solutions:

Export Excel file as .txt file, tab separated. It works like a charm, this is what I would do.
You really want to use CSV. (If you're a Mac user... I don't know). If you're a Windows user: open Control Panel > Regional Settings, Advanced parameters: change list separator to comma.

Hope that helps

10% popularity Vote Up Vote Down

Feed

: Datamerge - Excel to Indesign I have a problem with a data merge. On several tutorials if they selected the CSV file, all the data loads up separately but when I select the CSV file, all

More posts by @Gretchen549

: Why can't I use keyboard shortcuts with Illustrator? I am unable to use simple key shortcuts while using my wacom pen. For example, when I try to make an image larger by dragging one of its

: Create flair around fonts without pen tablet? Without using a pen tablet, what’s a good alternative way in Photoshop or Illustrator to create variable width flair around fonts like a lettering

: Standard sizes for testing logo readability A logo I made in Illustrator does not distort when you change size, but it is desirable to check whether the details remain readable in all various

: Is there alternate open source font for Chevin Light and Chevin Bold? I am working on XSLT and I have to find an open source Font which might be similar to Chevin Light as well as for Chevin

Login to post a comment!

1 Comments

Back to top | Use Dark Theme