Your Sailing Logbook in ExcelBelow you'll find a step by step manual, explaining how to get the ship's log - gathered with Logbook App - imported to Excel. This example uses real trip data from a trip in the Adriatic Sea from the year 2013.
Pleasure first! Before we come to ExcelAs you know, Logbook App relieves you of a lot tasks at sea, so let's expect you have a nice trip behind you and you would like to create your own individual statistics or other evaluation in Excel. Let’s imagine this trip is over, you’re back home.
Export your Logbook as CSV
Go to Settings (1) and scroll down to ensure you selected the correct logbook to export (2). Just a bit further down you will find the Export Center (3). Choose Export as CSV(4) and wait until the mail application appears. This might take some time depending on your logbook size and the iPhone or iPad you use. Next send this mail to yourself to get access from your MAC or PC.
Import CSV in Excel
What is a CSV and why not simply using .xls or .xlsx?CSV stands for
Comma Separated Valuesand means your data is in different columns where each colums is delimited by a comma. So this format is really easy for humans to read and understand. In Excel are also colums, and the only specific thing is we use a Semikolon
;as delimiter. As it could be alos the the case you used a semicolon a log record. To avoid this undesired additional column each colums data is embedded in quotes. The big advantage is the format is mainly independent to operating systems or application. So you could also import this data with Open Office on a Linux operated system.
Which character set is used for my sailing logbook CSV file for Excel?As the Logbook App uses Geocoding and automatically translates your position into a local text string, this string could contain characters beyond ASCII. For example the Logbook App could geoencode your position to
1.2 NM south Rear Light Hörnum,
Šipan Island, or
Korčula. To support those non-ASCII characters Logbook uses UTF-8 encoding. With UTF-8 character set it is ensured to support most special characters. Unfortunately Excel does not interpret CSV files as UTF-8 by simply opening them into Excel with a double click on the file.
Difference between Windows and MacExcel for Mac has a Bug. It let us not import data with the common function
From TextExcel 2011 cannot import data that is UTF-8 encoded. Windows version do not have this Bug and you can choose UTF-8 character set during import process. However this page explains the more complex way to work on both platforms.
Well and how can you get you Logbook to Excel?
The previous explanation sound more complex than it actually is. First you have to open the CSV file in a common text editor which supports UTF-8.
Select all (1) and copy it to clipboard (2). Next open Excel
and past your content to the spreadsheet (3). Ensure the whole column A is selected. Switch to the ribbon
Data (4) and on the small icon for
Text in Columns (5).
Within the first step of the wizard just click on
In step 2 it is important to switch the Delimiter from comma to semicolon (7) and click on
Caution! If you are using a comma as Thousands seperator and a a dot as Decimal seperator (as usual in the United States), you need to switch those values. Therefore go to the 3rd step as well, click on Advanced and choose a dot as Thousands seperator and a comma as Decimal seperator. Afterwards cklick OK and Finish.
Finally you should have your entire Logbook in Excel imported for further processing or whatever you would like to do.