Extract data from excel in rasa

Hi everyone, I have a large amount of data including questions and answers in an excel file. How can I get that data into rasa so I can train the data for rasa bot? Thank you very much

Welcome to the forum :slight_smile:

If you don’t want to follow Rasa’s training data format , you need to write a custom importer that translates from your format to Rasa’s.

Do you can give me a basic example ? :sweat_smile:

I don’t have an example, sorry.

Read about the different Rasa files (nlu, stories, rules, domain, …) and find a way to convert the information you have in Excel to the needed format.

Imagine you’re just writing a regular Python script for it - and you could even do just that. But Rasa is helping you with custom importer classes.

For getting your Excel data into Rasa, you’ll want to export the questions and answers from Excel as a CSV and then use that to format the data into Rasa’s training format (usually YAML or Markdown). You’ll need to structure it as intents and responses for Rasa to understand. If you’re comfortable with Excel, organizing it should be pretty straightforward. When I was learning how to handle large datasets, myexcelonline academy had some solid courses that made working with Excel a lot easier, especially when exporting and formatting data for different tools like this.