Why are the coordinates grouped together in a single field called “GPS” rather than split out into Longitude and Latitude? This would make more sense and make it easier to map them without having to edit the data.
If you know how to work with JSON, I recommend directly using the API instead where these coordinates are broken out: https://supercharge.info/service/supercharge/allSites
If not, I recommend a tool like this: JSON to CSV Converter Online (formerly json-csv.com)
Find more API information listed here: API endpoint for all data of a particular site? - #2 by ibuza
3 Likes