Maps for Excel

Показать описание

Bring mapping capabilities and geocoding to Microsoft Excel: insert static maps with heatmap, administrative boundaries, shapes and geo-objects, place photos and street views, download GeoJSON and KML, get address components, find places with details, build routes, show isolines and have some other geocoding functions in your spreadsheet. Try our Maps for Excel add-in today!

Install Maps for Excel add-on free and try it: click Home - Maps for Excel - Show Taskpane - Show ideas to find some ideas for use of Maps for Excel formulas.

Ideas for use
Click Home - Maps for Excel - Show Taskpane - Show ideas to find some ideas for use of Maps for Excel formulas.

Insert formulas
Click Formulas - Insert Function - Maps for Excel, select formula to insert into your spreadsheet, press Next to continue.

Update formulas
To update formula or refresh it after some issues

Click Home - Maps for Excel - Formulas - Update in selection to update cells with formulas in a selected range.

Click Home - Maps for Excel - Formulas - Update with errors to update formulas with error status.

Click Home - Maps for Excel - Formulas - Update all to refresh the entire sheet.

Replace formulas with values
To avoid API credits “leakage” due to periodical formulas updates by Microsoft Excel you may replace formulas with their values.

Click Home - Maps for Excel - Formulas - Replace in selection for formulas in a selected range.

Click Home - Maps for Excel - Formulas - Replace with errors for formulas with error status.

Click Home - Maps for Excel - Formulas - Replace all for the entire sheet.

Disable/Enable formulas
To avoid API credits “leakage” or trigger of interactive functions due to periodical formulas updates by Microsoft Excel you may disable/enable formulas.

Click Home - Maps for Excel - Formulas - Disable in selection for formulas in a selected range.

Click Home - Maps for Excel - Formulas - Enable in selection for formulas in a selected range.

Download
Select cells to download and click the menu item under Home - Maps for Excel - Formulas - Download.