1. add excel table to map frame
![](https://transparentgov.net/data/img5/ps_geocode_01.png)
2. lat, long column must convert from text string to number(double or float)
![](https://transparentgov.net/data/img5/ps_geocode_02.png)
3. x for long, y for lat
![](https://transparentgov.net/data/img5/ps_geocode_03.png)
4. must de-activate map frame so you can insert table. If you want to zoom in out pan map, you must activate map frame.
![](https://transparentgov.net/data/img5/ps_geocode_04.png)
5. adjust table column order by arrange it in attribute table. also can adjust style font from map frame
![](https://transparentgov.net/data/img5/ps_geocode_05.png)
6. when publish, make sure all data source is match
![](https://transparentgov.net/data/img5/ps_geocode_06.png)