Importing CSV file with Data Merge Fails

[jsejcksn]

Specs

See pasted text from CSV at http://pastebin.com/mymhugpN

I am using InDesign CS6 (8.0.1)

I created the CSV by downloading it from a Google Spreadsheet as a CSV. I confirm with the Terminal that the character encoding is utf-8 usnig the file command.

Problem detailed

I am trying to import a CSV file (utf-8) with Data Merge via the Select Data Source... command with Show Import Options checked. When viewing the Data Source Import Options dialog, I set the following options—Delimiter:Comma, Encoding:Unicode, Platform:Macintosh. I leave Preserve Spaces in Data Source unchecked. It fails to import any variables and produces no error message. I have tried other CSV files as well (created TextEdit, Espresso, etc.) and it seems that InDesign will not import any files if Unicode is specified as the encoding, no matter which other options are specified.

Can anyone else confirm this?

Importing as ACSII works, but obviously does not display my content correctly.

[antone8227487]

Hi,

Here is what has worked for me on MacOS High Sierra:

Open Sublime (I am using Sublime editor version 3)

Paste text

File > Save with encoding > UTF-16 LE

Hope this helps.

[ajbarabasz]

InDesign cannot correctly read UTF8 files. This is not a minor inconvenience. It's a bug, let us call a spade a spade.

All you have to do is save file as UTF16 (big-endian or little-endian, with BOM or not - it doesn't matter). Simply don't use UTF8.

[BobLevine]

This has run its course. Locked!