The Guinness Book of World Records lists world records both of human achievements and the extremes of the natural world. This can be anything from the tallest living woman to the longest-airing sitcom—or the largest running events.

The world’s largest running events are based on the number of registrants, not distance. The 10 largest had more than one million people registered. And while not all registrants will complete the race, it’s estimated that between 80 to 85% do. However, that doesn’t mean these large running events aren’t also long, with distances up to 87.6 kilometers.

View Largest running races in a full screen map

1+ Million People Registered for the 10 Largest Races

At least 20,000 people have registered in each of the world’s largest running events. In total, it’s been over 3.5 million. Yet the top 10 make up nearly 30% of that.

• Wings for Life World Run: 184,236 registrants
• A Run for the Pasig River: 116,086
• Bay to Breakers: 110,000
• Cursa El Corte Ingles: 109,457
• Royal Run: 93,620
• Broloppet / Broløbet: 92,266
• Vancouver Sun Run: 89,000
• City2Surf: 86,696
• Dam tot Damloop: 74,020
• Hong Kong Marathon: 73,070

The 2021 Wings for Life World Run was the largest race in the world. However, that’s not surprising, seeing as the race is global. Participants from all over the world start running at the same time in support of spinal cord research.

The Philippines’ 2010 A Run for the Pasig River has also had registrants in the hundreds of thousands. At one point, it even held The Guinness World Record for having the most participants in a racing event. Previously in 1986, San Francisco, California’s Bay to Breakers was recognized by the Guinness Book of World Records as the world’s largest footrace.

It’s also worth mentioning that Copenhagen is home to both the Royal Run and Broloppet which each have seen more than 90,000 registrants. The Royal Run was held in May of 2023 while Broloppet took place in June 2000.

Speaking of months, specifically May and June, this is the most common time these large races occurred. In addition to Royal Run, May has also held Wings for Life World Run and Bay to Breakers. June, on the other hand, was the month of not only Broloppet but Cursa El Corte Ingles as well.

You’ll have to check out the rest of the largest races’ registrants and months on the map because we’re moving on to distance.

Largest in Distance

The world’s “largest” races might have many meanings. While in this case, we’re talking about participation, we also have information about their distances. So let’s see the longest of these, starting with the Comrades Marathon.

In June of 2000, the KwaZulu-Natal Province of South Africa saw 20,047 participants run 87.6 km (54.4 miles) in the annual Comrades Marathon. While that participation may seem low compared to the Wings for Life World Run or A Run for the Pasig River, it’s also the only ultramarathon (any footrace longer than the traditional marathon length of 42.195 kilometers) on the map.

Meanwhile, there are many (24) traditional marathons (42.195 km) with high participation from the Hong Kong Marathon to the Naha Marathon. Group the map by “Distance (km)” and filter by “87.6 – 30” to see them.

Where the Largest Races Take Place

We’ve mentioned the locations of some of the 10 largest races and longest races. But some countries are home to multiple of the world’s largest races.

• United States – 20 largest races
• Australia – 7
• United Kingdom – 5
• The Netherlands – 5
• India – 3

More of the largest races are held in the U.S. than anywhere else in the world. Among the most popular cities are Chicago, which is home to the Bank of America Shamrock Shuffle, Chicago Marathon, and JPMorgan Corporate Challenge. Philadelphia and New York City also put on two of the largest races each: the Broad Street Run and Philadelphia Marathon along with the New York City Marathon (held in November) and New York City Half Marathon (held in March). California also is hosts to two, albeit in different cities: Bay to Breakers in San Francisco, which has the largest participation of any U.S.-based race, and the Los Angeles Marathon in L.A.

Australia, the United Kingdom, the Netherlands, and India also have multiple large races. Get insights into your data’s most common locations when you make a map with BatchGeo.

Many modern teachers tell their students not to rely on Wikipedia as a source of information. But it’s difficult to ignore one of the Internet’s top sites, peer-reviewed all day long by the connected world. The free online encyclopedia is often the only place some information is aggregated. With crowd-sourced data about anything and everything, Wikipedia’s attraction is obvious. And that’s not to mention its lists and data tables that make it easy to copy and paste information into spreadsheets like Excel for further data analysis.

That said, there are still limitations to data gathering on Wikipedia, especially if locations are involved. While many Wikipedia tables contain the exact latitude and longitude coordinates of each location, other times, that information is missing. There are plenty of reasons to need that specific information. One example is if you’re dealing with locations that formerly existed. Exact coordinates of where these places once stood would be necessary as they may no longer exist on a map.

While you can certainly click on most Wikipedia pages to see a location’s coordinates in the upper right-hand corner, you wouldn’t want to have to do that for each item in a 135-location table. There’s an easier way to obtain coordinates from Wikipedia locations using the MediaWiki API result—and we’ll show you how in this post.

