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.