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:
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.
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
Please note: I have completely revamped the format for the CSV file for the 10 Column format. What's changed Earlier, the RichResponse column expected Markdown, which doesn't work well and does not scale for all the different channels. Instead, you ...
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 ...