Skip to main content
L
lsde
Participant
July 6, 2020
Answered

InDesign - Data Merge

  • July 6, 2020
  • 4 replies
  • 2880 views

Hi there, can you advise me if there's an option when data merging into InDesign to control the 'case' of text. Ie chose between Sentance Case, lowercase and so on.

 

thanks

    Correct answer patMorita

    This cannot be achieved during the merge in InDesign directly. Still there are tools to do that like with MyDataMerge for macOS (a tool to make InDesigns data merge a lot more easy and comfortable). 

    You can control case of merged text per placeholder and also based on conditions just with a few clicks.

    Its easy to start with but also complex in depth - ask in their support forum if you need support they answer pretty fast.

    And they have a forever free version with some limitations which should be enough to try it. Check https://mydatamerge.com 

    4 replies

    S
    Samantha24335836kpb0
    Participant
    May 5, 2022

    I ran into this issue as well when trying to merge addresses for envelopes. Even though I had the text formatted in all caps in the .svg file as well as the data fields in my InDesign document, it still was importing as sentence case. I realized that a quick 'Find and Replace' search in Indesign quickly reformatted everything into all caps for me. A quick work around I wanted to share! 

    S
    Samantha24335836kpb0
    Participant
    May 5, 2022

    Sorry, I meant .csv file, not .svg! 

    P
    patMoritaCorrect answer
    Inspiring
    July 6, 2020

    This cannot be achieved during the merge in InDesign directly. Still there are tools to do that like with MyDataMerge for macOS (a tool to make InDesigns data merge a lot more easy and comfortable). 

    You can control case of merged text per placeholder and also based on conditions just with a few clicks.

    Its easy to start with but also complex in depth - ask in their support forum if you need support they answer pretty fast.

    And they have a forever free version with some limitations which should be enough to try it. Check https://mydatamerge.com 

      Barb Binder
      Community Expert
      Barb BinderCommunity Expert
      Community Expert
      July 6, 2020

      One of the keys to a successful data merge is a clean and correct data file. (GIGO—garbage in garbage out) Correct the case in data file prior to merging and you should be good to go. Note that InDesign can change the display of text to All Caps or SmallCaps via a paragraph or character style, but sentence case and lowercase should be defined in the data file.

       

      ~Barb

      ~Barb at Rocky Mountain Training
        M
        Community Expert
        Manan JoshiCommunity Expert
        Community Expert
        July 6, 2020

        If the fields on the document marked for merging are styled as per the need it should work fine after merge, but if you are asking that you would want to control this aspect during the merge, then i suppose it is not possible

         

        -Manan

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