Guide · about 10 minutes

Load your client list, and stay in front of every past client.

Upload one file of your past clients. Every quarter, each of them gets a fresh Truppraisal Estimate on their home, from you. You see every batch and send it yourself, so nothing goes out without your OK.

All you need is a spreadsheet with name, email and home address. Square feet, beds, baths, pool and garage fill in automatically from multiple data sources.

Five steps

Do it once. After that it runs every quarter.

Export your past clients as a CSV file

Most CRMs have an export button. Pull just your past clients if you can (filter by a tag or stage like “Closed” or “Past Client”), and save the file as CSV.

Follow Up BossPeople › filter your list › tick the box at the top left and “Select All” › click the export (down arrow) icon › Export People.
BoldTrail / kvCORESmart CRM › All Contacts › filter › tick the top box › More Actions › Export Contacts. The file is emailed to you.
LoftyPeople › the three dots next to Add Lead › Lead Export › Export. Lofty emails you a download link.
Google Contactscontacts.google.com › tick the contacts or a label › Export › Google CSV.
Excel or Google SheetsExcel: File › Save As › CSV. Google Sheets: File › Download › Comma-separated values (.csv).
Starting from scratch?Download our template, type your clients in, and save it as CSV.

Column names don’t need to match ours. First Name, Last Name, Email, Phone and Address are recognized automatically, a single Name column works, and so do separate street, city, state and zip columns. Anything we don’t use is ignored.

Open your client list in Truppraisal

Sign in and click Load your client list on your dashboard. You can also find it in the menu under Load or Manage Your Client List.

Upload the file and answer two questions

  • Choose your file: pick the CSV you exported. A batch label is optional (for example “FUB past clients Nov 2026”).
  • Who are these people? Choose Past clients and write a few words on how they became clients, such as “closed sales 2018-2026, exported from Follow Up Boss.” Only past clients get mailed. Farm lists and purchased lists are kept but never emailed.
  • How often? Quarterly is the default. Semi-annual and annual are there too.

Click Load my client list.

Check the list and send yourself a test

The numbers at the top tell you how many are on the list and how many are ready to send. If some rows say they need classifying, pick All past clients for that batch and click Apply. Click Send test to me on any row to see exactly what your client will get.

Optional, for a sharper value: set each home’s condition (needs work, average, updated or fully remodeled) on the row, or add a Condition column to your file.

Review and send

Overnight, Truppraisal prepares a fresh report for every client who is due, and we email you when they’re ready. Open Ready to Send in the menu, look over the batch and click Review and send. Each client gets their home’s value with your name and contact details on it.

Good to know

  • Can I upload again later? Yes. Re-uploading the same people updates their rows instead of making duplicates, so add new closings any time.
  • What if someone doesn’t want them? Every email has an unsubscribe link, and you can pause or delete any row yourself.
  • Why only past clients? These are people who know you and expect to hear from you. That keeps your emails out of spam and your name in good standing.
  • Adding people as you go: anyone who asks for a value on their home can be added to your list right from their report, the app or your website widget.
  • Stuck? Email support@truppraisal.com and tell us which CRM you use. We’ll walk you through it.

Load my client list ›   Download the template