How to Import Leads from a File
Import a batch of leads from a CSV, Excel or delimited text file, matching its columns to your lead fields.
Before you start
- The Manage CRM Settings right.
- An active market, with at least one vendor and product (see How to Add a Lead Vendor and Its Products). The import tells you This import cannot go ahead yet if any is missing.
Steps
Go to Settings → Client Relations Manager → Lead Sources → File Imports. It opens on Import Leads, which walks you through five steps: Upload, Settings, Map Fields, Review and Import.
1. Upload
- Drop a file onto the page (anywhere on it works) or click to choose one. Kamo reads CSV, XLS, XLSX and TXT files with one lead per row. Download A Sample File shows the layout if you want a starting point.
- Kamo shows the file's type and how many rows and columns it found.
- If a saved template matches the file's columns, We Know These Columns appears with how close the match is: Exact Match, Same Columns, New Order or Similar (with how many columns are missing or new). Choose Use This Template to skip most of the matching, or Start Fresh.
2. Settings
- Under How The File Is Read, check Kamo's guesses: Columns Are Separated By and First Row Is Column Names. On, the first row names the columns and is not imported; off, the first row is a lead too and the columns are numbered. The preview of the first rows updates as you change them.
- Under Where These Leads Come From, choose the Market, Vendor and Product. The market starts as the one picked at the top of the page.
- Optionally, under Start From A Saved Template, load a template's column matches.
3. Map Fields
- Click a lead field, then the file column that fills it, or drag between them.
- Kamo tells you which required fields still need a column.
- Match the vendor's lead ID column if the file has one, so a lead imported twice is spotted as a duplicate.
- Optionally type a name under Save This Match As and click Save Template, so the next file with these columns is matched for you.
4. Review
- Check Before You Import sums up the file, market, vendor and product, rows, columns matched and template.
- What Kamo Checked reads the first rows the way the import will, and counts rows that look right, warnings and errors, for example a required value that is empty or something that does not look like an email address.
- If you matched a consent column, Text Consent asks whether it counts as agreeing to texts (see Text Consent from a Lead Source).
- Errors must be fixed on Map Fields before you can go on. When all is well, click Import with the number of leads.
5. Import
Keep the page open until it finishes; a large file can take a minute.
What you'll see
Import Finished shows how many leads were imported, how many were duplicates and how many were assigned. A row with a problem is left out rather than stopping the whole file. If you didn't save a template, Kamo offers Save This Match As A Template?. From here, choose Import Another File or See Past Imports, where left-out rows can be fixed and tried again (see How to Review Past Imports and Retry Left-Out Rows).