Starting from version 4.30 onwards, iMapBuilder allows you to edit map region settings such as color, hyperlink, tooltips directly using Grid, or import data from clipboard and Excel file in csv format.

Plot customers onto a map using information from Excel

If you have an Excel spreadsheet file with list of locations and need to plot the on a world map,
we suggest you use iMapBuilder Online.

• Import the Excel data into custom Google map and automatically convert addresses into Geocodes, and then plot as markers.
• Import from CSV data file (CSV file can be generated by exporting data from Excel, MYSQL or other types of database using PHP script)

Switch to Grid Edit Mode

1. Locate the region settings tab
   • MainMenu > Edit > Region Settings
   • or in the bottom panel, switch to Region Settings Tab
2. Click Switch to Grid Edit Mode
   

   

Edit Regions directly in the Grid:

1. Locate the correct region in the list
2. Edit Name To Display field for the mouseover toolip
3. Edit region normal color and highlight color
4. Add hyperlink for the regions
5. Use color selector to get the hexadecimal format color code (RRGGBB)
6. Change the region's group highlight id
7. Click Apply to make changes.
   

Copy and Paste the region setting from spreadsheet

1. Open your spreadsheet software (like Excel or OpenOffice)
2. Click Copy all to clipboard to copy the region setting data into clipboard
3. Switch to spreadsheet software and create a new blank spreadsheet
4. Paste the clipboard data into your spreadsheet
5. Edit the region setting data inside your spreadsheet software
6. Select the related cell in your spreadsheet and copy the data back into clipboard
7. Switch to the iMapBuilder Software, and click Paste from Clipboard to paste back the region setting data from spreadsheet
8. PS: Paste or Import should include the header title and with same number of rows and columns
   

Import and Export Data File

1. The data file is in Unicode Text (.txt), you can find this file format in Excel
2. Click the Export Data File to export the existing region setting data.
   
   
   
3. Open data file in spreadsheet like Excel or OpenOffice (For OpenOffice, we recommend you to rename the datafile to .csv extension because OpenOffice may default open the .txt in it's OpenOffice Docs)
4. Edit the region setting data in the spreadsheet software
5. Save the data file
   • For Excel - save the data file into Unicode Text (.txt )
     
     
     
   • For OpenOffice - save the data file into Text CSV (.csv ), enable Edit Filter Settings
     choose Unicode as Character Set, Tab as the Field Delimiter set Text Delimiter as blank
     
     
     
     
     

Unicode Text Format (.txt)

• UCS-2 Little Endian (known as UTF16 LE)
• Each record is one line of the text file
• Each field value of a record is separated by a TAB
• And Text delimiter set as blank