I use Safari but my bookings export file doesn't open correctly

In this article

• Importing the file to Google Sheets
• Importing the file to Excel
• Importing the file to Numbers (Mac)

YCBM data export files cannot be opened in a Safari browser, as they will look like the screenshot below. Safari cannot format .csv files properly. To resolve this issue, open the file in Chrome, Firefox, or IE 11, and the .csv will download in the proper format, and you can open the file in your preferred spreadsheet program. 

Importing the file to Google Sheets:

1. Open Google Sheets

   • Go to Google Sheets and log in.

2. Create or Open a Spreadsheet

   • Start a new blank spreadsheet or open an existing one.

3. Import the CSV File

   • Click "File" > "Import" and open the Import File dialog.

4. Upload the CSV File

   • Choose "My Drive" for Google Drive files, "Shared with me" for shared files, or "Upload" to select a file from your device.

5. Configure Import Settings

   • Select import location, separator type, and whether to convert text to numbers, dates, and formulas.

6. Review and Clean Up the Data

   • Adjust column widths, apply formatting, and clean up any inconsistencies.

Importing the file to Excel:

1. Open Microsoft Excel

   • Launch Excel on your Mac and open a new blank workbook or an existing one.

2. Open the CSV File

   • Go to "File" > "Open" and browse to locate your CSV file.
   • Ensure "All Files" is selected in the file type dropdown to see CSV files.

3. Import the CSV File

   • Select the CSV file and click "Open."
   • The Text Import Wizard will appear.

4. Use the Text Import Wizard

   • Step 1: Choose "Delimited" and click "Next."
   • Step 2: Select the delimiter (usually a comma) and click "Next."
   • Step 3: Choose the data format for each column (General is default) and click "Finish."

5. Review and Clean Up the Data

   • Adjust column widths, apply formatting, and clean up any inconsistencies.

Importing the file to Numbers (Mac):

1. Open Apple Numbers

   • Launch Numbers on your Mac and open a new blank spreadsheet or an existing one.

2. Import the CSV File

   • Go to "File" > "Open" and locate your CSV file.
   • Select the CSV file and click "Open."

3. Adjust Import Settings

   • Numbers typically imports the CSV file automatically. Review the imported data to ensure it appears correctly.

4. Review and Clean Up the Data

   • Adjust column widths, apply formatting, and clean up any inconsistencies.

For further questions, contact our team at support@youcanbook.me.

Join YCBM's Community Forum

Access your YCBM Dashboard