Importing and Exporting Contacts
If you already have a buyer list in a spreadsheet or another tool, you can bring it into Deal Run with a CSV file. You can also download your list as a CSV. This article covers both, plus deleting contacts in bulk, buyer statuses, and the Zapier integration.
Preparing your CSV
Most spreadsheet apps (Google Sheets, Excel, Numbers) and most CRMs can save or export a file as CSV. Before you import, check these things:
- The first row must be a header row (column names, not data), followed by at least one row of data.
- Every row needs a name. Deal Run uses the Investor / Entity Name column first. If that is empty, it uses First Name plus Last Name. If those are empty, it uses Company, and then Email. A row with none of these is skipped, so an email address alone is enough to identify a contact.
- Blank rows are ignored. Commas, quotation marks and line breaks inside a quoted cell are handled correctly.
Deal Run can import seven fields: Investor / Entity Name, First Name, Last Name, Phone, Email, Company and Investor Type. Any other column in your file is ignored. To start from a ready-made file, click Download template CSV in the import window. It has these headers: Investor Name, First Name, Last Name, Phone, Email, Company, Investor Type.
Deal Run fills in the mapping for you when a header matches one of the names below. Capitalization does not matter, but spelling and spacing do (for example, "phone number" matches but "phone_number" does not).
- Investor / Entity Name: investor name, entity, name, buyer name, investor_name, entity name
- First Name: first name, first_name, first, fname
- Last Name: last name, last_name, last, lname
- Phone: phone, phone number, cell, mobile, telephone
- Email: email, email address, e-mail
- Company: company, company name, org, organization
- Investor Type: type, investor type, investor_type, buyer type
If your headers are named something else, you pick them by hand on the mapping screen, so you do not need to rename anything in your file.
Importing the file
- Open Buyer List from the sidebar (under Buyers).
- In the row of controls above the list (next to + Add), click the Import CSV icon. If your list is empty, there is also an Import CSV button in the middle of the page.
- In the Import Buyers from CSV window, drop your file onto the box that says "Drop a CSV file here or click to browse", or click the box and choose the file. Only .csv files are accepted.
- On the Map Columns screen, you will see a line such as "Found 250 rows with 8 columns." Below it is one row for each of the seven Deal Run fields, each with a dropdown listing the headers from your file. A field with no matching header is set to "— Skip —". Change any dropdown to the header you want to use for that field.
- Optional: type a word or phrase in the Tag all buyers box (up to 50 characters) to put the same tag on every buyer from this file, for example the name of the group you got them from.
- Look at the preview. It shows the first three rows of your file, using only the fields you mapped, and it updates as you change the dropdowns. If a name appears in the email column or a phone number appears in the wrong place, fix the dropdowns before you continue.
- Click the import button, which shows your row count (for example, "Import 250 Buyers"). The import button stays disabled until at least one of the name sources (Investor / Entity Name, First Name, Last Name, Company or Email) is mapped.
A few details about how the values are read:
- Investor Type is sorted into flipper, landlord or both. A value containing "flip" or "fix" becomes flipper. A value containing "landlord", "rental", "rent", "hold" or "BRRRR" becomes landlord. The word "both", or a value that mentions both kinds, becomes both. Anything else, or a blank cell, becomes landlord.
- If a Phone cell is longer than 20 characters (for example, two numbers in one cell), Deal Run keeps the first number as the phone and saves the whole original cell in that buyer's notes.
- Imported buyers start with the status New, and their source shows as "CSV import" in the side panel.
When the import finishes, the last screen says how many buyers were imported. That number is the number of rows in your file, so it can be higher than the number of buyers actually added if some rows were duplicates or had no name.
Duplicates
If a row has the same name as a buyer already on your list, that row is skipped and the existing buyer is not changed. Nothing is merged or updated. Matching is on the exact name only, including capitalization, so "Smith Holdings LLC" and "Smith Holdings, LLC" are treated as two different buyers. Email and phone are not compared. If the same name appears twice in one file, only the first row is added.
What is not imported
- Notes, status, and any address, city, state or zip columns.
- A second phone number. Only one Phone column can be mapped.
- Tags from a column in your file. You can add one tag to the whole import with the Tag all buyers box, but there is no way to map a tags column.
You change a buyer's status after import in the side panel.
Exporting your buyer list
Exporting is available on the Analyze and Analyze + Sell plans. It is not available until you have a paid plan: you will see "Export failed." if you try.
- Open Buyers.
- In the row of controls above the list, click the Export CSV icon.
- Your browser downloads a file named buyers.csv.
The export always contains your whole buyer list. Filters, tabs and selected rows do not change it. Deleted contacts are left out, and the file holds up to 10,000 buyers, with VIPs first and then the rest by name. A buyer who is a known TCPA litigator stays in the file, but the Phone and Email cells for that buyer are blank.
The file has these 22 columns: Investor Name, First Name, Last Name, Company, Phone, Email, Do Not Call, Type, VIP, Status, Touchpoint, Notes, Last Contacted, Outreach Count, Subject Address, Subject City, Subject State, Subject Zip, Owned Address, Owned City, Owned State, Owned Zip.
- Do Not Call says Yes when the buyer's phone number is on a do-not-call list.
- Subject columns hold the address of the deal the buyer was saved from.
- Owned columns hold the address of the investor's property that matched your search.
- Status shows the stored status name (for example, walkthrough_scheduled), not the label you see in the app.
The export does not include tags, buy box, phone type, email status, source, date added, offers made, deals closed or the activity history for each buyer.
Deleting several contacts at once
Deleting is the only bulk action in Deal Run. There is no bulk tagging, bulk status change or exporting of selected rows.
- On the Buyers page, click Select in the row of controls. Checkboxes appear next to each buyer.
- Tick the buyers you want to remove. In table view, the checkbox in the header selects every buyer currently shown. In either view, the Select all on this page (N) link in the bar at the bottom does the same. There is no Shift-click range selection.
- A bar at the bottom of the screen shows how many are selected, with Cancel and Delete (N) buttons. Click Delete (N).
- Confirm in the "Delete N contacts?" window. It warns that this can't be undone, and that the contacts are removed from your buyer list and will not be included in future blasts.
Deleted contacts are hidden from your list and left out of exports. If you add or import the same name again later, Deal Run creates a new record, without the old buyer's status or notes.
Buyer statuses
You change a buyer's status one buyer at a time, in the side panel that opens when you click a buyer. To see only buyers with a certain status, use the status dropdown (it starts on "All Status") in the toolbar. The statuses are:
- New: the starting status for every new or imported buyer
- Interested
- Walkthrough: a walkthrough is scheduled
- Walked: the walkthrough is done
- Offer: an offer was received
- Contract
- Closed
- Pass: not interested
- Wrong Info
Zapier
Deal Run has a Zapier integration that sends information from Deal Run to the other apps you use, such as a Google Sheet or a Slack channel. It does not sync your whole buyer list. It sends these events (called triggers in Zapier):
- Investor Exported: fires when you select investors on Find Buyers and click Push to CRM.
- New Offer Received: a buyer submits an offer on one of your deal pages.
- New Showing Request: a buyer asks for a showing.
- New Inquiry Received: a buyer sends a question on your deal or marketplace page.
- Deal Stage Changed: one of your deals moves to a new stage in your pipeline.
There is no trigger for a new buyer added to your list, a change in a buyer's status, or a finished skip trace.
To set it up:
- Open Account, then Integrations.
- In the API Key section, click Generate API Key and copy the key. It is shown only once. If you generate a new key later, the old one stops working.
- Click the Install Deal Run on Zapier invite link and accept it in Zapier. This adds Deal Run to the apps you can choose from in Zapier.
- In Zapier, create a Zap, choose Deal Run as the trigger, pick one of the events above, paste your API key when asked, and map the fields to the app you are sending to.
Active Zaps are listed under Connected Webhooks on the Integrations page, where you can disconnect them.
Push to CRM requires an active Analyze or Analyze + Sell plan. It needs a paid plan.
Tips for a clean buyer list
- Check names before you import. Duplicates are detected only by exact name, so make the names in your file match the way they appear on your list.
- Use the tag box for groups. If you import from several sources, import each file separately and put the source in the Tag all buyers box.
- Update statuses after each outreach session. If every buyer is still marked New, the status filter won't tell you much.
- Export a backup now and then. Your data is stored in Deal Run, and a periodic buyers.csv is an easy extra copy. Remember that it leaves out tags, activity history and the other items listed above.