CSV files (short for "Comma-Separated Values") are a file type used to store information for exporting to or importing from a database, where the values in each column are separated by commas (or semicolons), and the rows are separated by line breaks. Keep reading to learn how to open a .csv file using Excel on Windows or Mac.

Follow these steps to open your CSV file with neatly formatted columns: (Skip to step 3 if you’ve already downloaded the .csv file) (If you have a Google account, the last note will be of interest to you)

Step 1: Go to Bookings

Log in to your TuriTop booking system account and go to Bookings. Use the filter to narrow your search.Use the date pickers and other filter fields to customize your search, then click the orange button on the left (magnifying glass) to view the desired bookings.

Please note: If you leave all filter fields blank, you’ll download the entire database. There is a limit of 1,000 bookings per download.

Step 2: Download the file

Download your .csv file by clicking the orange button on the right (CSV).

Step 3: Import the file into Excel

Open Microsoft Excel. Click “File.” The program will ask you which file to open. Select the .csv file and click “Import.”

The program will ask you to choose which file to open. Select CSV File and then click “Import”.

Locate the “bookings.csv” file you downloaded and click “Continue.”

Step 4: Check the following boxes

A new 3-step window will appear on the screen. Under “File type,” select “Delimited” and click “Next.” In the second step, make sure to check only the “Tab” field and click “Next.” In the third step, make sure the “General” button is selected in the “Data format by columns” field, and then click Finish.

Step 5: Select where you want to save the file

A new window will appear asking where you want to save the file. Click OK.

Note: There’s an easier method if you have a Google account. 1. Open your .csv file in Google Sheets. 2. Click “File” >>> “Download as” >>> “Microsoft Excel”

Done! Now you’ll have all your customer information organized into separate columns

A tribute that evokes the scent of volcanic soil, high-altitude wine, and the hard work of the people who make it all possible…