CSV file format

Source: Internet
Author: User

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.