How to deal with leading "0" being deleted when downloading CSV files

If an "employee number" or "ID" in a bulk settings file has a leading "0" (e.g. 0001) and is uploaded, the "0" may disappear due to EXCEL specifications when the bulk settings file is subsequently downloaded for updating. If you re-upload that file, an error will occur. Please refer to the response below.

After downloading the CSV file in bulk settings, it is necessary to convert the data format of the column that originally contains "0" to "string" before opening the file.

Example of Operation Procedure

<caution>

The information provided below is an example of operation and is not supported.

The operation methods may also change if the Excel version is different or if the Excel specifications have been changed.

If you have any questions, please contact the support source accordingly.

Excel for Windows Office365

1. Open Excel in a new window and click on "Blank workbook".

2. Click "Data" ▶ "From Text / CSV".

3. Double-click the downloaded CSV file.

4. Click "Transform Data"

5. Confirm that the columns you want to convert to strings and "Modified type" are selected.

If the column you want to select is not selected, click on the column name to select it.

6. Right-click the selected column and click "Change Type" ▶ "Text"

7. Click "Replace Current"

8. Confirm that the data format has been converted and click "Close and Load".

9. Click "File" after conversion.

10. Click "Export"

11. Click "Change File Type" ▶ "CSV (Comma delimited) (*.CSV)" ▶ "Save As".

12. Click "OK"

Upload the CSV file saved in the above steps to Motivation Cloud Engagement.