Appendix 6: How to Backup Routes
AP-91
A6.3 How to Import Routes from Excel File into
ECDIS
Below is an example of how to import waypoints' name and latitude/longitude values from a Microsoft Excel table
into ECDIS. Limit the length of waypoint names to eight alphanumeric characters and route names to 30
alphanumeric characters.
1. Open the MS Excel that contains the route data you want to import to the ECDIS. Copy desired columns to the
clipboard: Highlight data in MS Excel then select >Copy.
Content of MS Excel may look something like this.
2. You can paste text to Notepad (First activate Notepad then select Edit>Paste)
Content of Notepad looks something like this.
3. Put the cursor on Route in the status bar then click the Plan button to open the Plan Route dialog box. Put the
cursor on the triangle in the dialog box, select Backup and Restore from the menu then push the scrollwheel.
4. In the Backup Device field, select desired Restore Format (ASCII WPT NAME POSITION).
5. Insert floppy disk into disk drive in the processor unit. Select backup drive (A:\) from the Backup Device field.
Select desired route from the list box in the Backup Device field then click the Restore button.
6. ECDIS generates new route, which has same name as text file.