Plotting bulk latitude and longitude coordinates quickly and easily using Obsidian and Excel.

During one of my OSINT investigations I began entering latitude and longitude coordinates into Obsidian, typically when there are only two or three then doing this manually makes sense. However I realised that I needed to devise a method to automate this process to maximise my productivity and to do it accurately. Obsidian is a great tool, however some processes can be slightly fiddly or prone to error.

Users must enter latitude and longitude coordinates into Obsidian in a strict format [Name/Title](geo:lat,lon)

Users can experience problems with plotting coordinates because Google Maps enters a space between the latitude and longitude coordinates which users must remove before plotting in Obsidian.

[London Bridge](geo:51.505035, -0.085058) this space will cause the latitude and longitude coordinates not to plot. If the user is only doing a few then it can be rectified easily, however if they are doing tens, hundreds or thousands then a process should be created to automate and eradicate this.

Please watch a demonstration below.

If you have any suggestions or comments then please contact me using any of the methods on the contact me page.

Credits: https://github.com/davwheat/uk-railway-stations for the dataset used in the demonstration.