POI Loader for Android csv file schema

If you already have POI files or would like to create some here is the file format that the POI Loader application for Android can read and import. It will also export files to this same format.



Excel type view (do not include the first/header row, reference only):
Longitude Latitude POI Name POI Snippet Marker (optional)
40.99999 -80.999999 My New POI My New POI Info
-159.459214 21.879285 Starbucks: Poipu Shopping Center - Koloa HI (W) "2360 Kiahuna Plantation Drive<br>Koloa, HI 96756<br>(808) 742-5144"
-159.380923 21.97116 Starbucks: Kukui Grove - Lihue HI (W) "3-2600 Kaumualii Highway #A8<br>Lihue, HI 96766<br>(808) 241-7034" Red Paddle S


Text editor type view:
40.99999,-80.999999,My New POI,My New POI Info<br>Phone: 555-555-5555,Pin Red



Text File of Marker Names ↓




NEW!

You can now include select HTML tags in the snippet for styling and including URL's to web pages.

If you want to add URL's links and style the snippet using HTML you must start the snippet with the opening html tag () and end it with the closing html tag (). It is best practice to surround the snippet column with quotes and the escape any quotes used in the HTML tags you will need use a double set of quotes.

Here is an example:
2.0,2.0,"HTML Snippet example","<html>This is a link to a document: <a href=""http://poiloader.joshlentz.info/file-schema.php"">Document</a></html>"



Example HTML in Snippet CSV file ↓