Conversion of UTM (X,Y) Coordinates to Lat -Long and Lat-Long to UTM (X,Y)

Hi Friends Today I am going to explain the procedure for conversion of UTM (X,Y) coordinates  to Lat-Long (Degree -Minute-Seconds).vice versa........


First Step Download the Excel Sheet from the link mentioned below.

Coordinate Converter

You will see four different sheets in that excel workbook. Choose the Respective Sheet as per your requirement.


(1) UTM(X,Y ) to Lat-Long  Conversion............

Choose Batch Convert UTM to Lat-Long sheet.

Fill the first D, E, F and G columns

You will get the output in Green Highlighted Cells........

(2) Conversion from Lat-Long to X,Y(Northing or Easting)...............

Fill D, E,F,G,H and I Columns You Will get Out put in Green Highlighted cells

That it Simple Friend go through it Enjoy ...............

Arunachal Pradesh Visit .......Its Different.....Its Nice.....Its Difficult.....

In 2017 February I got a chance to visit Arunachal Pradesh State for discussion and finalization of 
the alignment of 3 roads. First one is  Yingikiong to Bishing, Seond is from Zido to Singha and Final one is Khanu to Konsa Road it is near to Nagaland...........


To reach Arunachal Pradesh Firstly I traveled by 3 modes mainly........
1. Air way.......New Delhi to Dibrugarh (Assam).
2. Waterway...... Dibrugarh to Pasighat (Arunachal Pradesh) Ferry Ride.
3.Roadway.........Pasighat to Yingikiong,up to Palling


Inner Line Permit(ILP) is required to visit Arunachal Pradesh.....we got it in Dibrugarh....

To get online ILP click on the link below.

ILP Site

All these ways given nice experiences up to Pasighat trip was awesome, after that feeling got diverted.

Lets have a look of my journey through Pics......

Pilot announced that hello passengers you cane see the awesome view of  Mount Everest............So I captured it ........... 

Google Earth View not from Computer............it is from Flight..........

Ferry Ride From Dibrugarh.................almost 2 to 3 hours taken to reach

Bogi beel Bridge under Construction.........

Roadway Started from Pasighat to Yingikiong......... Rain Started yaar....... 

Project Site Some where like this..........

you cant be sure that there is road untill you move on 

some where we got strucked........

                                                             Awesome view of  Dense hill.

Land slide issues........2 hours no movement on the road.......

Pure water facilities are awesome...............Like this........