Copy link to clipboard
Copied
Hi, I'm trying to do a data merge with Hebrew Text. When saving the excel sheet to csv, the text becomes ???????? , and when coding it for Hebrew, indesign doesn't read the document, and gives me the error message that it is not a supported document, even though it is a .csv. I cannot insert more than 1,000 names manually!!!! Help! How can I do a data merge in Hebrew? I have the English version of indesign, which supports Hebrew. Right to left text isn't a problem etc. But DATA MERGE is importand and urgent. Anyone can help?
Try using UTF-16 BE encoding, Data Merge works fine with this. See a similar discussion here, albeit for the Swedish language.
-Manan
Just tried in my International English version of Adobe InDesign 15.1.3 and was able to data merge a CSV containing hebrew text. Key was that the CSV had to be UTF-16 but windows or unix encoding was fine. Way I did this was to make the data UTF-16 using TextWrangler for mac, and then during the data merge import, make sure the "Show Import Options" checkbox is checked and to confirm the options in the next dialog box like so:
Admittedly I'm an English speaker only and the text I'm looking at
...Copy link to clipboard
Copied
How are you saving the Excel worksheet as CSV?
Make sure you use the CSV (UTF-8) option as opposed to the other CSV save options. This is the only way you can save Hebrew with Unicode encoding required for InDesign.
Copy link to clipboard
Copied
That is what I am doing. Here's the error message I am receiving when trying to import the .csv to data merge:
"The data source file you selected either has no records or is not a supported file format. Please fix the file, select a file that contains records, or select a supported file type.
Copy link to clipboard
Copied
OK. That “solution” resolves problems with placing Hebrew in Excel via CSV. But apparently, data merge may be handling CSV differently. You may have stumbled upon a bug. Contact Adobe Customer Support via phone https://helpx.adobe.com/contact/phone.html or submit a bug report at https://indesign.uservoice.com/.
Copy link to clipboard
Copied
Try using UTF-16 BE encoding, Data Merge works fine with this. See a similar discussion here, albeit for the Swedish language.
-Manan
Copy link to clipboard
Copied
This fixed it for me. Thanks for the recommendation!
Copy link to clipboard
Copied
Hi,
Do you read Hebrew?
I wrote a Tip on my site rgarding Data Merge from various apps after I investigate it for many hours...
Here is the link:
http://indesignme.co.il/tips/094-data-merge-indesign/
The tip exlains what is Data Merge and the correct saving options from various applications in mac and windows.
I hope it will help you.
Please let me know 🙂
Shlomit
Copy link to clipboard
Copied
Just tried in my International English version of Adobe InDesign 15.1.3 and was able to data merge a CSV containing hebrew text. Key was that the CSV had to be UTF-16 but windows or unix encoding was fine. Way I did this was to make the data UTF-16 using TextWrangler for mac, and then during the data merge import, make sure the "Show Import Options" checkbox is checked and to confirm the options in the next dialog box like so:
Admittedly I'm an English speaker only and the text I'm looking at may make no sense in Hebrew, but it is at least worth attempting this technique.
Copy link to clipboard
Copied
at least you figure it out 🙂
Copy link to clipboard
Copied
Thanks for trying to help. Will have to try text wrangler. Shlomit, I can read Hebrew, but I don't understand it, so although your tips look quite helpful, I couldn't really figure it out. Know of anything like that in English?
Copy link to clipboard
Copied
Thanks all! Saving as UTF-16 txt worked!!!!