Import data

Almost as basic as a base map is your own data for working with easymap. For example, in order to colour the postal routing regions just inserted according to the turnover achieved there, easymap still needs the turnover data per two-digit postal routing region.

• Import the Customer Base table from the Excel workbook Sample Data.xlsx.
• Open the menu Data and click on the command Import...

Then select:

• Microsoft Excel Workbook
• File name = "Sample Data.xslx" (you can download this file here).
• At the next step of the import wizard, select the table "Customer base".
• Click Next
• You can configure column settings here. Note that columns used for calculations are imported as numbers. Columns with postal codes are specified as data type Postcode (Germany); customer ID, territory ID etc. should be defined as Key with the appropriate length. When everything is set, click Finish.

This opens the data window to the right of the map and displays the imported "Customer base" table with the sales data of a fictitious company.

Continue with next step color areas.