Plotting maps using Eastings & Northings

[Back2Basics]

I have data that includes National Grid Reference (NGR) data for plotting individual points. I can fairly easily convert this to eastings and northings - so I essentially have either that I can use.

However, when creating maps my only option is using Latitude and Longitude - which I don't have.

Is there a way to use my Eastings and Northings to plot points or do I need to convert to Lat Long. If I need to convert, how do I do that? Very struggling on this and would apprecaite any help that anyone can offer.

I think it would be really helpful for Microsoft to include Eastings and Northings for plotting maps but in the meantime any help welcome.

[weca_theo]

I'm joining in late here, but if you have your data in a table, you can use this tool to batch convert between XY and Lon/Lat:

https://gridreferencefinder.com/batchConvert/batchConvert.php

[v-yuezhe-msft]

@Back2Basics,

You would need to convert eastings and northings to Latitude and Longitude, you can perform the process using R script following the guide in the blogs below.

Converting from UTM to Lat, Long
Convert Universal Transverse Mercator (UTM) coordinates to longitude-latitude coordinates in R


Regards,
Lydia

[Back2Basics]

Thanks for the reply Lydia

I have absolutely no experience of R. The suggestions from these links look a bit complicated for me.

Basically I have an easting column and a northing column. How would I go about putting these into something so that for each row it produces the lat/long so that I can plot the point?

Sorry for my iggnorance, still learning.

[v-yuezhe-msft]

@Back2Basics,

You would need to install R studio and required R package to execute the R scripts. 

Another easy way is to use Online tool to convert Eastings & Northings to lat&long, then save your data in flat file, connect to the flat file in Power BI Desktop and create map.

Regards,