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.
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 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.
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.
Related Tutorials:
- How to set custom colors on Google Maps skin
- How to migrate Google Maps from one site to another site
- How to display WordPress users on Google Maps
- Displays CF7 form submissions on Google Maps
- Display a search form and allow visitors to search records on google maps