Getting started

How to import your clients and price book

Move your customer list, price book and open estimates into Chalk from a CSV file, and see what comes across.

Updated By Adrian Gluchowski6 min read

On this page

Go to Settings > Data and use the Bring it in cards to load your clients, your price book or your open estimates from a CSV file. Every import shows a Preview first, and nothing is added until you press Import. Only the owner and admins can run them.

Coming from paper? See Move from paper or spreadsheets. From another app? See Switch to Chalk from another CRM.

What you can bring in

CardFromWhat comes in
Import clients from another CRMAn export file from Jobber, Housecall Pro, ServiceTitan, QuickBooks or Google Contacts, or any spreadsheetNames, company, email, phones, service and billing addresses, lead source, tags
Import a price bookSet up for the columns in an export file from Housecall Pro; you can match any CSV by handName, description, unit, price, cost, category, taxable
Import open estimatesSet up for the columns in an export file from Housecall Pro; you can match any CSV by handOne draft quote per row, with its client

The file needs a header row. If yours is an Excel file, save it as CSV first.

Import your clients

  1. Go to Settings > Data and find Import clients from another CRM.
  2. Under Where is it coming from?, pick where the file came from. This only changes how Chalk guesses the columns.
  3. Press Choose CSV file and pick your file.
  4. Chalk guesses which column is which. Check each box, and set anything that is not in your file to Not in this file. The boxes are grouped as Contact, Service address, Billing address (if different), and Other.
  5. Press Preview. It shows how many are new, how many already exist, and how many rows are unusable.
  6. Press Import to add them.

A file over 500 rows goes in 500 at a time. After each page, press Preview next page.

How Chalk decides who is already in your book:

  • A row with the same phone or email and the same name as someone in Chalk attaches to that person. Their name, number and address are never overwritten by a blank cell. Empty fields get filled, and missing phones, emails and addresses are added.
  • A row whose phone or email belongs to someone with a different name comes in as its own client (a couple on one landline, say). Preview lists those rows so you can check them.
  • A row with no phone or email matches on name plus address.
  • A row with no name is skipped.

Importing the same file twice is safe: the second time, everyone matches. Tags in the file are added to each client, and any tag you do not have yet is created. A blank lead source becomes "Imported".

Which imported numbers get texts

Chalk only texts numbers it believes are mobiles, because a text to a landline fails quietly and texting is the customer's consent. The card spells out the rule:

  • A number in a Mobile or Cell column, or marked Mobile in the file, takes texts.
  • If the file has one plain Phone column and no Mobile column, those numbers take texts too, the same as adding a client by hand.
  • Home, Work and Other numbers come in marked no texts. So does a plain Phone or Main number when the file also has a Mobile column, or has more than one plain phone column.
  • Fax columns are never picked.

A number that does not take texts shows no texts beside it on the client's page. Automatic texts, and quotes and invoices sent by text, skip it: they go to a number on the client that takes texts, or by email when there is none. To text one of those numbers later, open the client, press Edit, remove the number and add it again under Add a phone. A number you add by hand takes texts.

Importing an export file from Jobber

Pick Jobber under Where is it coming from? and choose the clients CSV file you exported from Jobber. With Jobber picked, Chalk guesses the column matching for you; check the boxes before you press Preview. Chalk can map:

  • First name, last name, company name and email
  • Mobile, main, home, work and other phone numbers. Fax columns are never picked
  • The property (service) address: street, street 2, city, state, zip, country and property name
  • The billing address, kept apart from the service address
  • Lead source and tags

If the same client is on several rows with different addresses, Chalk attaches every address to that one person instead of making copies.

Chalk's import does not bring over anything else from that file: no jobs, visits, quotes, invoices, payments, notes, custom fields or photos. Chalk's price book and estimate imports are built around the columns in an export file from Housecall Pro, so to move a price list, use Import a price book and match its columns by hand.

Import a price book

  1. Under Import a price book, press Choose CSV file.
  2. Match Name, Description, Unit, Price, Cost, Category and Taxable to your columns.
  3. Press Preview, then Import.

Rows with no name are skipped, and so are rows priced over $1,000,000 a unit (usually a total column matched as the price). Units like "sf", "lf", "hr" and "gal" become square feet, linear feet, hours and gallons; anything else becomes "each". A category with "product", "material" or "part" in it becomes a product, and everything else a service. Taxable is yes when the cell says yes, true, 1, y or taxable.

Prefer to start from scratch? The Price book tab has a link, Add starter names for this trade (it names your trade), which adds the usual names without touching your prices.

Import open estimates

Import open estimates turns each row into a draft quote in Chalk with one line, priced at the line price or, if that is blank, the total. Nothing is sent and nothing is marked paid. Rows whose status says they are closed, such as paid, invoiced, declined, cancelled, expired or won, are skipped.

Each estimate finds its client the same way the client import does, and makes a new client when there is no match. A row that could belong to more than one client is left out, and Preview lists it so you can add it by hand.

After the import

New addresses get a map pin when you save them, but imported ones may not. Press Pin unpinned addresses on the Map pins card under Settings > Data to place them on the map. Keep the page open while it runs; a couple of thousand take a few minutes.

Want to try Chalk before your real list goes in? The Sample data card on the same tab has Add a sample quote, which adds one example client and a draft estimate. Remove sample data takes them out again.

Good to know

  • Owner and admins only. The Data tab is in Settings, which nobody else opens.
  • CSV only, with a header row. Save an Excel file as CSV first.
  • Client imports are safe to repeat. People already in Chalk are matched, never copied, and blank cells never overwrite what you have.
  • Price book imports are too. A row whose name and unit match an item you already have is skipped.
  • Imported clients are clients, not leads, and nothing is sent to them when they come in.
  • Chalk does not import jobs, visits, invoices, payments, notes, custom fields or photos from another system.