Using BatchGeo:

1. Go to

2. In the “Where stories ran” worksheet in the “Working Tracker spreadsheet,” use Vlookup to pull in the news organization’s location.

3. Copy and paste the data from the “Where stories ran” worksheet to the front page of and choose “Validate and set options.”

Note: BatchGeo will not read hyperlinks. To include links in the map, links and headlines must be in separate columns.

4. Click “Save and Continue” when you are satisfied with the map. Give it a title, enter your email address, and choose “Unlisted.” Click “Save,” and a link to the map and the HTML code will be emailed to you.

5. To map your coverage, add location information in the “Slug info” worksheet and follow the above steps to make the map.

Watch the video of this presentation on Latakoo.