Problems to data merge a normal CSV

[J_F_S]

Hi,
I have a problem to use the data merge with my csv.
The csv is generated from Toggl the timetrack app.
I don't understand whats teh problem is that ID have. Its a normal comma seperated file.

User,Email,Client,Project,Task,Description,Billable,Start date,Start time,End date,End time,Duration,Tags,Amount ()

This is the first line of my csv file.

Cheers

[Peter Spier]

What error message do you receive?

Haver you tried removing the () from the last entry?

[J_F_S]

Yes I tried to delete the brackets at the end. No change.
The errormessage is: 

Die gewählte Datenquelldatei enthält keine Datensätze oder liegt nicht
in einem unterstützten Dateiformat vor. Reparieren Sie die Datei oder
wählen Sie eine Datei mit Datensätzen bzw. einen unterstützten
Dateityp aus.

The selected data source file does not contain records or is not in a supported file format. Repair the file or select a file with records or a supported file type.

[Peter Spier]

Try copying the data into a new spreadsheet and amnaully add the header row.

[J_F_S]

Hi,
sorry, what do you mena with amnaully?

[J_F_S]

I found out whats wrong with my csv.
It must be Western (MacOS Roman) coded.
It's a shame Adobe that you don't support UTF-8 for CSV. Its so 90s.

[HARSHIKA_VERMA · Accepted solution]

Hi @J_F_S,

I assume you're looking for a similar request mentioned on our InDesign UserVoice page. If so, then we would request you to please submit your feedback and upvote the request to add your voice.

We will also make sure to pass on your feedback to the team.

Thanks,

Harshika

[Willi Adelberger · Accepted solution]

If you have problems with CSV files, try tabulator separated files.

E.g. here in German we use commas, where the English uses dots, we use dots, where the English uses commas. But for example Excel changes not only in the table dots and commas, but also in exported files like CSV or codes this exchange and makes the program in German not usable for many purposes. We can either change the MS Language for Office or use less errative files like tabulator separated text files.