1，正确操作步骤使用导入的方式，然后制定每一列的格式，
否则会出现自动转换为数字，末尾零丢失的情况。
可以先新建一个文件，然后执行数据导入操作
2，或者将csv改名txt 再导入
image.png
Converting CSV to Excel: opening vs. importing
When Microsoft Excel opens a .csv file, it uses your default data format settings to understand how exactly to display each column of text data. This works fine in most situations.
If your text file has specific values and you want to control how to display them in Excel, then do importing rather than opening. Here are a few typical use cases:
- The CSV file uses different delimiters.
- The CSV file contains different date formats.
- Some numbers have leading zeroes that should be kept.
- You want to see a preview of how your CSV data will be converted into Excel.
- You are looking for more flexibility in general.
How to enable Text Import Wizard in Excel 2016 - Excel 365
To activate the Text Import Wizard in modern versions of Excel, this is what you need to do:
- Click the File tab, and then click Options > Data.
- Under Show legacy data import wizards, select From Text (Legacy), and click OK.
image.png
