Get set up

Import leads from a spreadsheet

In Zigaflow

The short answer

To import leads from a spreadsheet in Zigaflow, click the Cog, then Import Center, then Flexi, then Leads. Drag and drop your file, map the mandatory and optional columns, and click Next. Customers and contacts not already in Zigaflow are created during the import. You can save the mapping for later imports.

Steps

  1. Click on the Cog

    Zigaflow dashboard with the settings cog icon highlighted in the top-right toolbar, beside the notifications bell
  2. Click "Import Center"

    Settings menu with Import Center highlighted, showing import options like Suppliers, Leads, Quotations and Invoices
  3. Click "Flexi"

    Import Center settings page with the Flexi tab highlighted in the left import menu, above Items, Variants and Stock
  4. Click "Leads"

    Import Center Flexi section with the Leads tab highlighted in the sub-menu below Items, Customers and Contacts
  5. The spreadsheet can look similar to this

    Example lead import spreadsheet with columns Pipeline, Status, Customer, First Name, Second Name, Contact Email, Phone, Note
  6. Drag and drop the import file here

    Map the columns

    Flexi Import Lead step 1 of 3 with the Select Files or Drag & Drop Here upload field highlighted for the .xls or .xlsx file
  7. Map the mandatory fields in the Zigaflow to the import spreadsheet's columns

    Import Step 2 of 3 Mandatory Fields panel with the Spreadsheet Header dropdown for Client Name highlighted
  8. Map the optional fields in the Zigaflow to the import spreadsheet's columns

    Optional Fields mapping section with the empty Zigaflow Field dropdown beside the First Name spreadsheet header highlighted
  9. Click "Next" to complete the import

    Check and save the import

    Optional Fields section mapping spreadsheet headers to Zigaflow fields, with the Next button highlighted to finish the import
  10. Check the message bar for the success or failure of the import

    Flexi Import Lead step 3 of 3 showing Import Complete with message bar reading 2 Lead created, 0 Lead updated
  11. Save the mapping to re-use the column settings for later imports

    Learn more: leads in Zigaflow

    Flexi Import Lead Step 3 of 3 showing Import Complete, with

Zigaflow allows the import of leads from a spreadsheet. It will create customers and contacts not already in the system during the import, making it easy to get up and running with a new set of leads.

It will check the name of a customer/company against what already exists before creating a new record, so make sure that where the customer/company should already be in Zigaflow, the names match exactly.
​

Prepare your spreadsheet

The spreadsheet should consist of these columns at a minimum:

Pipeline - the lead pipeline.

Status - the initial status of the lead.

Customer - the customer/company. If the customer does not already exist in Zigaflow it will be created by the import process.

If a contact for the lead can be imported in the same file and if they do not exist in Zigaflow, they will be created on import. Split by full names into first and second names columns.
​

Open the leads import

Frequently asked questions

Next step

Importing contactsTo import contacts into Zigaflow, click the Cog, then Import Center, then Contacts, and drag and drop your import file. Match the columns you want to Zigaflow fields, click Next, and the import reports how many contacts were updated and how many were added. You can save the mapping to reuse it.

Was this helpful?

See Zigaflow on your own workflow

Book a demo and we will walk through quoting, jobs and purchasing the way your team runs them.

Or see how Zigaflow would fit your business, free