4 Column CSV Format (Basic FAQ Bot)

4 Column CSV Format (Basic FAQ Bot)

While the 2 column CSV format allows you to add only one question and answer per intent, you can specify multiple training phrases and multiple responses per intent using the 4 column format. You can download a sample 4 column CSV file at the bottom of this article. 

The following image shows an example of the 4 column format.



The CSV file should have exactly 4 columns, and the column names are mandatory AND case sensitive:
IntentID
IntentName
Query
Response

I recommend downloading a sample CSV file and modifying the contents without changing the header row. 

Use the same IntentID to group all the information belonging to a single intent



The IntentID should be a number. However, the IntentID is only used for grouping all the information and you can use whatever number you want. It doesn't even have to be in order in the CSV file. 

The second column is the IntentName

You cannot use the forward-slash character (/) in the IntentName since it interferes with how the file system generates your ZIP file. 

Specify multiple training phrases for a single intent in the Query column

When you add more training phrases in the Query column (remember to use the same IntentID), these will be added as unique training phrases into your Dialogflow intent. 

Specify multiple responses for a single intent in the Response column

Remember that when you have multiple responses in a single response block in Dialogflow, it randomly selects only one of the responses and doesn't show all the responses in sequence. For some reason, people always seem to be confused by this in Dialogflow. 

How it gets translated

Now let us consider what the agent looks like for the CSV file you see above. 








As you can see, while the IntentID is useful to group the information for an intent, it doesn't actually show up in the final agent ZIP file. 

    • Related Articles

    • 2 Column CSV Format (Simple FAQ Bot)

      The 2 column CSV format is the simplest format for using the FAQ bot generator in BotFlo. You can download a sample 2 column CSV file from the bottom of this article.  It consists of just a simple Query and Response format, specified in 2 columns as ...
    • 10 Column CSV format for Advanced FAQ Bot

      You can add multiple training phrases and multiple responses per intent using the 4 Column CSV format.  However, if you want to specify input and output contexts, you need more columns in your CSV file. The 10 Column CSV file helps you specify the ...
    • 10 Column CSV Format for Rich Responses FAQ Bot

      Supporting rich responses is possible if you use Markdown and its extensions to write the responses.  There are two important things to note here: a) you should be fairly proficient in Markdown to be able to use this feature. While Markdown is not ...
    • Convert 4 Column CSV file to Dialogflow agent ZIP file

      Pricing: BotFlo Plus and BotFlo Pro Link to tool 1 If you haven't already done so, first log in to BotFlo. 2 From the menu, select FAQ Bots > Text Only > Basic (4 Column) 3 Select the bot's language 4 Select the bot's timezone 5 Browse and select the ...
    • Convert 2 Column CSV file into Dialogflow agent ZIP file

      Pricing: BotFlo Starter, BotFlo Plus and BotFlo Pro Link to tool 1 If you haven't already done so, first log in to BotFlo. 2 From the menu, select FAQ Bots > Text Only > Simple ( Column) 3 Select the bot's language 4 Select the bot's timezone 5 ...