If you don’t want to waste your time on a lengthy process of deleting all location-based keywords within Google Sheets by yourself, there is an alternative, a script that helps to make this task automatic.
Search Engine Land shared their newly developed script that does all the work for you.
Basically, this script scans your whole account or particular campaign(s) to find all the location keywords present in their database. It works for every UK location keyword.
In the first column, there is a keyword itself, and the second one is the location the script has pulled.
There are some variables that you can use for setting up the script for your particular purpose. You can configure the script so that it includes only selected campaign(s) or all campaigns on your account. And you also are able to set it up in the way to exclude particular campaigns.
The whole script itself, as well as a short introduction and instructions on setting it up, can be accessed here.