CSV is comma separate values. This file format is often used as differentProgramThe format of data interaction between them. The final file can be opened in a spreadsheet program (such as Microsoft Excel) or used as an import format for other programs.
CSV file format:
Each record occupies one row (if the field contains a line break, one row will become multiple rows)
Separated by commas
Spaces before and after Commas are ignored.
The field contains a comma, which must be enclosed in double quotation marks.
The field contains a line break, which must be enclosed in double quotation marks.
A field contains spaces before and after it is enclosed in double quotation marks.
Double quotation marks in the field are expressed in two double quotation marks
If a field contains double quotation marks, the field must be enclosed in double quotation marks.
The first record, which can be a field name
PS: open the file in Excel. If the field starts with 0, the previous 0 is automatically removed. You can add the equal sign to display it normally. (= "00001"), but remember to read it only in Excel. If data is imported, there cannot be equal signs.