Saving, importing, and exporting data > Supported import/export file formats > Comma-separated values format
 

Comma-separated values format

You can import, convert, and export files in comma-separated values format.

Converting comma-separated values to FileMaker Pro Advanced

Field names are generic (f1, f2, f3, and so on).

All fields are text fields.

Exporting comma-separated values files

Commas separate field values. Carriage return characters separate records. Quotation marks enclose all field values.

Carriage return characters in a field export as vertical tab characters.

Values in repeating fields are separated by the group separator character.

Only numeric data is exported from number fields. Any non-numeric data such as text or symbols is not included in the exported data.

Quotation marks (") in a field (not curly quotes) export as double quotation marks ("").

Related topics 

Importing data into FileMaker Pro Advanced

Exporting data from FileMaker Pro Advanced