Skip to content

Import kml files

Paul Kiddle edited this page Sep 20, 2018 · 1 revision


Scratchpads support the import of location data through MS Excel files. For more info please check Importing data using Excel files & Importing location data

If your locations are in a KML file you could export them to an MS Excel file through the following procedure:

  1. Rename your .kml file to .xml
  2. Open a new excel spreadsheet (2007 and later) and click on Data > From Other Sources > From XML Data Import
  3. Locate the file you renamed and click open
  4. Click OK to the Microsoft Excel dialogs that will open
  5. Modify the column data format to match the Scratchpad template file columns Importing location data
  6. Copy-paste the modified columns to the corresponding columns of the template file
  7. Upload the template file as indicated in the help pages Importing data using Excel files
  8. You will now get all the locations of your .kml file to Scratchpads.
Clone this wiki locally
You can’t perform that action at this time.