Integrations
Import and export prospects
Bring prospects in from a CSV spreadsheet, or export them to a CSV file.
You can bring prospects into LeadScout from a spreadsheet on the web, and export them to a CSV file. Import and export are on every plan, including Free. The mobile app does not import or export.
Who can import
Only the owner can import. The Import page under Settings only appears for the owner. Anyone on the team can export.
Import from a spreadsheet
- Open Settings, then Import.
- Click Download sample CSV to see the columns LeadScout reads.
- Drag your file into the upload box, or click it to choose a file.
- Click Import.
If something in the file needs a decision, LeadScout shows a review card before importing anything. See "Before the import starts" below.
File rules
- The file must be a .csv. An Excel .xlsx file is rejected; in Excel, choose File, then Save As, and pick CSV UTF-8.
- Up to 20 MB and 50,000 rows per file. Split bigger files and import them one at a time.
- The first row must be the column headers.
Columns LeadScout reads
Header names are not case sensitive, and common variations work. Each row needs either an address (Address1, City, State and Zip) or a location (Latitude and Longitude). Everything else is optional.
- Address: Address1, Address2 (apartment or unit), City, State, Zip, and Full Address.
- Location: Latitude and Longitude (or lat and lng).
- Contact: Name (or Prospect Name), Phone (or Prospect Phone 1), Phone 2, and Email.
- Lead Status: the status name. A status you don't have yet is created for you. "None" leaves the status empty. Old LeadScout names are matched to today's: Not Home becomes No Answer, Appointment Scheduled becomes Appointment Set, and No Soliciting becomes Do Not Contact.
- Assigned To: the rep's full name. If it's empty, LeadScout uses the email in Lead Status Updated By.
- Tags: one or more tags, separated by semicolons or commas. New tags are created for you.
- Notes: added as a note on the prospect.
- Appointment: a date and time. It's added as an appointment on the prospect. Times without a time zone are read in your own time zone. Appointment Created By can name the rep who booked it.
Rows with only an address import and show in your Prospect List, but they don't get a map pin. A prospect needs latitude and longitude to appear on the map.
A file exported from LeadScout can be imported again as it is.
Before the import starts
LeadScout checks the file first and stops to ask when:
- Some columns won't be imported. The card lists headers LeadScout doesn't recognize. Click Import anyway to ignore them, or Cancel to fix the file.
- Some people are not on your team. The card lists names in Assigned To that don't match anyone on your team. Click Import everything to bring those prospects in with no rep, Skip those rows to leave them out, or Cancel.
The team check only applies to new prospects. Rows that update an existing prospect always import and keep its current rep.
How duplicates are handled
An import never creates a second copy of a prospect you already have.
- A row with the same street address, unit and zip as an existing prospect updates that prospect. Rows with only coordinates match a prospect at exactly the same latitude and longitude.
- An update fills in the name, phones, email, status, rep and location from the file. Empty cells don't erase anything.
- Tags are added; existing tags are never removed.
- Notes are only added when a prospect is first created, so re-importing doesn't stack notes.
- An appointment at the same time on the same prospect is not added twice.
- If the same address appears twice in one file, the second row updates the first.
While the import runs
Large files can take a few minutes. The import runs on LeadScout's servers, so you can leave the page or close the tab. You see Importing… with how many rows are done. When you come back to the Import page, it shows the import still running, or the summary of your last import.
Only one import can run at a time for your organization. If you start another, you see "An import is already running for your team. Wait for it to finish before starting another."
When it finishes, you see how many prospects were Imported (new), Updated and Skipped, with the row number and reason for each skipped row. Click View in Prospect List to see them.
If an import is cut off before it finishes, the page says it was interrupted. Some rows may already be in. Check your Prospect List, then upload the same file again; rows already imported are updated, not duplicated.
Bring territories over from the old LeadScout
On Pro and higher, the owner can also upload the old LeadScout's .geojson territories export on the same Import page. LeadScout shows how many territories it will add or update before you confirm. See Territories.
Export to CSV
- Open Prospect List.
- Filter or search the list until it shows the prospects you want. To export only some rows, check them.
- Click Actions, then Export selected for the checked rows, or Export filtered for every prospect that matches your filters and search. With no filters set, it reads Export all.
Exports of up to 5,000 prospects download straight away as prospects.csv.
Big exports
An export of more than 5,000 prospects is prepared in the background. You see We will email your export, and you can leave the page. LeadScout emails you a link when the file is ready. The link opens the export page, where you click Download CSV. The link works for 7 days; after that, start a new export from the Prospect List.
If you start another big export while one is still being prepared, you see Your export is on its way instead.
What's in the file
One row per prospect, with these columns: id, name, phone, phone2, email, lat, lng, address1, address2, city, state, zip, status, assignedTo, assignedToEmail, tags, notes, createdBy, source and createdAt.
- tags lists every tag, separated by semicolons.
- notes holds the prospect's most recent note.
- After those come statusHistory1, statusHistory2 and so on: one column per status change, oldest first, each showing the status, when it was set and who set it.
See The Prospect List for filtering and selecting.
Questions
Why can I not see Import in Settings?
Only the owner can import. The Import page does not appear for admins or sales reps. Ask your account owner to run the import.
Will importing the same file twice create duplicates?
No. A row with the same street address, unit and zip as an existing prospect updates that prospect instead of creating a new one. Appointments and tags are not doubled either. Notes are only added when a prospect is first created.
My import says it was interrupted. What do I do?
Some rows may already be in. Check your Prospect List, then upload the same file again. Rows that already imported are updated, not duplicated.
Can I upload an Excel file?
No, only CSV. In Excel, choose File, then Save As, and pick CSV UTF-8. Then upload the .csv file.
Why do my imported prospects not show on the map?
A prospect needs latitude and longitude to get a map pin. Rows with only an address still import and appear in the Prospect List, but not on the map. Add Latitude and Longitude columns to your file to place them.
Updated October 30, 2026