VICIdial lead loader for CSVs of up to a million rows
7-day free trial · Cancel anytime · Pay with card or USDT
- rows per file
- 1,000,000
- largest CSV
- 250 MB
- to undo an import
- 10 min
- imports at once per server
- 5
How do you load leads into VICIdial?
Open the server’s Lists tab and press Import leads. Pick the list the leads go into, choose a CSV, match its columns to VICIdial’s fields, set how duplicates and DNC numbers are handled, check the preview and start. The import runs on the server, so you can close the window and follow it on the Lists tab.
- File: pick the destination list and choose the CSV.
- Map: each VICIdial field is matched to a column of your file, with a sample value beside it.
- Options: country code, duplicates, DNC, the status new leads get, time zones.
- Preview: the row count and every option, before anything is written.
- Running and Done: live counts, then Undo for 10 minutes and a file of skipped rows.
VICIdial’s own Load New Leads page is still there: open VICIdial admin from the dashboard and use it as you always have.
What format does a VICIdial lead file need?
A CSV file with a header row. Only two columns are required: the phone number and the last name. The loader recognises 26 standard VICIdial lead fields, from first name, address and postal code to email and vendor lead code, and offers the list’s custom fields too, so those values show on the agent screen.
- Phone numbers can carry spaces, dashes or brackets: everything but digits is stripped.
- A default country code fills in for rows that don’t have one: 1, 44, 61, 52 or 91.
- “USA/Canada only” skips any number that isn’t ten digits.
- Alternate phones separated by “!” go into VICIdial’s alternate-phone table.
- Dates of birth are read as MM/DD/YYYY, DD/MM/YYYY or YYYY-MM-DD, or detected.
Excel and Google Sheets files need saving as CSV first. The loader reads CSV only.
How are duplicates and DNC numbers handled?
Duplicates are matched on the phone number. You choose to load every row, or to skip numbers already in this list (the default), in the list’s campaign, or anywhere on the server. Numbers on VICIdial’s Do Not Call lists are skipped, or loaded marked DNC so they stay on record and are never dialed.
Each lead also gets its time zone on the way in, from its country and area code, its postal code or a time-zone column. That is what lets a campaign’s local call time follow the lead’s own clock instead of yours.
What happens after the import starts?
The file uploads straight from your browser, then a background job on the server writes the rows into the list in batches. The dialog shows rows inserted, duplicates, invalid phones and DNC as they happen. You get an email when the import starts and another when it ends, with a link to it and the list of skipped rows.
- Undo for 10 minutes after it finishes: leads that haven’t been dialed are removed, any that have stay.
- errors.csv lists each skipped row with its reason: invalid phone, duplicate or DNC.
- The Imports tab keeps the history: file, list, status and rows inserted out of the total.
- Up to five imports can run on one server at the same time.
What you get
More ways leads reach VICIdial
Leads from your vendors, by API
API Studio gives each lead source its own endpoint URL. A posted lead lands in the list you chose, with the same duplicate rules, a per-minute limit and an optional IP allow-list. If the dialer is unreachable, the lead is kept and retried.
Custom fields filled on import
Map a column to one of the list’s custom fields and the value is written after the lead lands, so the agent sees it on the call.
A history you can check later
Every import stays on the Imports tab with its status, its counts and, for a week, the file of skipped rows.
No command line
No SSH session, no script, no splitting the file by hand. The whole import runs from the dashboard.
No waiting at the screen
Close the tab once the upload finishes. The import keeps going and the email tells you when it is done.
FAQ
VICIdial lead import FAQ
Guides
Related guides
- Uploading leadsThe import, step by step.
- Custom lead fieldsAdd fields to a list and show them to agents.
- API StudioGive each lead vendor its own endpoint.
- Do Not Call in VICIdialSystem and campaign DNC lists.
- Duplicate checkHow VICIdial matches duplicate leads.
- GMT offsetWhy each lead carries its own time zone.
Page updated
Load your first list from the dashboard.
Start the 7-day trial, create a list and import a CSV of up to a million leads, with duplicates and DNC numbers skipped for you.