> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.omegatheme.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# Import & Export

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

![+ Import button location in the top right](https://storage.crisp.chat/users/helpdesk/website/-/8/3/8/3/8383e5404a31c000/image_8x47cv.png)


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

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

![Import bookings modal with sample template link and Add file area](https://storage.crisp.chat/users/helpdesk/website/-/8/3/8/3/8383e5404a31c000/image_1f9o672.png)


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

![Export to CSV button next to + Import](https://storage.crisp.chat/users/helpdesk/website/-/8/3/8/3/8383e5404a31c000/image_9oldt2.png =491xauto)


### 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)**.