Skip to main content
All CollectionsBatchLeadsMy Lists
How to Import your Spreadsheet
How to Import your Spreadsheet
Ben Self avatar
Written by Ben Self
Updated over a month ago

Interactive Demo

If you'd like to import a list you've obtained outside of BatchLeads into your account, you've come to the right place! The guide below will show you where to do this and how to import your excel spreadsheet or .csv file properly. It's important you take careful notice to the file you'd like to import and what to look out for to ensure a smooth import.

Full Video Walkthrough

Written Article

Start by going to your menu on the left and clicking "My Lists". There will be blue button near the top right hand corner you'll select next that says "import properties" where you can choose to import a single address or an entire list with "bulk import". (shown in image below)

The photo below shows where you'll be routed if you choose "bulk import" and you'll be able to either drag and drop a file of yours or click the option highlighted largely below to select the file you'd like to import from your computer's downloads.

After finding your file, click "open" to begin downloading it. (your file MUST be in CSV/ xlsx format)

Once it has been successfully uploaded, click the blue arrow to move forward to step 2 (Mapping Data).

The first thing you'll notice is the option to "self-manage" your imported addresses.

We recommend leaving it on "No" unless you have list with specific information that may not match current tax assessor records like a probate list.

"No" : Will ensure BatchLeads takes care of updating your addresses information as new data is received from tax asssors and our other data providers. You will only be required to provide a property address in order to import.

"Yes" : Will require additional information such as a mailing address and will allow you to add a different name Etc that may not currently match tax assessors records. For example a probate list may still have the name of the deceased attached to the property, but you may want to upload the name of the relative that may inherit the property or someone else. Self managed leads will not be updated by BatchLeads as you are self managing it

"Sources fields" refer to the file you are importing and the columns of information that live within that said file. "Destination fields" refer to where you'll be plugging those columns of information into BatchLeads. There is an example image further down showing you what type of information you'll need to import. Everyone's file is different so just practice looking at your own file and how you'll need to match the data.

In the example below, the user has decided to NOT import their "Property Address" column and instead import the "Property Street" as the address.

This is an example of a "source field" file. If your file looks similar, you'll want to avoid matching a column with the entire address (column A) and instead, match the columns that have the property addresses SEPARATED by street, city, state and zip code.

​

NOTE: This is just an example. It all depends on what your file columns are named and data you have in each column. For instance, if your file has the property street in a column named "property address" that is perfectly fine to import. The whole idea is to just make sure the addresses you plan on importing are separated, no matter what the columns are named.

After matching the address columns, scroll down and continue matching the phone number and email columns (only applicable if you have already skip traced the properties you're importing) then click the blue arrow icon at the bottom to move

forward.

Now you'll need to save it to an existing or new list and tag. In the example below, the user is importing a list of low equity properties in Arizona, so they have placed it in their "Low Equity" master lists (we think of these as your master filing cabinets) and under a new tag that is specific to this list name "Low Equity, AZ - Aug 2024" (we think of tags as the file folders you place into your master filing cabinets).

A good Practice is having your Lists named after a broad point and then naming your Tags in a way that indicates exactly what types of properties are in that folder. (Example: The area or market you obtained the list from, specific pain points or filters used to pull the list and the date).

Click submit at the bottom.

The system will automatically route you to your Export/Import Reports in your menu and show you the progress of the file you imported and a blue checkmark will show under "status" once it's been finished!

Once it's complete, all of your successfully imported property addresses will appear in "My Lists" in the menu.


​

Did this answer your question?