Skip to main content

Import FAQs with Excel or CSV

info

Learn how to import FAQs into AI SmartTalk's Knowledge Base using structured Excel or CSV files. This feature is ideal for adding pre-defined questions and answers for chatbot responses.

File Format Requirements​

Ensure your file follows this structure:

  • Column 1 (Question): Queries users might ask (e.g., "How do I reset my password?").
  • Column 2 (Answer): Responses provided by the chatbot (e.g., "Click 'Forgot Password' on the login page.").
  • Column 3 (Optional - Link): URLs linking to additional resources.
  • Additional Columns (Optional): Use for advanced categorization or metadata.

Example​

Question,Answer,Link,Category
How do I reset my password?,Click 'Forgot Password' on the login page.,https://example.com/reset-password,Account
How do I update my profile?,Go to 'Settings' and click 'Edit Profile.',https://example.com/update-profile,Profile
tip

Well-structured files improve chatbot efficiency and accuracy.

Importing Excel Files​

  1. Navigate to the Knowledge Base section in AI SmartTalk.
  2. Click Upload File and select your Excel file.
  3. Review and confirm the file format:
    • Column 1: Question
    • Column 2: Answer
    • Column 3 (Optional): Link
  4. Click Import to process the file.

Default Behavior​

  • The AI uses the first column for query matching.
  • Remaining columns provide responses and additional data.

Importing CSV Files​

  1. Follow the same steps as for Excel imports.
  2. Ensure your CSV uses commas as delimiters and matches the required column structure.
  3. Upload and confirm column mapping during the process.
tip

CSV files are lightweight and ideal for large datasets.

Example Use Case​

Scenario: Adding Customer Support FAQs​

  1. Prepare an FAQ file with common queries:
  2. Import the file into AI SmartTalk's Knowledge Base.
  3. The chatbot is now ready to provide accurate answers to these queries.

Troubleshooting​

Common Issues​

  • Error: Unsupported File Format

    • Ensure the file is saved as .xlsx or .csv.

  • Error: Parsing Issues

    • Check for missing headers or invalid data in required columns.
danger

Incorrect file formats or missing data may lead to inaccurate chatbot responses. Validate files before importing.

Next Steps​

After importing your FAQs:

  • Organize entries using tags or categories for better searchability.
  • Learn about importing document files for unstructured knowledge.