From 17Hats, HoneyBook, Dubsado, Flodesk, Mailchimp, Studio Ninja, or a spreadsheet you’ve kept for eleven years. It’s the same job either way.
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 ↓
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 from | Where to look |
|---|---|
| 17Hats | Contacts (or Leads), the gear icon top right, then Export Contacts |
| HoneyBook | Contacts, then export |
| Dubsado | Clients, then export to CSV |
| Flodesk / Mailchimp | Audience or subscribers, then export |
| Google Contacts | Export, choosing Google CSV |
| A spreadsheet | File → 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.
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.
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.
Small tick boxes, and they matter more than they look.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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. 🤍