Example: creating a map from your own spreadsheet data

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

excel  sheet to add to the MapGrove server

excel sheet to add to the MapGrove server

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 [+].

adjust basic style for the map

adjust basic style for the map

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.

choose map and link dataset

choose map and link dataset

adjust map: select line color and fill color

adjust map: select line color and fill color

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.

color the map, based on column C of the dataset

color the map, based on column C of the dataset

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).

Done!

colored map, colors based on column C of the dataset

colored map, colors based on column C of the dataset

final result, ready for download

final result, ready for download