I made a tool to convert spreadsheets of coordinates into decimal degrees. A version of the parser is below; follow the link to convert csv or (yuck) excel files.

-

For about the 137th time, I found exactly the data I was looking for, but the coordinates were recorded in a mix of Degrees, Minutes, Seconds; Decimal Minutes; and Decimal Degrees with just appalling formatting. I mean, lowercase o’s for degree symbols, copy/paste jobs resulting in whatever “¬” is.

Until now, I’ve always typed abominations like this into an online converter. But this chore is evergreen, so I decided to put in a little more effort so I’d never have to spend more than a few moments on it again. I created Decimancer, a little tool that tries its darnedest to make sense of strings of numbers to spit out nicely formatted decimal degrees. Try it out!

Quick Convert Powered by Decimancer

Results appear as you type.

For batch conversion of entire spreadsheets, head over to the full Decimancer app.