Export your Housecall Pro data

Prev Next

Overview

If you're migrating your business data from Housecall Pro, you can get started with ServiceTitan faster by exporting and then importing your data to ServiceTitan during onboarding. Instead of manually reentering information about your customers and jobs, ServiceTitan can automate this process for you, saving you time and money.

To import your Housecall Pro data into ServiceTitan, first export these reports from Housecall Pro:

  • Customers report—Data about your customers. Includes details like customer names, their contact information, and notes you've made about them. Exported report filename: customers.xlsx.

  • Jobs data report—Data about your existing jobs. Includes details like invoice numbers, the customer for whom the job was performed, line items, and more. Exported report filename: jobs.xlsx.

  • (Optional) Estimates data report: Data about your estimates. Includes details like invoice numbers, the customer for whom the job was performed, line items, and more. Exported report filename: estimates.xlsx.


    Check out the video for help exporting your Housecall Pro data.


Who uses this feature

  • Administrators

  • Applies to all business types

  • Applies to all trades

Things to know

  • If you have multiple addresses on file for some of your customers, your exported customers report will include additional sets of address columns.

  • If you receive an error when trying to run these reports, try to run them in one year batches. If you still receive an error after running a one year batch, reach out to the software provider for assistance.

Export the customers’ report

  1. In Housecall Pro, go to the Customers tab.

  2. Click More and select Download customer list from the dropdown. User interface showing customer management options and a download feature for customer lists.

  3. Choose Send me the file and enter your email address.

  4. Go to your email Inbox, open the message from Housecall Pro, and download customers.xlsx.

Export the jobs report

  1. In Housecall Pro, go to the dashboard and click See all jobsUpcoming jobs section with a button to see all available jobs.

  2. Set the Date Range filter to when you first started using Housecall Pro to today's (current) date. 

  3. In Table Columns, select all items.

  4. Click the Excel icon to download jobs.xlsx.

Export the estimates report

  1. Go to the dashboard and under Open Estimates click See all estimatesList of open estimates with highlighted option to see all estimates.

  2. Set the Date Range filter to when you first started using Housecall Pro to today's (current) date.

  3. In Table Columns, select all items.        

    Note: Make sure to change the Estimate column to say Invoice.

  4. Click the Excel icon to download estimates.xlsx.

Housecall Pro report columns

When importing Housecall Pro data into ServiceTitan, the columns in each XLSX file must be in the order listed below. If you receive an error when importing your data, verify that the spreadsheet columns appear in the correct order.

customers.xlsx

  1. First Name

  2. Last Name

  3. Mobile Number

  4. Email

  5. Company

  6. Job Title

  7. Work Number

  8. Tags

  9. Notes

  10. ID

  11. Address_1 Street Line 1

  12. Address_1 Street Line 2

  13. Address_1 City

  14. Address_1 State

  15. Address_1 Postal Code

  16. Address_1 Billing?

  17. Address_1 Notes

  18. Address_1 Street Line 1

  19. Address_1 Street Line 2

  20. Address_1 City

  21. Address_1 State

  22. Address_1 Postal Code

  23. Address_1 Billing?

  24. Address_1 Notes

jobs.xlsx

  1. Invoice

  2. HCP Id

  3. Created At

  4. Date

  5. End Time

  6. Travel Duration

  7. On Job Duration

  8. Total Duration

  9. Customer

  10. First Name

  11. Last Name

  12. Email

  13. Company

  14. Mobile Phone

  15. Home Phone

  16. Customer Tags

  17. Address

  18. Street

  19. Street Line 2

  20. City

  21. State

  22. Zip

  23. Description

  24. Line Items

  25. Amount

  26. Labor

  27. Materials

  28. Subtotal

  29. Payment History

  30. Credit Card Fee

  31. Paid Amount

  32. Due

  33. Discount

  34. Tax

  35. Taxable Amount

  36. Tax rate

  37. Job Tags

  38. Notes

  39. Employee

  40. Job Status

  41. Finished

  42. Payment

  43. Invoice Sent

  44. Window

  45. HC Job

  46. Tip Amount

  47. Online Booking Source

estimates.xlsx

  1. Invoice

  2. HCP Id

  3. Created At

  4. Date

  5. End Time

  6. Travel Duration

  7. On Job Duration

  8. Total Duration

  9. Customer

  10. First Name

  11. Last Name

  12. Email

  13. Company

  14. Mobile Phone

  15. Home Phone

  16. Customer Tag

  17. Address

  18. Street

  19. Street Line 2

  20. City

  21. State

  22. Zip

Want to learn more?