Skip to main content
All CollectionsUsing JicooManage Booking Pages
How to download the guest information on the booking page in CSV format? How to resolve garbled characters
How to download the guest information on the booking page in CSV format? How to resolve garbled characters
Updated over 2 months ago

How to export CSV from the booking page

You can export the guest information accepted on the booking page and the booking information in CSV format.

Click "Booking Page" > "Share" to display the sharing menu, then select the "CSV Export" tab and click "Start export" to export the CSV.

When the “CSV Export” tab is selected in the “Share” menu.

Click “Start export” to export CSV of booking information and guest information.

How to export CSV from the list of bookings

1. Narrow down the list of bookings to be exported from the list of bookings.

(Capture: Filtering criteria)

2. Click the “Export” icon in the upper right corner of the screen.

(Capture: “Export” icon circled in red)

3. Click “Start export” on the screen that appears.

(Capture: Share Menu > CSV Export “Start Export” button circled in red)

You can download it in a batch in zip format.


CSV of booking information

The following information can be confirmed.

Booking ID

Appointment name

Host name

Group ID

Group name

Guest ID

Guest Name

Email Address

Guest Time Zone

Appointment Start Time

Booking End Time

Location

Booking creation time

Booking Cancellation Time

Who cancelled the booking

Reason for booking cancellation

Settlement amount

Settlement Currency

Meeting Notes

UTM Campaign

UTM Source

UTM Medium

UTM Content

UTM Term


CSV of Guest Information

The following information is available

Time Stamp

Name

Email address

Company name

Booking start time

Additional questions below


How to get CSV file when CSV export has more than 200 data

If there are more than 200 items of data to be exported to CSV from the list of booking pages or the list of bookings, you can download the CSV file from the download link sent in the e-mail. You can also download the CSV file from Notification > Inbox.

Access the download link from the email and obtain the CSV file

An email for downloading the CSV file will be sent to the user's email address.

Please click here for information on setting up the user's e-mail address.

The CSV file can be obtained by following the steps below. (*Note that the CSV file cannot be downloaded after 3 days from the date of CSV data creation.)

1. Click “Download Page” to display the CSV download page.

(Capture: E-mail for downloading CSV file “Go to download page” is surrounded by a red frame)

2. Click the “Download” button to download the CSV file.

(Captured: CSV download page “Download” button is surrounded by a red frame)

Access the download link from your Inbox and obtain the CSV file

CSV files can be obtained by following the steps below. (Note that you will not be able to download the CSV file after 3 days from the date the CSV data was created.)

1. Click the “Notification” icon in the lower left corner of the screen to open your inbox.

(When you export CSV from the list of booking pages, the title of the booking page will be displayed in the notification. If you exported the CSV from the list of bookings, the title of the booking page will not appear in the notification).

(Capture: Dashboard screen, notification icon circled in red)

2. Click “Download Page” to display the CSV download page.

(Capture: CSV download page)

3.Click “Download” button to download the CSV file.

(Capture: CSV download page, “Download” button is surrounded by a red frame)


CSV is garbled

Depending on your device's character encoding settings, some characters may be garbled when downloading CSV files.

Please check how to solve this problem by searching.

Did this answer your question?