# Arming Public Safety With Visual Intelligence

# Guide to Building Layers from a Spreadsheet and Publishing Edited Layers

## What do I need to do to get my pins on FirstTwo?

## Unfortunately, Google MyMaps require that your spreadsheet needs to have a latitude and longitude as columns, otherwise those pins will not show up in FirstTwo. Sounds like a pain, but we will take you through these simple and free steps to add a latitude and longitude to your spreadsheet.

## The first step is to find a program that adds these columns. We found [Geocodio](https://www.geocodio.com/) to do this and do it for free.

## Getting Started

# Highlight and Copy address (including city and state) column(s) from original spreadsheet

# Add Latitude and Longitude to Spreadsheet using Geocodio.com

# Geocodio

Name Geocoded Spreadsheet

Right click and Paste the copied columns here Click here to continue

# Open Google Maps

# Updating an Existing Layer

# Publish Layer in FirstTwo

# Publish Layer in FirstTwo

Thank You  
!  
Smart, Safe Officers Build Strong, Safe Communities  
Customer Support: [FirstTwo Help](/content/help/index.html) [support@firsttwo.com](mailto:support@firsttwo.com)  
(888) 934-7782