Skip to main content

CSV file formats used in the test data import mode

Create test data according to the following format. Note that repeated fields in records are not supported.

The maximum number of rows in a CSV file is 100, and the maximum file size is 100 KB.

  • Use a comma (,) as a delimiter.

  • Use line feeds to separate rows.

  • In the first row, specify the field name.

    You do not need to specify the fields into which you do not feed data. The order of the fields is arbitrary.

  • Specify data to be fed to the second and subsequent lines.

    If you specify multiple records of data, they will be output in order from the top (sorting by key number is not applied).

  • Save the file in "UTF-8" encoding.

  • If you use commas (,) or double quotation marks (") within the data, enclose the data in double quotation marks (") and specify the data as follows.

    Symbol to output

    Example

    Output result

    Description

    Comma (,)

    "Remarks,1"

    Remarks,1

    The comma (,) in the data is treated as a character.

    Double quotation mark (")

    "Remarks""2"

    Remarks"2

    Add another double quotation mark (") consecutively to the double quotation mark (") in the data.

Example 1. Example of CSV file
Code,Product,QTY,UnitPrice

1,100 Percent Orange Juice,2,200g

2,100 Percent Grape Juice,2,200g
3,Mild Coffee,2,195g


In this section: