1 Prerequisites
Before you begin importing your FAQ content, make sure you have:
- A SoundMinds.ai account - See our Signup Guide
- A chatbot already created - Create Your First Chatbot
- Your existing FAQ content (website page, document, or spreadsheet)
2 Export your existing FAQ content
First, gather your FAQ content from wherever it currently lives.
From a website:
- Copy FAQ content from your website's FAQ page
- Include both questions and answers
- Keep the original formatting if possible
From a document:
- Export to plain text or copy/paste content
- Organize by question-answer pairs
Tip: If your FAQ is on a public webpage, you can also use the Web URL import feature in Step 5 to automatically extract Q&A pairs.
3 Transform FAQ with ChatGPT
Use ChatGPT to convert your FAQ content into a structured format. Copy the prompt template below and paste your FAQ content where indicated:
ChatGPT Prompt Template:
I have FAQ content that I need to transform into structured Q&A pairs for import into a chatbot knowledge base. Please convert the following FAQ content into JSON format with this structure:
{
"categories": [
{
"name": "Category Name",
"qapairs": [
{
"question": "The question text",
"answer": "The answer text"
}
]
}
]
}
Group similar questions into categories. Keep answers concise but complete. Here is my FAQ content:
[PASTE YOUR FAQ CONTENT HERE]
What to expect:
- ChatGPT will organize your FAQs into logical categories
- Questions will be cleaned up and standardized
- Answers will be formatted consistently
Tip: Review ChatGPT's output for accuracy. AI may occasionally misinterpret or incorrectly group content.
4 Prepare your import file
SoundMinds.ai supports three import formats. Choose the one that best fits your needs:
JSON Format (recommended for categories):
{
"categories": [
{
"name": "General Support",
"qapairs": [
{
"question": "What are your business hours?",
"answer": "We're open Monday through Friday, 9am to 5pm EST."
},
{
"question": "How do I contact support?",
"answer": "You can reach us at support@example.com or call 1-800-555-0123."
}
]
}
]
}
CSV Format (simpler, flat structure):
question,answer,category
"What are your business hours?","We're open Monday through Friday, 9am to 5pm EST.","General"
"How do I reset my password?","Click 'Forgot Password' on the login page...","Account"
CSV columns:
question(required): The question textanswer(required): The answer textcategory(optional): Category name for organizationstatus(optional): "active" (default) or "draft"enabled(optional): "true" (default) or "false"
Excel Format (.xlsx):
- Column A: Question
- Column B: Answer
- Column C (optional): Category
- First row should be headers
Tip: JSON format is best when you have categorized FAQs. CSV is simpler for flat lists. Excel works well for spreadsheet users.
5 Import Q&A pairs into SoundMinds.ai
Two methods are available for importing your Q&A pairs:
Method A: AI-Validated Import (recommended)
- Navigate to your chatbot's Knowledge Base page
- Click the "Import (AI Validated)" button
- Choose your import source:
- Web URL: Enter the URL of your FAQ page for automatic extraction
- File Upload: Upload CSV, JSON, or Excel file
- Select your file type (if using File Upload)
- Upload your file or enter the URL
- Click "Validate & Continue"
Method B: Quick CSV Import
- Navigate to your chatbot's Knowledge Base page
- Click "Import CSV" button
- Select your CSV file
- The system imports directly without validation step
Tip: AI-Validated Import includes PII detection, duplicate detection, and semantic duplicate checking. Use this for important imports.
6 Review and validate imported pairs
After validation, you'll see a comprehensive review of your import:
- Total pairs found: Number of Q&A pairs detected
- PII warnings: Any personal information detected (emails, phone numbers)
- Duplicate detection: Exact and semantic duplicates found
- Categories: Organized groupings (if using JSON with categories)
Review step options:
- Review each Q&A pair before importing
- Exclude specific pairs if needed
- Edit questions or answers inline
- Click "Confirm Import" to proceed
Important: PII (Personally Identifiable Information) in answers may be flagged. Review and remove sensitive data like personal emails or phone numbers before importing.
7 Generate embeddings
After import, you must generate embeddings to enable semantic matching:
- Navigate to Knowledge Base for your chatbot
- You'll see your imported Q&A pairs
- Click "Generate Embeddings" button
- Wait for embeddings to be generated
Why embeddings matter:
- Embeddings enable semantic matching (understanding meaning, not just keywords)
- Without embeddings, the chatbot can only do exact keyword matching
- Always generate embeddings after adding or updating Q&A pairs
Important: Don't skip this step! Your chatbot won't be able to semantically match questions without embeddings.
8 Test your imported Q&A pairs
Verify that your imported content works correctly:
- Go to Knowledge Base > Test tab
- Enter questions from your FAQ
- Verify the chatbot matches the correct Q&A pair
- Check the confidence scores:
- Semantic score: How well the meaning matches
- BM25 score: How well keywords match
- Combined score: Weighted blend (70% semantic + 30% BM25)
Tip: Test with variations of your questions. Ask "What time do you close?" instead of "What are your business hours?" to verify semantic matching works.
9 Best practices for effective answers
Writing good questions:
- Use natural language customers actually use
- Include common variations as keywords
- Keep questions specific and focused
Writing good answers:
- Be concise but complete
- Include actionable information
- Avoid jargon unless necessary
- Update answers when information changes
Organizing with categories:
- Group related Q&A pairs together
- Use consistent category names
- Categories help with maintenance and reporting
Maintenance tips:
- Review chatbot analytics for unanswered questions
- Add new Q&A pairs for common questions
- Update outdated information regularly
- Re-generate embeddings after making changes