1 Reply Latest reply on May 24, 2015 3:28 PM by Michael Witherell

    Import CSV as text and alternate colors

    Matt Schuurman

      Help!

       

      I've got a very long list of names in a CSV file. Each full name (first and last) is a new field. I'd like to import them in to InDesign as a big block of text (so that it reads: Name One Name Two Name Three Name Four). Also, when I import the CSV, I'd like the font color to alternate for each name. For example:

       

      Name One Name Two Name Three Name Four

       

      How do I do it?

       

      Thanks in advance.

        • 1. Re: Import CSV as text and alternate colors
          Michael Witherell Adobe Community Professional

          You might ...

           

          Open the CSV in Word. Save as a Word doc. Do a Search and Replace to strip out any commas so that you only have spacebar spaces. Place in InDesign. Apply a paragraph style to the placed text. Define a Nested Style within the paragraph style that applies COLOR1 (a character style) thru 2 words, then another nested style to apply COLOR2 (another character style) thru 2 words, and set the two to repeat.