InDesign’s Data Merge feature is great. This is a video I return to, when I need to use it.
There is a catch, though: the data must be in the right format for this to work with Swedish text, which has å, ä and ö.
- Use a spreadsheet app to make a dataset (columns and rows)
- Use column names without spaces, and only lower-case characters. Do not use any “special characters”. So: only between a-z.
- Export it to CSV format
- Open the Terminal app in your Mac
- Change to your directory where the file is by dragging its folder into the Terminal window and hit ENTER. Perhaps you need the command cd followed by a space and then drag the folder. (Tip from commenter Dima. Thanks!)
- Type the following text command and press ENTER to change the file
filen.csvto the target format (which is called utf-16):
iconv -f utf-8 -t utf-16 < filen.csv > filen2.csv
- A new file
filen2.csvis created in the same directory.
- Use this new file in your InDesign data merge!
man iconvwill bring up a text manual for the iconv command. Try it! (Quit the manual by typing
>are “output redirection” symbols, used in two directions in this so-called pipeline
The manual taught us that the command can be expressed as:
iconv --from-code utf-8 --to-code utf-16 < filen.csv > filen2.csv
This may be easier to read.
- Changing directory can be done using the text command
cd(“change directory”), followed by the path you want to navigate to.
pwdis a text command that reads “print working directory”. Try it!