Skip to main content
C
caseyh12837339
Participant
July 13, 2017
Answered

InDesign data merge, missing data fields

  • July 13, 2017
  • 1 reply
  • 7577 views

I'm trying to do a data merge, I've selected my Data Source (a .csv file), but not all of the data fields (column headers) are showing up in the data merge box. Any ideas what I could be doing wrong?

    Correct answer MW Design

    Likely one of the missing fields have returns in them, or another disallowed character. If you open your merge file in a text editor, is it all there?

    1 reply

    S
    SJRiegel
    Legend
    July 13, 2017

    A screen shot of your data merge box, and some information about what is missing would be helpful in helping you.

    Sometimes csv files from some regional versions of excel use semicolons instead of commas. If all of your headers seem to be together in the first field name, try saving your file as tab-delimited text instead of csv.

    C
    caseyh12837339Author
    Participant
    July 13, 2017

    I had the same problem with the tab-delimited text file. Here are all of the data fields that show up, but I have a total of 34 data fields.

    MW Design
    MW DesignCorrect answer
    Inspiring
    July 13, 2017

    Likely one of the missing fields have returns in them, or another disallowed character. If you open your merge file in a text editor, is it all there?

      Terms & ConditionsAccessibility statement
      Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices