7 Replies Latest reply on Jun 8, 2016 1:54 AM by Laubender

    Data Merge in InDesign with Hebrew Characters

    RuthK Level 1

      InDesign CC 2014 on Windows 7 Ultimate

       

      I had an Excel file which contains mostly English but has a few Hebrew words here and there. I was unable to save this as a CSV retaining the Hebrew from Excel, so I uploaded it to Google Sheets and downloaded it as CSV.

      When I open this CSV file in notepad it looks perfect with the Hebrew, although if opened in Excel the characters are mangled.

       

      When used for Data Merge in InDesign, the Hebrew characters display as the mangled versions as viewed in Excel.

       

      I am using GREP to format the Hebrew characters.

       

      I have a feeling the problem is at the "save CSV" stage but I don't know how to rectify this.

       

      Any help much appreciated.

       

      Thanks

      Ruth