How to map excel data in Google Maps - WP Maps Pro

15000+ live websites are using this google maps wordpress plugin.

How to map excel data in Google Maps

With this Excel To WP Maps plugin addon/extension, site admins can display excel sheet data on google maps very easily and with flexibility. Site admin just needs to upload the excel sheet in the backend and the second step is to do the column mapping to serve excel sheet columns as title, content, and images in the info window and listing. This is a premium addon of our WP MAPS PRO plugin For the WordPress main plugin.

Please make sure you have installed WP MAPS PRO plugin into your website. In case you have not installed it yet. Please download these plugins and configure them first. Here are the following steps to install the WP Maps Pro plugin.

Here is the following process to configure Excel Data On Maps plugin add-on:

Step 1: Please navigate to the “WP MAPS PRO -> Excel File To Map”.

Step 2: Please select your map from the given ‘Select Map’ dropdown to add locations on a map.

excel to Map

Step 3: After selecting a map you will see one more dropdown “Choose Excel File” is visible here, please select an excel file.

excel data map

Step 4: When you upload an excel file, all the columns associated with it appear below with some dropdown. Select associated location field data from the given dropdown in front of a table field.

excel data on a map

Step 5: After selecting the associated location field from the given dropdown in front of a table field, click on ‘Save Settings’.

Note: Title, Latitude, and Longitude are required for mapping. You can use Extra Fields and Category for multiple column mapping.

Step 6: Please navigate to the “WP MAPS PRO -> Edit Map” edit the selected map and scroll down to the “Excel To Google Maps (Addon Settings)”.

Step 7: Enable “Enable MySql Locations” checkbox from ‘Excel To Google Maps (Addon Settings)‘ given section and save settings.

edit map

Step 8:  After enabling this add-on please click on “Save Map”.
You could see your selected table field data is displaying on a selected map.

save map

You will see working demo here.

 

 

Related Tutorials:

Was this article helpful?
YesNo

Install Plugin Now!

Buy this plugin exclusively on CodeCanyon! You’ll get free updates, full support, and if you’re not satisfied, we’ve got you covered with a 30-day money-back guarantee.