I think your CSV is malformed.

If I open it in a text editor (notepad++, atom, etc...) I see that each line starts with " and ends with " so Celonis interpretes is a single cell

HTH

That explains Guillermo. Do you have a suggestion how i can transform the csv file in order for make it fit for purpose in Celonis?

Hello Omar,

Please check your .csv file. All columns do not follow the same format. I attach one example.

The date column has various formats.

Depends on your background/tools. If you manage Linux, you can "clean" it with grep and regex.

With Atom you can do replaces where the matching pattern includes codes for start and end line

If you deal with python, you can read each line, and write out the same line without the first and last character (I think will be something like line[-1:-1] to code that slice )

OR maybe load it into excel, apply text to columns, then clean it with some cell function. And then save as excel and upload the excel instead the csv.

HTH

Surprise surpise, didnt know about this one! Thanks Maryam.

Great this solved the problem, i used simple Excel