Own any of my programs? Earn 20% on every one you own.  Join the partner program →
My Studio Books
Guide

Bringing your clients across

From 17Hats, HoneyBook, Dubsado, Flodesk, Mailchimp, Studio Ninja, or a spreadsheet you’ve kept for eleven years. It’s the same job either way.

About 10 minutes to read · 15 minutes to do

This is the first thing most people do, and it’s the bit that feels riskiest — years of client history, and you’re about to move it somewhere new.

So the important thing first: nothing imports until you say so. You choose the file, you see how many rows were found, you match up the columns, and only then does anything get added. If it looks wrong at that point, close the window and nothing has happened.

Rather hand the whole job to Claude? Export your file, paste one prompt, and Claude tidies it up, checks a couple of things with you, and runs the import. Let Claude do it ↓

Step oneGet a CSV out of your old system

Every tool worth using can export a CSV. It’s usually somewhere unglamorous — look for Export, Download, or Data under settings, contacts, or your account area.

Coming fromWhere to look
17HatsContacts (or Leads), the gear icon top right, then Export Contacts
HoneyBookContacts, then export
DubsadoClients, then export to CSV
Flodesk / MailchimpAudience or subscribers, then export
Google ContactsExport, choosing Google CSV
A spreadsheetFile → Download → comma separated values

You don’t need to tidy it first. Odd column names, columns you don’t care about, dates in an American order — all fine. That’s what the matching step is for.

One thing worth doing. Open the file and glance at the first few rows. Not to fix anything — just so you recognise it when you’re matching columns in a minute. It takes ten seconds and makes the next step much less puzzling.

Step twoMatch the columns

In MSB, go to Clients and choose Import CSV. Pick your file and it’ll tell you how many rows it found.

Then you match up: this column in my file is that field in MSB. It guesses where it can — a column called “Email Address” will already be lined up with Email. Anything you don’t want, leave on skip.

YOUR CSV MY STUDIO BOOKS First Name First name Email Address Email Baby DOB Children Lead Source ID skip Anything you don’t need, leave on skip
You can bring across names, email, phone, partner, Instagram, address, birthdays, children, and notes.

Birthdays are worth a moment. MSB will read almost any format — 1990-04-06, 4/6/1990, 6 April 1990 — and tidy them up as it goes. Bring them across if you have them: MSB will tell you when a client’s birthday is coming up, and that’s one of the easiest bookings you’ll ever get.

Step threeThe options underneath

Small tick boxes, and they matter more than they look.

Add imported clients to my newsletter list

Tick this and everyone in the file becomes a newsletter subscriber. Think before you do, because this is the one with consequences: only tick it for people who actually agreed to hear from you. Past clients, yes. A list of cold leads you bought or scraped, no — that’s how you end up in spam folders and it’s hard to come back from.

Update clients I already have

Matches on email. Instead of skipping someone who’s already in MSB, it fills in the blanks — a birthday you didn’t have, a phone number, a partner’s name. Useful when you’re importing a second file from a different source and want the two merged rather than duplicated.

Add these contacts to lists / tags

Type one or more, separated by commas. Each becomes an audience you can send a newsletter to on its own.

This is the one people wish they’d used. Import your Flodesk list tagged newsletter-only, your past clients tagged past-clients-2024, and your workshop attendees tagged education — and from then on you can write to exactly the right people instead of everyone at once.

Add these contacts to a brand

If you run more than one brand, this keeps the import tied to one of them. Handy when your photographer list and your client list want to stay firmly apart.

Add these as

Leave it on Past clients for an old client list, so years of history don’t land in your leads as people to chase this week. Use New leads (inquiries) only for people who are inquiring right now, and No status (just contacts) for everyone else.

Skip rows with no email, and skip anyone who’s unsubscribed

The first is ticked for you and keeps junk rows out — untick it if you want to keep people who have no email address. Tick the second if you’ve imported before and don’t want to re-add anyone who opted out.

Do it in more than one go

The instinct is to get everything in with one enormous file. Don’t.

Import your past clients first, tagged as past clients. Then your newsletter list, tagged separately. Then your current enquiries. Three smaller imports take the same total time, and you end up with tags that mean something instead of one undifferentiated pile of two thousand names.

Step fourCheck it landed

  1. 1Look at the count. It’ll tell you how many were added. If that number is wildly different from the rows in your file, something didn’t match — usually the email column.
  2. 2Open two or three at random. Not the first one, which is always fine. Pick from the middle. Check the birthday landed in the right field and the notes didn’t end up somewhere odd.
  3. 3Check a tag. Filter by one of the tags you set and confirm the right people are in it.

