Skip to main content
Use this to move leads from another CRM or a spreadsheet into ArcSolar. Each row becomes a customer record with a lead in the Pipeline.

Where to find it

You can start an import from two places: Select Bulk import leads at the top of the page. If you can’t see it, open the … menu next to the search bar.
The More customer actions menu open, showing Bulk import leads, Export CSV and Copy lead intake form link.

The … menu on Customer Records. Sample data.

You only see this option if your role can create customers.

Import your leads

1

Download the template

In the Bulk import leads window, select Download template. Open lead-import-template.csv in Excel, Numbers or Google Sheets.
The Bulk import leads window with CSV requirements, the Download template button and the CSV file picker.

The Bulk import leads window.

2

Add one lead per row

Keep the header row as it is. Fill in your leads using the rules below.
3

Save as CSV

Save or export the file as CSV. Excel and Numbers files (.xlsx, .numbers) are not accepted.
4

Choose a selling brand

If your workspace sells under more than one brand, pick one in Selling brand for new opportunities. You can also choose Leave unallocated.
5

Upload the file

Choose your file under CSV file. ArcSolar checks it straight away. If it shows Fix the CSV before importing, fix the listed rows and upload again.
6

Import

Select Import N leads. New leads appear in the Pipeline.

Columns

Every column in the template must be in your file, even if you leave some cells blank.
Each row needs a first name and at least an email or a phone number. If you add any part of an address, fill in street, suburb, state and postcode.

Limits

  • Up to 500 leads per file.
  • File size up to 750 KB.
  • Split bigger lists into several files.

What happens to duplicates

If a customer with the same email or phone already exists, that row is skipped. The rest still import. ArcSolar lists skipped rows under Rows not imported so you can update the existing records instead.

Who can import

See Roles and permissions.

Fix common errors

Leaving lead_source blank uses your workspace’s import or manual entry source.
Other imports: product prices and inventory have their own CSV templates.