Aquameter
™
Series Instruction Manual
10401-00188 Rev M
16.14. Exporting Excel
®
Files
To export an Excel
®
file, click on the ‘
Export as Excel File
’ button. You will be asked to
specify a file name. A .xls extension will automatically be added. Excel
®
files are exported
in a Tab delimited text format. This means that each data field is separated by a Tab, and
each data record appears on a new line.
Excel
®
files are saved with a .xls extension and can be opened directly in Microsoft
®
Excel
®
.
When opening a .xls file created by AquaLink for the first time, Excel
®
may automatically
run a ‘Text Import Wizard’. Follow the three simple steps to import the file. Save the file
afterwards as a ‘Microsoft Excel Workbook’.
16.15. Exporting Google™ Files
To export a Google™ file, click on the ‘
Export as Google File
’ button. You will be asked to
specify a file name. A .kml extension will automatically be added.
Please note: only data
logged with a valid GPS position can be exported to Google™ files.
Google™ files are exported in Google’s proprietary Keyhole Markup Language with a .kml
extension, and can be directly imported into either Google™ Maps or Google™ Earth,
where the data is overlaid on maps or satellite images respectively.
Google™ Maps has a maximum import limit of 200 data records per file. If you intend to
view your data in Google™ Maps, you must select 200 or less records for export in each
file. If you select more than 200 records, Google™ Maps will truncate your file as it is
loaded. If you have selected more than 200 data records for export, AquaLink will warn you
of this limitation.
Google™ Earth does not suffer from the same limitation, so you can export a full set of
records in your file.
16.16. Importing Files into Google™ Maps
To view your files in Google™ Maps, you will need to log on to the Google™ website,
select the Maps tag then create a Google™ Account. This is free of charge at present.
Once you are signed in, follow these steps:
1. Click on ‘
My Maps
’.
2. Click on the ‘
Create New Map
’ button.
3. Click on ‘
Import
’.
4. An Import KML box will appear. Click on ‘
Browse
’.
5. Browse for the file you exported from AquaLink, and select it.
6. Back in the Import KML box, click the ‘
Upload from file
’ button.
7. Once the file has been imported, click on ‘
Done
’
You will now be able to view your data overlaid on Google™ Maps. Each data point is
represented by a yellow pushpin, and all the data points are listed in a column on the left of
the map. To view the data associated with each pin, either click on the pin, or click on the
data point in the list.
16.17. Importing Files into Google™ Earth
To view your files in Google™ Earth, you will need to log on to the Google™ website and
install the Google™ Earth application on your computer. This is free of charge at present.
Once you have downloaded Google™ Earth and have it running, follow these steps:
© 2011 Aquaread Ltd.
www.aquaread.co.uk
Page 49 of 64