File Uploads

Import data from CSV, JSON, and Excel files.

6 min readUpdated December 2024

Supported File Formats

Solinth supports importing data from the following file formats:

  • CSV: Comma-separated values (.csv)
  • JSON: JavaScript Object Notation (.json)
  • Excel: Microsoft Excel (.xlsx, .xls)

File Size Limits

  • Free: Up to 10MB per file
  • Pro: Up to 100MB per file
  • Enterprise: Up to 1GB per file
Large Files
For files larger than your plan limit, use the batch API endpoint to upload data in chunks.

Uploading a File

Step 1: Navigate to Data Import

Go to Settings → Data → Import and click Upload File.

Step 2: Select Your File

Drag and drop your file or click to browse. Solinth will automatically detect the file format and parse the contents.

Step 3: Preview and Map Columns

Review the parsed data and map columns to Solinth fields:

  • Event Name: Which column contains the event type
  • Timestamp: Which column contains the date/time
  • Properties: Additional columns to include as event properties

Step 4: Configure Import Settings

  • Date Format: Specify the date format if not auto-detected
  • Timezone: Set the timezone for timestamps
  • Duplicate Handling: Skip, update, or create duplicates

Step 5: Import

Click Start Import to begin processing. You'll see a progress bar and can continue using Solinth while the import runs in the background.

CSV Format Requirements

For best results, ensure your CSV file:

  • Has a header row with column names
  • Uses UTF-8 encoding
  • Uses commas as delimiters (or specify a custom delimiter)
  • Properly escapes special characters with quotes

JSON Format Requirements

JSON files should be an array of objects:

[
  {
    "event": "purchase",
    "timestamp": "2024-01-15T10:30:00Z",
    "amount": 99.00,
    "customer_id": "cust_123"
  },
  {
    "event": "signup",
    "timestamp": "2024-01-15T11:00:00Z",
    "plan": "pro"
  }
]

Import History

View all past imports in Settings → Data → Import History. You can see:

  • Import status (completed, failed, in progress)
  • Number of records imported
  • Any errors or warnings
  • Option to undo/rollback an import
Rollback Window
Imports can only be rolled back within 24 hours. After that, you'll need to manually delete the imported events.
Solinth Suite - All-in-One Business Management