With this Excel To Google 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 backend and 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 Advanced Google Maps Plugin For WordPress main plugin.
Please make sure you have installed WP Google Map 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 Google Map Pro plugin.
Here is the following process to configure Mysql Data On Google Maps plugin add-on:
Step 1: Please navigate to the “WP Google Map Pro -> Excel File To Map”.
Step 2: Please select your map from the given ‘Select Map’ dropdown to add locations on a map.
Step 3: After selecting a map you will see one more dropdown “Choose Excel File” is visible here, please select an excel file.
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.
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 Google Map 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.
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.
You will see working demo here.