Mapping Sheets allows you to take a list of addresses in a Google Sheet and by triggering the add-on, create a Google Map that shows the location of every entry with a pushpin as well as other data that you have collected. I tried it with some very broad locations like China, Australia, and Montana and it pulled a map just fine. Then I tried it with some Washington city names and the state and it did that fine too.
I can see the applications of this in a few ways, one being in a social studies class to track where items we buy are from. Another might be in an English class to track the movements of a character in a book. Or if you're giving a presentation, like I will be, to show the location of all of the attendees. It's fun just to play around with too!
Check out the video below or watch it here