CSV Import

CSV import

The Import Data tab handles bulk importing statements from CSV files. The import process uses AI to transform your CSV data into the correct schema structure.

Import steps

The import follows a three-step flow shown by the progress indicator at the top:

Step 1: Upload and configure

  1. Select Target App – Choose which app the statements will be imported into
  2. Select Schema Type – Pick the schema that matches your content structure. Once selected, the schema’s parts are shown as a preview so you can verify your CSV matches
  3. Upload CSV – Drag and drop a .csv file into the upload zone, or click to browse. The file must be a valid CSV

Step 2: Preview

After upload, the system sends your CSV to the backend where AI analyzes and transforms the data to match the selected schema’s parts structure. The preview shows:

  • How many statements were parsed
  • How each CSV row maps to the schema parts
  • Any rows that couldn’t be parsed or have issues
  • A sample of the transformed statements

Review the preview carefully before proceeding.

Step 3: Execute

Confirm the import to persist the statements to the database. The system creates statements with:

  • Text parts mapped to the schema structure (English locale by default)
  • Auto-generated NanoIDs
  • The isAIgenerated flag set if AI transformation was involved
  • Association with the selected schema type

CSV format

Your CSV should have columns that roughly correspond to the schema parts. The AI transformation handles mapping even if column names don’t match exactly. For best results:

  • Include a header row
  • One statement per row
  • Use UTF-8 encoding
  • Keep text fields clean (no excessive whitespace or special formatting)

Error handling

If rows fail to parse, they’re shown in the preview with error details. You can proceed with the successful rows and fix the problematic ones later, or cancel and fix your CSV file first.

Tips

  • Start with a small test file (10-20 rows) to verify the mapping works correctly
  • If you have content in multiple languages, import the English version first, then use AI Translations to generate other languages
  • Check the Statements tab after import to verify everything looks correct