How to Create a Map From Excel Data

Updated February 21, 2017

Although Microsoft Excel can create a variety of graphs and charts, creating maps is not one of the spreadsheet's options. For Excel 2000 and later, Microsoft created MapPoint to integrate with Excel and create maps. MapPoint is a powerful tool that can help you create information-rich maps that can be integrated not only with an Excel spreadsheet, but also with GPS devices as well. MapPoint uses your existing Excel worksheet data to create a map that can be pasted into most Microsoft products, including Word, PowerPoint and Excel.

Ensure that your date is organised neatly. Data that will transform well to maps is clearly organised into rows and columns, with column headers. For example, you might have a list of cities (with the column header "City"), a list of Postcodes ( header "ZIP codes"), and a list of the number of people who live in those Postcodes (header "people").

Copy the data in your worksheet. Click on the top right cell and drag the mouse over to the bottom right cell. Click "Ctrl-C" to copy the data.

Press "Ctrl-V" in MapPoint. Microsoft will paste your data into a map. MapPoint will recognise your pasted data as geographical data, and will open the "Data Import" wizard.

Select the type of map you want to create. Click "Finish."

Click "Edit" in MapPoint. Click "Copy" to select the detailed map,

Click "Ctrl-V" to paste the map into the Excel worksheet. Excel pastes the map into the worksheet as a bitmap.


To copy the legend in addition to the map, select "Copy Map" from MapPoint when you go to copy the map from the "Edit" menu.

Things You'll Need

  • Microsoft Excel 2000 or later
  • Microsoft MapPoint
Cite this Article A tool to create a citation to reference this article Cite this Article

About the Author

Stephanie Ellen teaches mathematics and statistics at the university and college level. She coauthored a statistics textbook published by Houghton-Mifflin. She has been writing professionally since 2008. Ellen holds a Bachelor of Science in health science from State University New York, a master's degree in math education from Jacksonville University and a Master of Arts in creative writing from National University.