Guides
Import from CSV
Bulk import items with source mappings, validation, and rollback support.
Bulk import items from CSV files with progress tracking and full rollback capability.
Step 1: Prepare your CSV
Make sure your CSV file has:
- A header row with column names
- One row per item
- Consistent data formatting
Example:
Name,Email,Phone,Deal Value,Source
Jane Smith,jane@example.com,+1234567890,15000,Website
John Doe,john@example.com,+0987654321,25000,Referral
Step 2: Create a source mapping
Before importing, you need a source mapping that defines how CSV columns translate to your pipeline fields.
- Go to Settings → Company Settings → Source Mappings
- Create a mapping and select CSV Import as the type
- Paste your CSV headers or a sample row, and Slate automatically detects the fields
- Map each detected field to a pipeline field (e.g.,
Name→ Contact Name,Email→ Email,Deal Value→ Deal Value)
Review and adjust the automatically detected mappings as needed.
Step 3: Start the import
- Go to Settings → Company Settings → CSV Imports
- Select the pipeline and the source mapping you created
- Choose how to handle duplicates (skip, update existing, or always create new)
- Upload your CSV file (maximum 10 MB)
- Click "Start Import"
Large imports run as background jobs, so you can close the page and return later. Progress is tracked in real time.
After the import
- View import history with row counts, success/failure breakdown, and status
- Cancel a running import at any time. Items already created are preserved.
- Rollback a completed import. This deletes all items created by that import in one operation.
- Failed rows are counted and displayed in the import history
Best practices
- Clean up your spreadsheet before importing. Remove blank rows and fix inconsistent data.
- Validate with a small test file (10-20 rows) before importing full datasets
- If you are importing from another CRM, export as CSV from that tool first