In most cases, MapGrove Studio is used to quickly visualize the data in an existing spreadsheet.
In this example, we create a map from an Excel table containing the countries that qualified for the 2014 FIFA Worldcup Football.
The data for this Excel was taken from Wikipedia.
Note that the country names are in column B
For this example your account needs access to the Mapgrove World Countries map. See Prices/Shop for more details.
Start MapGrove Studio and select the basemap (in this case “World – Countries (2014)”).
To add (upload) the Excel sheet to the MapGrove server, click the [+] button (next to the dataset dropdown) or drag-and-drop the Excel file on the [+].
As soon as the file is uploaded it is automatically selected as “dataset”. The name of the dataset appears in the dataset dropdown and a column dropdown appears next to the dataset dropdown.
Select “Col B” from the dropdown that appeared next to the dataset dropdown to indicate that the geographical features (identifiers) are in column B.
To adjust the basic style for the map, select the line color (dark orange) and fill color (grey) for the map.
Click on the “thematic” tab to color the map, based on the data in the Excel sheet.
In the dataset tab, the Excel data is visible. Note the blue number in the first column, indicating the areas that were succesfully identified in the base map. Click on column C to select the cells in column C. Cells from identified features from column C are indicated with a grey background.
Select “color ramp” from the dropdown to fill the map based on the number of matches played in the FIFA Worldcup 2014 tournament. Lowest and highest value are automatically selected. Change the low and high color for ramp coloring (light orange and dark orange).