LOCATEXL USER GUIDE

Top  Previous  Next

1.7. Get Detailed Locations of Current Row

 

To get a list of all possible locations for a row

• Right click a row in your spreadsheet

• Select ‘LocateXL’(1) and click ‘Get detailed location information of Current Row’ (2)

• This will bring up all possible matches for this row (limited by the maximum number of matches)  *Note, make sure to right click a cell in your address columns, and not in the geocode result columns

 

LOCATE~1_img11

 

In the Address Choice box that pops up you can search or filter any column to try and find a better match.  If you do find a better match you can select (highlight) the row in the grid (1), and click ‘choose’ (2).  This will automatically update your geocode result in your spreadsheet

 

LOCATE~1_img12