Skip to main content
Participant
Jul 13, 2017 7:12 PM UTC
Answered

InDesign data merge, missing data fields

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?

    MW Design
    MW DesignCorrect answer
    Inspiring
    Jul 13, 2017 8:10 PM UTC

    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?

    6 replies

    Legend
    Jul 13, 2017 7:46 PM UTC

    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.

    Translate
    Participant
    Jul 13, 2017 7:59 PM UTC

    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.

    Translate
    MW Design
    MW DesignCorrect answer
    Inspiring
    Jul 13, 2017 8:10 PM UTC

    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?

    Translate