All Collections
Uploading Data
Upload Prep
How to Prepare Your Files for Uploading
How to Prepare Your Files for Uploading

A Step-by-Step Guide to prepping your csv files for uploading

Kylie avatar
Written by Kylie
Updated over a week ago

In this article, we will guide you through the process of preparing your CSV (Comma-Separated Values) file for uploading to our platform.
​
We'll show you how to properly prep your data so you can standardize this process for all future uploads.

Please note: files must be .csv file type in order to upload

Understanding Data Standardization

Each data provider labels their column headers slightly different and provides different information. Some may provide more information than you need, while others might be missing some information for uploading, or for the records to be considered clean.
​
Please see the REISift Upload template below.

Template:

REISift CSV Template - Please make a copy of the template


​The template is broken down into three sheets:

  1. Records without numbers or non-skip traced data

  2. Records with numbers or skip traced data

  3. All possible fields to upload to

Mandatory Columns for Uploading

When uploading new data (Adding to a new or existing list) the following columns are required:

  • Property Street Address

  • Property City

  • Property State

  • Property ZIP Code

  • Mailing Street Address

  • Mailing City

  • Mailing State

  • Mailing ZIP Code

Even if you don't have all the address information, you can still upload the records. The columns are required, but the information can be left blank. We recommend cleaning your list as much as possible before uploading, but missing mailing addresses won't be an issue. You can always add them later.
​


We can populate some missing address information on upload:

  • If you have the correct Street Address, City, and State, we can typically populate the ZIP Code.

  • If you have the correct Street Address, State, and ZIP Code, we can populate the City.

Requirements for Clean Records

For records to be considered clean, they must include the following information in separate columns:

  • Owner's First Name

  • Owner's Last Name

  • Mailing Address, City, State, & Zip

  • Property Address, City, State, & Zip

Records missing this information can still be uploaded but will be located under the incomplete tab after uploading. For entities like LLCs or trusts, where the owner's names may be unavailable, the missing information can be added later, but cleaning the file before uploading is recommended.

For more on incomplete records please see -->> Clean vs. Incomplete Data
​

Uploading Skip Traced Data

If your records have already been skip traced, check out the "Records with numbers" sheet in the template. Include separate rows for each phone number and phone type (if available).

Phone Types:

  • Unknown

  • Mobile

  • Landline

  • VoIP

Additionally, phone statuses and tags can be added during the upload process. If you know which phone numbers are Do Not Call (DNC), correct, wrong, or dead, include phone status columns next to each phone number column.
​
​Phone Statuses:

  • Correct

  • Correct DNC

  • Wrong

  • Wrong DNC

  • Dead

  • No Answer

  • DNC

  • Unknown (this will be the default phone status for any phone numbers that are not uploaded with a status)

Phone tags allow you to add additional information such as "relative," "husband," "wife," or to tag DNCs as "litigator" when scrubbing against Do Not Call lists. These tags are fully customizable, enabling you to create any phone tag that fits your processes.
​
​

All Upload Fields

To view all fields we can upload to, please see the All Fields sheet in the template or review the data requirement fields towards the end of this article.
​
If the columns are labeled as shown from the template, we can auto-map the following fields:

  • Owner's First Name

  • Owner's Last Name

  • Property Address, City, State, & Zip

  • Mailing Address, City, State, & Zip

  • Status/Property Status

  • Emails

  • Phone Numbers

  • Phone Tags

  • Phone Type

  • Phone Status

By following these steps and using our template, you can efficiently prepare your CSV file for uploading, ensuring that your data is organized, standardized, and ready for seamless integration into our platform. If you have any further questions or need assistance, feel free to reach out to our support chat.
​
🤠 Happy uploading! 🤠
​

Data Requirements Reference for All Fields

Owner Fields

First Name

  • Type: Text

  • Max length: 128 chars

Last Name

  • Type: Text

  • Max length: 128 chars

Company

  • Type: Text

  • Max length: 128 chars

Address

street

  • Type: Text

  • Max length: 128 chars

city

  • Type: Text

  • Max length: 128 chars

state

  • Type: Text

  • Max length: 128 chars

postal code

  • Type: Text

  • Max length: 128 chars

county

  • Type: Text

  • Max length: 128 chars

Phones

number

  • Type: Text

  • Max length: 32 chars

  • Valid format examples:

    • +18505379827

    • +1 (850) 537-9827

    • +1 (850) 5379827

    • +1 850-537-9827

    • (850)537-9827

    • (850)5379827

    • (850) 537-9827

    • (850) 5379827

    • 850-537-9827

    • 850-537-9827

    • 8505379827

type

  • Type: Text

  • Valid types:

    • UNKNOWN

    • LANDLINE

    • MOBILE

    • VOIP

status

  • Type: Text

  • Valid types:

    • UNKNOWN

    • CORRECT

    • CORRECT_DNC

    • WRONG

    • WRONG_DNC

    • DEAD

    • NO_ANSWER

    • DNC

tags

  • Type: Text List

  • Max length: 128 chars/each

type

  • Phone List

limit

  • 10

Emails

  • Type: Text List

  • Limit: 10

  • Max length: 256 chars/each

Owner Deceased

  • Type: Boolean Field

  • Valid values:

    • true

    • false

    • 0

    • 1

    • Yes

    • No

    • Y

    • N

Property Fields

