Ultimate World Map Collection
Need to create map charts in Excel or Google Sheets? We've created a Ultimate World Map Collection template in Excel and Google Sheets that you can download and customize to your needs. It includes a world map chart, map charts for each major continent, including North America, South America, Asia, Europe, Africa, and Oceania, as well as a map chart for the United States, which on Excel can be customized to any country that's needed, which we'll get into later.
The best part is, this spreadsheet is fully customizable - meaning any field in blue can be edited to fit any use case, whether you need to map your global sales data, growth initiatives, supply chain bottlenecks, global hiring efforts, or anything else. No need to wrestle with Excel formatting anymore - we'll share how to use this spreadsheet template to easily visualize your data directly onto premade maps.
Build a World map chart in Excel or Google Sheets from scratch
First and foremost, no global expansion plan is complete without a world map chart to plot your global takeover. This world map chart can filter between two date ranges, between two distinct numeric metrics (in this case, "revenue gained" and "market size"), and by a particular noun to assess (in this case, a product type).
Finally, they're also filterable by country. To showcase data from a particular country, select it from the dropdown. Each country is defined by a country code on the Fields tab, so you can change the country names to whatever you want.
This country filtering is important on the Google Sheets version, where the map types are less dynamic than in Excel. But we'll explain this more later.
Underneath the filters, the min and max ranges of your data are provided for more precise filtering. The data table below the maps is where you define each of these metrics and plot your data by replacing all the inputs in blue.
Our data table has metrics for each country's annual growth numbers and growth rate as a percentage to assess how fast each country is growing. This "sample data" for each country is actually real, and up to date through at least 2022 - in case you want to keep it. But to change the metrics to be assessed, rename them in the header row, and it changes above, too. For instance, this all could be replaced to count orders in and out, new hires across each country, and so forth. Watch the video above to see this customization in action.
Create filterable Continent charts for each major continent
In addition to the world map, we've also provided map charts for each of the continents and their related countries. Here they are again on Google Sheets, beginning with North America, which also includes part of Latin America, then South America, Asia, Europe, Africa, and Oceania, which includes Australia, New Zealand, and the related countries and islands. Each of these maps function the same way as the world map.
Remember, if you want to utilize this world map chart template for quick data visualizations, you can download and customize it to your needs right now.
A Map of the US becomes a customizable country chart in Excel
Last, we provide a map of the United States for both Google Sheets and Excel. The US map can be filtered by two date ranges, one location value, such as state (which can be edited to match other countries on Excel) and two noun values. In the example we provide in the above video, we highlight a specific product and a specific division that sells that product.
On Excel, this map can be fully customizable to any country you like. Watch the video attached to this article to see this in action.
All that's needed is to delete the state and zip code headers and replace them with whatever matches the country to visualize, whether that's postal code and state, province, region, principality, or anything else.
On Google Sheets, this works slightly differently. Since the United States map is just a map of the US, that means if the intention is to highlight a particular country, you need to use the country filter on the continent map where that country is located to highlight its particular data.
With premade map charts that are easy to plug your custom data into, you can visualize a new market entry strategy, global sales data, or international expansion plans with ease. To visualize your map data, you can download and customize this Ultimate World Map Collection spreadsheet template in Microsoft Excel or Google sheets right now.
For more tools like this, go check out our Go-to-Market Strategy and Emerging Markets presentations for additional visualizations to present your global expansion plans to key stakeholders.