Skip to main content

Batch Import

Import multiple questions at once from Excel, CSV, PDF, or other formats to quickly build your question bank.

Overview​

Batch import allows you to add hundreds or thousands of questions to Testify in minutes instead of creating them one by one.

Batch Import

Supported Formats​

Excel/CSV Import​

  • Upload Excel (.xlsx, .xls) files
  • Upload CSV files
  • Template-based import
  • Column mapping

PDF Import​

  • Extract questions from PDF documents
  • AI-powered recognition
  • Automatic formatting
  • Review and edit before import

Moodle XML​

  • Import from Moodle question banks
  • Preserves question types
  • Maintains metadata
  • Compatible with Moodle exports

Word Documents​

  • Import from .docx files
  • Structured format required
  • Template available
  • Formatting preserved

Excel/CSV Import Process​

Step 1: Download Template​

  1. Go to "Question Bank" → "Import"
  2. Click "Download Template"
  3. Choose format (Excel or CSV)
  4. Save template file

Step 2: Fill Template​

Template Columns:

  • Question Text (required)
  • Question Type (MCQ, Subjective, etc.)
  • Option A, B, C, D (for MCQ)
  • Correct Answer (required)
  • Solution/Explanation
  • Marks
  • Difficulty Level
  • Board, Subject, Chapter, Topic
  • Tags

Example:

Question,Type,OptionA,OptionB,OptionC,OptionD,Correct,Solution,Marks,Difficulty,Board,Subject,Chapter,Topic
"What is 2+2?",MCQ,3,4,5,6,B,"2+2 equals 4",1,Easy,CBSE,Mathematics,Arithmetic,Addition

Template

Step 3: Upload File​

  1. Click "Upload File"
  2. Select your filled template
  3. Click "Next"

Step 4: Map Columns​

  1. Verify column mapping
  2. Adjust if needed
  3. Preview data
  4. Click "Next"

Step 5: Review & Import​

  1. Review questions
  2. Fix any errors
  3. Select questions to import
  4. Click "Import"
  5. Questions added to bank

Review Import

PDF Import Process​

Upload PDF​

  1. Go to "Import" → "From PDF"
  2. Upload PDF file
  3. AI processes document
  4. Extracts questions

AI Processing​

What AI Does:

  • Identifies questions
  • Recognizes question types
  • Extracts options
  • Identifies correct answers
  • Formats content

Review Extracted Questions​

  1. View extracted questions
  2. Edit if needed
  3. Verify correct answers
  4. Add missing information
  5. Approve for import

Import to Question Bank​

  1. Select questions to import
  2. Assign taxonomy
  3. Add tags
  4. Click "Import"

PDF Import

Best Practices​

Preparing Data​

✅ Before Import:

  • Use provided template
  • Fill all required fields
  • Check spelling and grammar
  • Verify correct answers
  • Test with small batch first

Data Quality​

✅ Ensure Quality:

  • Clear question text
  • Distinct options
  • Accurate solutions
  • Proper formatting
  • Consistent taxonomy

Error Prevention​

✅ Avoid Errors:

  • Don't skip required fields
  • Use correct data types
  • Follow naming conventions
  • Check for duplicates
  • Validate before upload

Common Issues​

Import Failed​

Possible Causes:

  • Invalid file format
  • Missing required columns
  • Data validation errors
  • File too large
  • Encoding issues

Solutions:

  • Check file format
  • Verify all required columns present
  • Fix validation errors
  • Split into smaller files
  • Save as UTF-8

Questions Not Imported​

Check:

  • Error messages
  • Validation log
  • Required fields
  • Data format
  • File encoding

Formatting Issues​

Solutions:

  • Use plain text
  • Remove special characters
  • Check LaTeX syntax
  • Verify image paths
  • Test with sample

Advanced Features​

Bulk Edit After Import​

  1. Import questions
  2. Select imported questions
  3. Bulk edit metadata
  4. Apply changes

Import with Images​

Include Images:

  • Reference image files
  • Upload images separately
  • Link in question text
  • Verify after import

Custom Mapping​

Map Custom Fields:

  • Define custom columns
  • Map to Testify fields
  • Save mapping template
  • Reuse for future imports

Custom Mapping

Tips for Efficiency​

Large Imports​

For 1000+ Questions:

  • Split into batches of 500
  • Import during off-peak hours
  • Monitor progress
  • Verify each batch

Reusable Templates​

Save Time:

  • Create subject-specific templates
  • Save mapping configurations
  • Document your process
  • Share with team

Quality Control​

After Import:

  • Random sample check
  • Test questions in practice mode
  • Get peer review
  • Fix issues promptly

Next Steps​

Need Help?​