Skip to main content

How do I import my existing customers into SortScape?

Written by Bill Arconati
Updated over a week ago

If you are using Xero or QuickBooks Online, connecting those systems to SortScape will automatically import your customer information into SortScape.

If you don't plan to connect to Xero or QuickBooks Online, we can do a bulk import of your existing customer information from an Excel or CSV file. We cannot import Microsoft Word (.doc or .docx) or PDF files.

Please send your Excel or CSV filek to support if you wish for us to do a bulk customer import for you.

You can send the file to support either by emailing it to support@sortscape.com or by attaching to the chat conversation you already have open with support.

We require the following columns for importing:

  • Property address

  • Property city

  • Property state

  • Property post_code

  • Customer name

  • Customer email

  • Customer phone number

  • Customer company

You can also use the attached "SortScape customers import sample.xlsx" spreadsheet as a template.

Please note - We can import your customer information. However, we can’t import historical job or invoice history.

If you are wanting to import your actual schedule, we can do a one-time import of your schedule if you provide us the following information.

  • Property address – Must match exactly how it appears in SortScape (from your customer import).

  • Next visit date – ideal format: YYYY-MM-DD (e.g. 2026-01-15).

  • Start time (optional) – e.g. 09:00 for 9am.

  • End time (optional) – e.g. 17:00 for 5pm.

  • Repeating? – Yes or No.

  • Repeat frequency (if repeating) – e.g. 2 for “every 2 weeks”.

  • Estimated man hours (optional) – Decimal, e.g. 1.5.

  • Billable? – Yes or No. Yes means the visit will prompt for invoicing upon completion.

  • Work required – e.g. “Mow lawns, weed, trim hedges”.

  • Invoice line 1 – Description (if billable) – e.g. “Lawn Mowing”, “Garden Cleanup”

  • Invoice line 1 – Price (in your currency) – e.g. 100.

  • Invoice line 1 – Quantity – Number of units (typically 1).

  • Invoice line 2 (optional) – Description, Price, Quantity.

  • Invoice lines 3–5 (optional) – Same pattern if you have more lines.

You can also use the attached "Jobs import example" spreadsheet as a template.

Did this answer your question?