Using Excel to view or edit CSVs may cause issues with formatting, as things like leading zeroes will not be kept (for example, a sourcedId of 0021 will become 21). If you wish to view CSVs with Excel, follow these steps.
Step 1
Open Excel and create a new Blank workbook.
Step 2
Click "Data", then "From Text"
Step 3
Locate the CSV you want to open, then click import.
Step 4
The Text Import Wizard will appear. Click next on the first step.
On the next step, uncheck "Tab" and check "Comma".
Next, hold Shift, scroll the Data preview all the way to the right and click on the last column. All columns in the Data preview should now be highlighted in black. Click "Text" under "Column data format". Finally, click Finish.
Step 5
Click OK.
All columns should be present, and leading zeroes should be maintained.
Comments
0 comments
Article is closed for comments.