Import an FAQ from an Excel file

Vizir allows you to import FAQs into your chatbot in Excel format. Nothing could be easier to feed your robot!

In this article, I will go into more detail about the mandatory structure that you must respect for your csv file. So let’s take the example of the e-shop FAQ.

So there are 5 columns in this template:

1) the first one that just matches the line number

2) the second which describes the message you want the chatbot to display.

Example: in line 2, I defined my resource with the bot message “Welcome…”, which allows me to get this text when I access my FAQ in the chatbot. To get two messages like below, you just need to separate with a “;” the text of your two messages.

3) the third which describes the title of the resource => this is also the name that will be placed in the button

4) the fourth column, the level => Is the resource a menu? a submenu? a sub-sub menu?

Column 3 and 4 are closely linked, together they allow you to manage the display of buttons in the chatbot. For example: on line 2 I have level 0 of my faq = my menu, so I would have ALL LEVEL 1 RESOURCE NAMES in buttons, so “Warranty”/”Return items”/”Product Manufacturing”.

5) the fifth column, keywords => they will allow training the Elastic Search algorithm so that the chatbot redirects to content adapted to user requests.

For example: my chatbot will know that it has to go to the resource of line 2 if I type the keyword “guarantee”.

It’s your turn !

To know all about the  chatbots and AI, subscribe to the Newsletter

You seem to like what you read...

Why not subscribe to our newsletter?

Receive this type of content and many others (tools, news, testimonials, podcasts…) every week directly to the mailbox of your choice. Unsubscribe at any time.