Bulk-import bookings from a .xlsx file (useful for migrating from another system) and export your booking list to CSV for reporting or backup.

Import & Export bookings

Two features in the top right of Booking Manager: bulk-import bookings from an Excel file, and export your booking list to CSV.

Part 1 — Import bookings

Step 1 — Open the Import modal

Go to Booking Manager → click + Import in the top right.

Step 2 — Download the template, fill in data, upload

1. Click the "sample template" link to download the Excel template.
2. Open the template and fill in the data. Common columns:

• Service (must match an existing service name)
• Customer name / email / phone
• Start date / End date (YYYY-MM-DD)
• Quantity, Status, Total price, Payment method

3. Click Add file or drag a .xlsx file into the upload area.
4. Click Import in the bottom right.

File requirements: .xlsx · Max size 5 MB.

Part 2 — Export to CSV

How to export

1. Go to Booking Manager.
2. Apply filters as needed (Service / Status / Date range / Booking type).
3. Click Export to CSV in the top right.
4. The CSV file downloads to your computer.

Export respects the active filters — only currently displayed bookings are exported.

CSV format — common columns

booking_id, service_name, customer_name, customer_email, start_date, end_date, quantity, total_price, paid_amount, payment_method, status, created_at, updated_at.

Unicode encoding error in Excel

Encoding issue when the file contains special characters (Vietnamese, Chinese, accented characters...):

• Open with Google Sheets — UTF-8 by default.
• Or in Excel: Data → From Text/CSV → File origin: 65001 (UTF-8).

Updated on: 12/05/2026