How do I set up my Excel data?

Setting up your Excel Data Sheet

Add the following columns to your Excel Data Spreadsheet and fill them with your information:

  •          Your_Name
  •          Your_Title
  •          Your_Company
  •          Your_Address
  •          Your_City
  •          Your_State
  •          Your_Zip
  •          Your_Phone
  •          Your_Email
  •          Your_Website
  •          Date: Fill in with =TODAY()
  •          Reference:  You can start with a random number and then use that cell plus one into the rest of the column, ie, =B3+1)
  •          Offer_Price: Your offer price for each property
  •          Closing_Date
  •          State: the state which the County is located. 

Change the Header of existing Columns:

  •          County Name changes to: County_Name
  •          Mail Address changes to: Mail_Address
  •          Mail City changes to: Mail_City
  •          Mail State changes to: Mail_State
  •          Mail ZIP Code OR Mail ZIP/ZIP+4 (whichever you wish you use) changes to: Mail_Zip_Code
  •          Owner First Name changes to: Owner_First_Name
  •          Owner Last Name changes to: Owner_Last_Name
  •          Legal Description changes to: Legal_Description
  •          Lot Acreage changes to: Lot_Acreage

Please save your data with your last name in the title!

Still need help? Contact Us Contact Us