Copy All Wikipedia Table Data to a Spreadsheet

Step one of capturing location data from a Wikipedia table in a spreadsheet is getting the data from a Wikipedia table into a spreadsheet. While there are multiple ways of doing so, including just regular copy-paste, to get gather what we need to use the MediaWiki API, we’ll need to use a tool like Table Capture.

1. Add the Table Capture Google Chrome extension
2. IMPORTANT: Click the extension in the upper right-hand corner of your browser and opt for options
3. On the page that pops up, ensure Extract link URLs from table cells is checked
4. Now, navigate the Wikipedia page with a table you wish to pull data from
5. Click the extension
6. Select your desired table
7. Click the icon that represents the action you want to take (i.e. Copy table data to the clipboard, Export table to Google Sheets, etc.)
8. Paste to your spreadsheet if necessary

Now that you have the Wikipedia table data in your spreadsheet, we’ll need to isolate captured links from table in your spreadsheet so that we can use the MediaWiki API.

Isolate Captured Links & Queries in Your Spreadsheet

The data we captured from the Wikipedia table in the previous section contains Wikipedia page links, which we’ll need in order to obtain exact geographic coordinates. However, these URLs are buried within the data, not useful until we can isolate them into one column.

The method we’re about to show you is quicker, especially if you have hundreds of locations, as with our Former Major League Baseball stadiums. So let’s continue.

