Summary
This article describes comma-separated value (CSV) file format specifications.
Requirements
The CSV-formatted files that you upload to the Application Gateway must follow these requirements:
- They must be comma-delimited text files with an extension of .CSV, hosted in the directory of a Web server.
- The files must be saved with UTF-8 encoding if your directory contains European characters.
- A record is one line. Records must be separated by a line feed (ASCII/LF=0x0A) or carriage return and line feed pair (ASCII/CRLF=0x0D 0x0A). Fields may contain embedded line breaks; therefore, a record can occupy more than one line. Embedded line breaks must be surrounded by double quotation marks. If a field contains a comma, the comma must be enclosed in double quotation marks (“,”). All fields can be enclosed in double quotation marks.
- Leading and trailing spaces (or tab characters) adjacent to the comma field separators are ignored. If a field contains leading or trailing spaces, those spaces must be delimited with double quotation marks. Fields that contain double-quote characters must be surrounded by double quotations, and the embedded double-quotes must each be represented by a pair of consecutive double quotes. For example: “Richard ““Mac”” McGregor.”
- The field order must be as follows:
LastName,FirstName,PhoneNumber1,PhoneNumber2,PhoneNumber3,PhoneNumber4,PhoneNumber5,PhoneNumber6,Email,Title,Department
More Information
The following examples illustrate records with one, two, and three phone numbers:
Jones,Matt,5031,,,,,,mjones@company.com,Analyst,Accounting
Jones,Matt,5031,5551234567,,,,,mjones@company.com,Analyst,Accounting
Jones,Matt,5031,5551234567,8005551010,,,,mjones@company.com,Analyst,Accounting
Note: Phone numbers 4 through 6 are for future use.
