Skip to main content
J_F_S
Inspiring
July 9, 2022
Answered

Problems to data merge a normal CSV

  • July 9, 2022
  • 2 replies
  • 734 views

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

This topic has been closed for replies.
Correct answer Willi Adelberger

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.

2 replies

Willi Adelberger
Community Expert
Willi AdelbergerCommunity ExpertCorrect answer
Community Expert
July 12, 2022

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.

Peter Spier
Community Expert
Community Expert
July 9, 2022

What error message do you receive?

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

J_F_S
J_F_SAuthor
Inspiring
July 9, 2022

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

quoteDie 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.

 

quote

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
Community Expert
Community Expert
July 9, 2022

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