• Gossen Metrawatt
  • Camille Bauer

PG803: Correct Editing of the CSV File in Excel

Under certain circumstances, leading zeros included in IDs, serial numbers etc. may be lost. In order to avoid this, open the CSV file from within Excel and follow the steps below to open and edit the CSV file.


1. Start Excel.

2. Click “Data” --> “Get external data”.

3. The text conversion wizard appears:

Izytroniq: Richtige Bearbeitung der CSV-Datei in Excel


4.
Delimiter: semicolon

Izytroniq: Richtige Bearbeitung der CSV-Datei in Excel


5.
Data format for the columns: At least the “CustomerID” and “ID” columns must be formatted as text:

Izytroniq: Richtige Bearbeitung der CSV-Datei in Excel


6.
Finish.

Results:

Izytroniq: Richtige Bearbeitung der CSV-Datei in Excel


Results After Opening the CSV File via the Explorer:

Izytroniq: Richtige Bearbeitung der CSV-Datei in Excel

 

Dialogue, Information and Actions: