AWS QnABot -- CSV file to JSON converter tool

To support easier ingestion of your content in CSV format, we created this tool to help with the ingestion of CSV content into QnA Bot Designer. Please refer to the CSV input file specifications below.

Input File Specifications
You can get started with your CSV file with just a few fields:
  • question_identifier -- a unique identifier for each question.
  • question_type -- there are 2 types in QnA Bot (qna and quiz). This tool supports "qna" type.
  • question -- question that your users will ask. This field supports input for 1 question. You can use the QnA Bot Designer to add more.
  • answer -- answer applicable for the {question} field.
  • markdown_answer (optional) -- answer applicable for the {question} field in markdown format.
Sample file format: (the last line should be a empty line)

question_identifier, question_type, question, answer, markdown_answer
q_1, qna, this is question 1 created in csv, this is answer 1 created in csv
q_2, qna, this is question 2 created in csv, this is answer 2 created in csv, this is **answer 2** in markdown created in csv
q_3, qna, this is question 3 created in csv, "this is answer 3 created in csv, having commas"



To start the CSV to JSON conversion process, check if your file format matches the above-mentioned specifications.
Once you are ready, select the file by clicking on the "Browse..." button.

Select a CSV file:
After selecting the file, click on the "Convert to QnABot JSON format" button below.



This will load the file and start the conversion process. The "Progress Status" section below, will report the various steps as they are being executed and completed. Once the conversion process has completed, you will receive a dialog pop-up asking you to "Save" the file. Click on "OK" to store the file in your local or network device.

Once the file is saved, go back to your QnABot Designer and "Import" the file.

Progress Status:
This section will show the status of the conversion process.