• In your spreadsheet, identify the column that contains both the names of your locations and their corresponding Wikipedia page URLs (if the previous step was done correctly). In our case, that’s the “Stadium” column
• Next, you’ll need to separate location names from the URLs using Excel’s “Text to Columns” tool (Google Sheets has a similar feature called “Split text to columns”):
  • Navigate to the “Data” tab in Excel and select “Text to Columns…”
  • Opt for Delimited characters seeing as the URLs should be contained within parentheses
  • Click Next and check “Other”
  • Type in an open parenthesis ((), then click Finish
    • Note: If any rows end up split into three columns instead of two (one for location names, one for Wikipedia page URLs), you’ll need to use =CONCATENTATE to combine the two parts of the links
    • First, make these easy to identify by using “Sort & Filter” > “Sort A to Z”
    • Then, in the second cell of a fourth column, type =CONCATENTATE, click the first cell with part of a URL, “(”, followed by a comma and the second URL cell
    • Drag that formula down to all of the similar cells in the column
    • Copy and “Paste Values” into that same column, then select the previous two columns, delete and shift them left
  • You’ll finish up by following the same “Text to Columns” steps above and splitting the entire column by ending parentheses
• Then, use “Conditional Formatting” in the Home tab to highlight any link cells in which a starting parenthesis remains as part of the link
• You can either use ‘=CONCATENATE’ or manually add back the closing “)” to all of the highlighted cells
• Just one more step: we only need the query string or parameter part of the link, so you’ll once again use “Text to Columns,” this time noting “/” in the “Other” space
• Delete the other split link columns and you’re done!

Now you have the exact links to the exact Wikipedia pages, and can use the MediaWiki API result to more easily grab their exact coordinates.

Use MediaWiki API Result to Get Coordinates

With our data gathered and locations and link queries in their respective columns, we can finally use the MediaWiki API result in order to obtain latitude and longitude coordinates with minimal clicks. Non-developers needn’t worry—this is the easy part for any experience level.

• In your spreadsheet, copy (Ctrl+C or Cmd+C) your first Wikipedia page query
• Navigate to MediaWiki API result and paste your query at the end of the URL bar, replacing our Sahlen_Field example
• Press enter, then copy and paste the resulting “lat” and “long” into your spreadsheet!

They’re even in the perfect format for making a custom Google Map from your data…

Map Your Coordinates & Data

As an optional, final step, you might plot your newly gathered data points on a Google Map. Here’s how:

View MLB Stadiums in a full screen map

1. Open your spreadsheet
2. Select (Ctrl+A or Cmd+A) and copy (Ctrl+C or Cmd+C) your data
3. Open your web browser and head to batchgeo.com
4. Click on the location data box with the example data in it, then paste (Ctrl+V or Cmd+V) your own data
5. Check to make sure you have the proper location data columns available by clicking “Validate and Set Options”
6. Select the proper location column from each drop-down
7. Click “Make Map” and watch as the geocoder performs its process

Get started for free at batchgeo.com.

It’s easier than ever for you to bring location data to life. When you provide a geographic visualization to your website, news story, or sales process, you uncover additional meaning. And just about everything has a useful location context.

Anyone can put some markers on places, thanks to the abundance of mapping apps available. You have many different types of maps now at your fingertips. In some cases, you can change marker colors, overlay heatmaps, and filter by data about each place. However, all these features also add more complications: how do you choose which to use and how do you know if it does what you need? Whether you’re a seasoned cartographer or just starting your mapping journey, we’ve compiled a list of 2024’s top mapping apps to help you find the perfect fit for your needs.

1. BatchGeo: Best for Entirely Customizable Google Maps

View Example Sales Map in a full screen map

BatchGeo sets itself apart as a user-friendly mapping tool that relies on the robust infrastructure of Google Maps, distinguishing it from many competitors in the market. With its user-friendly bulk mapping capabilities, BatchGeo caters to the needs of businesses and individuals alike, providing a convenient way to create interactive maps efficiently.

Ranking #1 in both satisfaction and popularity from G2’s 2023 GIS Software Awards, the platform’s integration with Google Maps offers users a familiar and dependable interface for their mapping endeavors.

Furthermore, BatchGeo’s complimentary plan is a notable advantage, granting access to a range of features that are typically reserved for premium subscriptions.

BatchGeo also enables seamless sharing of maps, allowing users to distribute them publicly or privately. Its diverse functionalities, such as creating heat maps, along with customizable map bases, marker shapes, and colors, enhance its adaptability.

For users seeking even more advanced customization options, BatchGeo offers a paid subscription that unlocks 100,000 markers per map, measurement and routing features, and more for you and a team of 10 users for one low price.

We recommend you start a BatchGeo trial and compare it to one or more of the options below.

2. Mapline: Best for the Basics

Mapline, like the others on our list, lets you mark places on a map. Its in-house map looks quite a bit different than Google’s, though Mapline adds routes and territories, as well as measurement features.

The Geospatial starter plan provides a sampling of the company’s mapping tools. It allows you to create maps, plot locations, and explore Mapline basics. You can only upload up to two datasets with 500 locations each, but you’ll be able to create territory and heat maps and draw a coverage radius.

Beyond its basic maps, Mapline has enterprise products for analytics, dispatching, scheduling, and operations. The pricing and functionality for these products are only available from Mapline Sales.

Nevertheless, the self-serve option is worth a test drive, if only to see how to create and navigate the maps. Some users find Mapline less user-friendly, with its interface a bit confusing compared to the next top mapping app. The paid products may provide a more focused offering, but you’ll want to make sure the underlying map does what you need.

3. Maptive: Best for Complicated Territory Maps

Maptive is a simple and easy-to-use choice for online mapping. It provides the basics we’ve come to expect from web mapping, like creating and sharing maps effortlessly.

If you’re looking for complicated sales territories, you’ll want to try Maptive. It has polygon-drawing features to create territories, map geographic boundaries, and color-code each area. It adds heat maps, demographics data, and distance and drive time calculations.

To get the most out of Maptive’s most complicated features, you’ll likely need a team account, which is at least $5,000 annually for 10 seats. You’ll find a 10-day free trial to see if it works for your needs. Unless you need the complicated territories, this pricing may be a bit on the higher side. On the other hand, if you need GIS-level mapping needs, you might prefer to look at one of the next two options.

4. Maptitude: Best for Offline Use

Maptitude is firstly a desktop application to create maps. There are options to take these maps online, but much of the customization needs to happen on your computer. There are advantages to this approach, such as bringing external geographic data to your maps.

Another advantage of a desktop tool is that Maptitude enables you to create and view maps whether you’re connected to the internet or not. In fact, Maptitude’s examples focus on static visualizations, which you can share as images.

There is a Maptitude free trial to get you started, so you can answer for yourself if it solves your mapping problem. The pricing isn’t as simple as web-based software, with a number of options based on your needs. The entry point for the desktop software is $695 per user for a year of access.

5. ESRI ArcGIS Online: Best for Versatility

As the undisputed industry standard for cartography, we couldn’t wrap up our list of the top apps without mentioning ESRI ArcGIS Online. The well-known software caters to businesses and individuals that need robust spatial analysis and map creation tools. ESRI ArcGIS Online stands out for its unparalleled versatility, offering a comprehensive suite of features used by professional GIS engineers worldwide. From precise geolocation to advanced analytics, it is the primary tool for those who need maximum map customization beyond what’s possible with Google Maps.

ESRI ArcGIS’s downside lies in its steep learning curve, which often demands a large time investment. Additionally, its cost may pose a challenge, especially when compared to lower-cost alternatives that solve the most common mapping problems with web-based maps.

---

When it comes to mapping apps, there are many options. Mapline, Maptitude, Maptive, and ESRI ArcGIS Online all are excellent choices for specific needs. However, BatchGeo stands out among the most user-friendly and intuitive, thanks to its seamless integration with the familiar Google Maps platform and customization features that go beyond what Google Maps offers, all without the need for coding knowledge.

Give BatchGeo a try now and make Google Maps work for you – with faster geocoding, route optimization, password protection, 10 users at no additional cost, PDF support, and more.