Read csv - Format

Hello,
I would like to import the data from a CSV file into an Excel worksheet.

Unfortunately, the formatting of the CSV is being distorted during import.

In the first row of the CSV, the date is in the format dd.mm.yyyy. However, upon import, the date in the first 6 columns is correct, but in the othter columns the date is reformatted to mm.dd.yyyy.

Additionally, some values have decimal places, for example, 100.50, and in this case, the value is imported as text.

The CSV file is automatically exported from the ERP system in the Windows-1250 format. Can anyone help me with this issue?

Hi,

Can you share sample csv and expected output? It’s no problem if dummy data.

Regards,

@Birgit_Plank

Please send the input and output Files

Unfortunately, as a new user, I am unable to upload anything. I am receiving an error message.

Image upload works, that’s the csv

@Birgit_Plank
Perfect in our short session we had set up the trail

writing it out to Excel will create some wrong cell formats - but the ambiguous misinterpreted dates cannot be reformated

So we recommend:

  • Data cleansing /harmonization - DateTime.ParseExact
  • Writing out to Excel
  • if needed, cell reformatting
    Activities - Format Cells