Status

  • Type: Text

  • Max length: 32 chars

  • Options

    • lead

    • sold

    • not_interested

    • dnc

    • opt_out

    • listed

    • follow_up

    • prospecting

    • buyer

    • under_contract

    • underwrite

    • transactions

    • push_deal

    • buyer_found

    • buyer_lost

    • close_out

    • lost_deal

    • closed

    • refer_lead

Notes

  • Type: Text Field

Address

street

  • Type: Char Field

  • Max length: 128 chars

city

  • Type: Char Field

  • Max length: 128 chars

state

  • Type: Char Field

  • Max length: 128 chars

postal code

  • Type: Char Field

  • Max length: 128 chars

county

  • Type: Char Field

  • Max length: 128 chars

Tags

  • Type: Text List

  • Max length: 256 chars/each

Lists

  • Type: Text List

  • Max length: 256 chars/each

Bedrooms

  • Type: Positive Integer

  • Minimum value: 0

Bathrooms

  • Type: Float

  • Examples:

    • 1.5

    • 2

Sqft

  • Type: Float

  • Examples:

    • 5.45

    • 122.54

Air Conditioner

  • Type: Text

  • Max length: 128 chars

Heating Type

  • Type: Text

  • Max length: 128 chars

Storeys

  • Type: Float

  • Examples:

    • 1.5

    • 2

Year

  • Type: Positive Integer

  • Minimum Value: 0

Above Grade

  • Type: Float

  • Examples:

    • 1.5

    • 2

Rental Value

  • Type: Decimal

  • Decimal places: 2

  • Max digits: 10

Building Use Code

  • Type: Text

  • Max length: 256 chars

Neighborhood Rating

  • Type: Float

  • Examples:

    • 3.5

    • 5

Structure Type

  • Type: Text

  • Max length: 128 chars

Apn

  • Type: Text

  • Max length: 128 chars

Parcel ID

  • Type: Text

  • Max length: 256 chars

Legal Description

  • Type: Text

Lot Size

  • Type: Float

  • Examples:

    • 4.45

    • 1232.54

Land Zoning

  • Type: Text

  • Max length: 128 chars

Tax Auction Date

  • Type: Date

  • Valid formats:

    • MM-DD-YYYY

    • MM/DD/YYYY

    • YYYY-MM-DD

    • YYYY/MM/DD

Total Taxes

  • Type: Decimal

  • Decimal places: 2

  • Max digits: 20

Tax Delinquent Value

  • Type: Decimal

  • Decimal places: 2

  • Max digits: 20

Tax Delinquent Year

  • Type: Positive Integer Field

  • Minimum value: 0

Year Behind On Taxes

  • Type: Positive Integer Field

  • Minimum value: 0

Deed

  • Type: Text

  • Max length: 128 chars

MLS

  • Type: Text

  • Max length: 128 chars

Last Sale Price

  • Type: Decimal

  • Decimal places: 2

  • Max digits: 20

Last Sold

  • Type: Date

  • Valid formats:

    • MM-DD-YYYY

    • MM/DD/YYYY

    • YYYY-MM-DD

    • YYYY/MM/DD

Estimate Value

  • Type: Decimal

  • Decimal places: 2

  • Max digits: 20

Lien Type

  • Type: Text

  • Max length: 128 chars

Lien Recording Date

  • Type: Date

  • Valid formats:

    • MM-DD-YYYY

    • MM/DD/YYYY

    • YYYY-MM-DD

    • YYYY/MM/DD

Personal Representative

  • Type: Text

  • Max length: 128 chars

Personal Representative Phone

  • Type: Text

  • Max length: 32 chars

  • Valid format examples:

    • +18505379827

    • +1 (850) 537-9827

    • +1 (850) 5379827

    • +1 850-537-9827

    • (850)537-9827

    • (850)5379827

    • (850) 537-9827

    • (850) 5379827

    • 850-537-9827

    • 850-537-9827

    • 8505379827

Probate Open Date

  • Type: Date

  • Valid formats:

    • MM-DD-YYYY

    • MM/DD/YYYY

    • YYYY-MM-DD

    • YYYY/MM/DD

Attorney On File

  • Type: Text

  • Max length: 128 chars

Foreclosure Date

  • Type: Date

  • Valid formats:

    • MM-DD-YYYY

    • MM/DD/YYYY

    • YYYY-MM-DD

    • YYYY/MM/DD

Bankruptcy Recording Date

  • Type: Date

  • Valid formats:

    • MM-DD-YYYY

    • MM/DD/YYYY

    • YYYY-MM-DD

    • YYYY/MM/DD

Divorce File Date

  • Type: Date

  • Valid formats:

    • MM-DD-YYYY

    • MM/DD/YYYY

    • YYYY-MM-DD

    • YYYY/MM/DD

Loan To Value

  • Type: Decimal

  • Decimal places: 2

  • Max digits: 10

Open Mortgages

  • Type: Positive Integer

  • Minimum value: 0

Mortgage Type

  • Type: Text

  • Max length: 128 chars

Owned Since

  • Type: Date

  • Valid formats:

    • MM-DD-YYYY

    • MM/DD/YYYY

    • YYYY-MM-DD

    • YYYY/MM/DD

Related Trainings:

Clean vs. Incomplete Data

Explaining the Swap Owners Upload Option
​Difference between Update Data and Add Data


Did this answer your question?