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