If something went wrong, the fix is usually to delete the affected clients and re-import with the columns matched differently. Not elegant, but quick — and better than living with a thousand records where the partner’s name is in the notes field.

OrLet Claude do it for you

If you use Claude, you can hand it the whole job. It tidies your file, checks a couple of things with you, then opens My Studio Books and runs the import.

You’ll need a paid Claude plan, and your computer rather than your phone: the Claude desktop app or Claude in Chrome. That’s what lets Claude work inside a website.

  1. 1Export your file. Step one above tells you where. Keep your past sessions in a spreadsheet? Have that ready too.
  2. 2Open Claude and attach it. Then paste the prompt below and send it.
  3. 3Answer its questions. Before anything is imported, it hands you the cleaned file and the counts, and asks whether your past clients go on your newsletter list and what to do with contacts that have no email.
  4. 4Sign in yourself. When My Studio Books asks you to sign in, do that part. If Claude can’t attach the file, it’ll ask you to choose it.
The prompt
I'm moving to My Studio Books (mystudiobooks.com) from another system. I've attached my contacts export, and maybe a spreadsheet of past sessions. Please clean them up and import them into My Studio Books for me.

STEP 1 — CLEAN MY CONTACTS
Make a CSV with exactly these headings, in this order:
First name, Last name, Email, Phone, Partner, Instagram, Address, Birthday, Children, Notes
- Split full names into first and last
- Put the whole address in one cell
- Birthdays as YYYY-MM-DD
- If two rows share an email, keep one and put the other name in Notes
- Put anything useful that doesn't fit (lead source, tags) in Notes
- Never make anything up. Blank stays blank.
If the file shows what kind of contact each person is (like Client, Hot Lead, Cold Prospect), make three files: clients, current leads, and everyone else.

STEP 2 — CHECK WITH ME
Give me the cleaned files and tell me how many contacts are in each, how many have no email, whether anything is missing (like phone numbers), and anything you weren't sure about. Then ask me:
- Should my past clients go on my newsletter list?
- Keep contacts with no email, or skip them?
Wait for my answers.

STEP 3 — IMPORT
- Open mystudiobooks.com. If it asks me to sign in, stop and let me do it.
- Go to Clients → Import CSV and attach the file. If you can't attach it, ask me to choose it, then carry on.
- Check every column matched (it guesses from the headings).
- "Add these as": Past clients for clients, New leads (inquiries) for current leads, No status (just contacts) for everyone else. If there's only one file, use Past clients.
- Tick "Update clients I already have".
- In "Add these contacts to one or more lists / tags", type the name of my old system (like 17hats).
- Set the newsletter box and "Skip rows with no email" the way I told you.
- Click Import clients, tell me the numbers it shows, then do the next file.

STEP 4 — SESSIONS (only if I attached them, and only after contacts)
Make a CSV with these headings: Client name, Client email, Session date, Time, Session type, Price, Status, Location, Notes
- Dates as YYYY-MM-DD, times like 2:30 PM, price as a plain number
- Status must be Inquiry, Pending, Booked, Completed or Cancelled. If a status says "Archived", use the stage to tell a finished shoot from an inquiry that never booked, and ask me if you can't tell
- Fill in Client email from my contacts so each session finds its client
Show me the counts, then go to Sessions → Import from CSV, leave it on "Don't apply a workflow" and click Import sessions.

RULES
Never send an email or apply a workflow. Never import the same file twice. If an import stops partway, tell me what happened instead of trying again.

Why those headings? They’re the names My Studio Books recognises on its own, so every column lines up without matching anything by hand.

And it sends nothing. Importing never emails anyone. The one setting that could lead to emails is a workflow on imported sessions, and the prompt tells Claude to leave that off.

Worth sayingWhat doesn’t come across

Contacts come across, and so can your sessions. The rest of your history doesn’t.

Sessions go in separately, after your clients. If you have them as a spreadsheet, go to Sessions and choose Import from CSV. Each session finds its client by email or name, and anyone it can’t find is added as a past client. For old shoots, leave it on Don’t apply a workflow, so nothing gets scheduled for families you photographed years ago.

Past invoices, old contracts and galleries you delivered in 2022 stay in your old system, and no CSV will carry them. That’s true of every CRM move, not just this one.

Which means: don’t cancel your old subscription the day you import. Keep it, or export a PDF of anything you might need — signed contracts especially — before you close the account. Give yourself a season of overlap. It costs one more month and it saves the specific panic of needing a signed agreement you can no longer reach.

Next: how workflows work — worth reading once your clients are in and you’re wondering what to do with them.

Stuck? Ask in the community. Import questions are always worth asking out loud, because someone else is coming from the same system you are. 🤍