Using Bookare · Gyms and studios
Moving from another system
Bring your members, their packs, bookings, class history and check-ins over from your old system or spreadsheet, without emailing anyone.
If you already run your studio with another booking system, or with a spreadsheet, you do not have to start from zero. You can bring over your members, the packs they hold (with classes left and expiry dates), their bookings and class history, and past check-ins. Members keep their history and their remaining classes, and you start the next day as if nothing changed.
Nothing is emailed to anyone while you do this, and you can safely run the same file again: nothing is written twice.
You find it under Settings → Data import. Only admins can see it, and only for venues with classes.
Before you start
Set up your venue first, so the imported data has somewhere to go:
- Your class types and instructors. Use the same class names as in your old system, so bookings can find them.
- Your packs on sale.
- Your weekly timetable. Upcoming bookings can only be brought over to classes that are already on the calendar.
What you need: files from your old system
Each step takes one file, in the CSV format that every spreadsheet can save. In Excel: Save as → CSV. Google Sheets and other spreadsheets can download a sheet as CSV too.
Each step has a Download the template link: a ready file with the right column names and one example row. The easiest way is to download the template, paste your data under the right columns, and save.
- The first row must hold the column names, as in the template. Columns Bookare does not use are listed and skipped.
- Dates can be written as 2025-03-18 or 18/03/2025.
- Yes/no columns accept yes or no.
- Leave out what you do not have.
- Fill in the external_id columns with the codes from your old system. This is what lets you run a file again safely.
The four steps, in order
Go from top to bottom. Each step can find what the previous one brought over.
1. Members
All members, including former ones, with the date they joined.
| Column | What to put |
|---|---|
| external_id | The member’s code in the old system. Strongly recommended: packs and bookings use it to find the member. |
| name | Full name (required). |
| email · phone | One of the two, or the external_id. |
| street · city · postal_code | Address, optional. |
| joined | The date they joined. |
| status | active (the default), disabled for former members, or pending. |
| wants_news | yes only if they had agreed to receive offers and news. |
| groups | Group names, separated by a vertical bar, e.g. Morning group|Students. Missing groups are created. |
A member whose email already exists in Bookare is left as it is and counted as “already there”.
Members who joined in the last 90 days count towards your plan’s member limit. Former members and long-time members do not. See Plans and billing.
2. Members’ packs
The packs that are running now, with their end date and the classes already used. Old ones too, if you want them in the history.
| Column | What to put |
|---|---|
| member_external_id · member_email | Which member (one of the two). |
| name | The pack’s name. |
| classes · unlimited | How many classes it had in total, or unlimited = yes. |
| classes_used | How many were used, including those already booked for the coming days. |
| starts · expires | Start date and last valid day. |
| price_eur · paid · paid_on · method | The price, whether it was paid, when, and how (cash, card or iris). |
| off_peak_only | yes if it is for off-peak hours only. |
Give each pack an external_id too, so bookings can point to it.
3. Bookings and history
Upcoming bookings, and past ones with attendance.
| Column | What to put |
|---|---|
| member_external_id · member_email · guest_name | Which member, or a guest’s name. |
| date · time · class_type | The day, the time and the class name, written exactly as on your Classes page. |
| status | attended (the default for past classes), no_show, booked (the default for upcoming), cancelled or late_cancel. |
| pack_external_id | Which pack it was booked with. If missing, the pack that covered that day is used. |
| free · trial | yes for a free or a trial class. |
Past classes that are not on your calendar are created for you, so the history is complete. Upcoming classes must already be on the timetable.
Bringing over bookings never takes classes from packs again. The classes_used number from step 2 already counts them. The booking is still linked to the pack, so if a member cancels an upcoming one in time, the class goes back to their pack as usual.
4. Check-ins
This step appears only if you have a drop-in class type (no fixed times, check-in only, such as the gym floor). It brings over past visits, one per member and day, with the member, class, date and time. No pack is charged again.
Running a step
- Press Choose file and pick your CSV file. Bookare shows how many rows it found.
- Press Import.
- Wait while it works through the file. A large file takes a little while; keep the page open.
- Read the result, e.g. “Done. 212 new · 3 already there · 2 with errors”.
Rows with an error are listed with their line number in the file and the reason, for example a member who could not be found. Fix those lines and run the same file again: rows that were already brought over are skipped, so nothing is written twice.
A Pilates studio in Chalandri moves over on a Sunday. The owner exports her members, active packs and the next two weeks of bookings from her old system into three files, and adds the old member codes in the external_id columns. She imports members (184 new), then packs (97 new), then bookings (305 new, 4 errors: a class name was spelled differently). She renames the class in the file, imports the bookings file again (301 already there, 4 new), and opens on Monday. Nobody got an email.
After the move
- Tell your members about the new booking page. They sign in with the same email they had in your old system and find their pack, classes left and bookings waiting for them.
- Check a few members’ pages to see that packs and classes left look right.
- Members did not get any email during the move, so a short message (News) to everyone is a good way to announce it.
If your old data is messy, your AI assistant can do the move for you. Give it your old export, even an untidy one, and say:
“Bring over the members, their packs and the bookings from this file. Don’t email anyone.”
“How much have we brought over so far?”
It follows the same order and rules as this page, a hundred rows at a time, and tells you what it created and what it skipped.
Ideas
- Do a test with ten members first. Look at their pages, then run the full files.
- Move on a quiet day, after the last class, so no new bookings are made in the old system while you work.
- Use the groups column to bring over your existing teams, such as “Morning group” or “Students”.