How to open a .csv file in Excell
CSV files (Comma-Separated Values) are a type of file in which information is stored for export/import from/to a database, where the values in each column are separated by commas (or semicolons), and the rows by a line break. Read on to see how to open a .csv file using Excel on Windows or Mac.
Follow these steps to open your CSV file in neat columns:(Skip to step 3 if you have already downloaded the .csv file) (If you have a Google account, the last note will be of interest to you)
Step 1: Go to Booking
Login to your TuriTop booking system account and go to Reservations. Use the filter Use the date selectors and other filter fields to customise your search and press the orange button on the left (magnifying glass) to view the desired bookings.
Please note: If you leave all filter fields blank you will download the complete database. There is a limit of 1000 reservations per download.
Step 2: Download the file
Download your .csv file by clicking on the orange button on the right (CSV).
Step 3: Import the file into Excell
Open Microsoft Excell. Click on "archive" The programme will ask you which file to open. Choose .csv file and click on "import".
The programme will ask you to choose which file to open. Select CSV file and then click on "import".
Search for the file "bookings.csv" that you downloaded and click on continue.
Step 4: Tick the following boxes
A new 3-step window will appear on the screen. Under file type choose "delimited". and click next. In the second step make sure that you only check the field of "Tabulation and click next. In the third step make sure that in the field "data format by columns" there is the button of "General" ticked, and then click on end.
Step 5: Select where you want to save the file
A new window will appear asking where you want to save the file. Click on Accept.
Please note: A simpler method exists if you have a Google account. 1. Open your .csv file in Google Spreadsheets. 2. Click on "File" >>> "Download as" >>> "Microsoft Excel".
Done! Now you will have all your customer information separated by columns.