Sign In

How to Convert Latitude and Longitude to UTM

Last updated 26 September 2026

Turn a sheet of latitude and longitude into UTM or national grid eastings and northings, and save them to Excel, CSV or DXF.

What you need

  • A sheet with LATITUDE and LONGITUDE columns in decimal degrees (25.2048, not 25°12'17" — see DMS to decimal degrees if yours are in degrees, minutes and seconds). Southern latitudes and western longitudes are negative.
  • The grid you want the eastings and northings on. For UTM, that's the zone the site is in — see how to find your UTM zone.

Step by step

  1. Open the sheet in the web app or the Windows app, or paste the rows with their heading row.
  2. Under Coordinate system, choose Latitude and longitude already — no conversion. The points should land in the right place on the map straight away.
  3. Open Quality checks and find the box Grid for exported coordinates. Type the grid there: an EPSG code such as 32640 for UTM zone 40 North, or part of its name. The line under the box names the grid it found, so you can check it's the right one.
  4. Save Excel or CSV. The sheet carries two new columns — the grid's easting and northing — beside your latitude and longitude, to three decimal places (millimetres). DXF is drawn on that grid too.

UTM EPSG codes

On WGS 84, UTM zones north of the equator are 326 followed by the zone number, and south of it 327: zone 40 North is EPSG:32640, zone 43 North is EPSG:32643, zone 55 South is EPSG:32755. The grid pages list the code for every national grid too.

Check the result

  • UTM eastings are between about 160,000 and 840,000 m. A value outside that means the zone is wrong for the site.
  • Northings north of the equator count up from 0 at the equator; south of it they count down from 10,000,000 m.
  • If you have one point with known grid coordinates — a benchmark or control station — compare it. They should agree to millimetres when the datums match.

The other way round

Going from eastings and northings to latitude and longitude is what the program does every time it makes a Google Earth file — see easting and northing to latitude and longitude. Saved Excel and CSV files always include the latitude and longitude columns.

Try it with your own sheet

Open the web app Find your grid

More guides

All 23 guides