Home / Science / Humanities and archaeology / Archaeology / Trench and grid recording sheetTool #406

Trench and grid recording sheet: find positions from offsets, levels, grid squares and lat/long (free, in your browser)

Set up a site grid and a trench, then record finds, samples and levels by grid coordinates, tape offsets from a peg or a baseline, with heights from a level and staff. Get grid squares, latitude and longitude, a plan, a printable PDF sheet and a CSV. Your location is used only if you press the GPS button, and nothing is saved or sent.

Keep it one tap away for everyday use.

Bookmark Trench and grid recording sheet?

Press Ctrl + D now. Your browser opens its own bookmark box, where you choose the name and folder.

  1. Grid
  2. Offsets
  3. Points
  4. Sheet
Nothing is uploadedWorks offline once open

Site grid and trench

Grid

Squares are named from their south-west corner. Letters count east from the origin (A, B, C …), numbers count north (1, 2, 3 …).

Trench

Levels

Tie the grid to latitude and longitude (optional)

The latitude and longitude of the grid origin (from a survey-grade GNSS fix or a map), and how far grid north is turned clockwise from true north. Then every point gets a latitude and longitude, and a phone GPS fix can be placed on the grid.

Record a point

Your location is asked for only when you press the button. It stays in this page and is kept with the next point you add.

What it does

Excavation records place every find, sample and level on the site grid. This page does the sums for you as you record, and gives you a clean sheet at the end:

  • Grid squares: from the grid origin and square size, each point gets its square, named by the square’s south-west corner (E1010 N5020) or by letters east and numbers north (C5).
  • Positions three ways: type the grid easting and northing; measure offsets east and north from a peg; or measure along a baseline between two pegs and at right angles to it (right of the line is +, left is −).
  • Heights from a level: give the datum height and the backsight on it once; each staff reading then becomes a height. You can also type heights, or leave them out.
  • Trench check: whether each point lies inside the trench.
  • Latitude and longitude: tie the grid origin to a latitude and longitude, and give the bearing of grid north if the grid is turned. Every point then gets its own latitude and longitude.
  • Phone GPS (optional): press Use my location, and the browser asks your permission. The fix (with its accuracy) is kept with the next point; if the grid is tied to latitude and longitude you can also place the point on the grid from it. Phone GPS is good to a few metres at best, so it suits survey points and surface finds, not finds in a trench.

Nothing is stored or sent. Points live only in this page, so download the CSV or the PDF sheet before you close it.

Worked example

Press Use the example. It sets a made-up grid with origin E 1000, N 5000 and 5 m squares, Trench 1 of 4 × 2 m with its south-west corner at E 1012, N 5021, a datum of 100 m with a backsight of 1.42 m (height of instrument 101.420 m), and the origin at 45.5° N, 73.6° W. Six points are added:

  • F1 at E 1013.250, N 5021.800 with a staff reading of 1.87 m: height 99.550 m, square E1010 N5020, latitude 45.5001961, longitude −73.5998305.
  • F2 from the peg at 1012/5021, 2.40 m east and 1.15 m north: E 1014.400, N 5022.150, height 99.470 m.
  • S1 on the baseline from 1012/5021 to 1016/5021, 3.10 m along and 0.60 m to the left: E 1015.100, N 5021.600.
  • L1 and P1 (a level and a section peg), and F3, a surface find at E 1008.600, N 5017.200 in square E1005 N5015.

The sheet reports 6 points: 5 inside Trench 1, 1 outside, and draws the plan with the grid, the trench and each point by type.

Tips

  • Use a false origin (such as 1000/5000) so all coordinates stay positive.
  • Measure offsets with the tape level and square to the grid; for long offsets a baseline is easier to keep square.
  • The latitude/longitude tie is only as good as the origin’s coordinates. A hand-held GPS reading of the origin is off by metres.

FAQ

How accurate is the latitude and longitude? The sums are within a millimetre of the full ellipsoid answer up to 1 km from the origin. The real limit is how well you know the origin’s position and the grid’s rotation.

Is my location stored? No. It is asked for only when you press the button, it stays in this page, and it is lost when you close or reload it.

Where the numbers come from

  • Baseline-and-offset and levelling (height of instrument = datum + backsight, height = HI − foresight) as in standard field survey practice. Grid to latitude/longitude by Puissant's short-line formulas on the WGS84 ellipsoid (a = 6378137 m, f = 1/298.257223563), using the meridian and prime-vertical radii of curvature.
  • Checked against Vincenty's direct formula on WGS84, written separately in Python: 40 random cases up to 1 km from the origin at latitudes up to 60° agreed to better than 0.03 mm per metre (under 1 mm at 1 km); the inverse returns the grid point to 1e-9 m.
  • The example grid, trench, points and origin coordinates are made up for this tool.

Standard scientific values, such as constants, atomic weights and melting points, are facts found in every textbook; we name where ours were checked. If you are an author or publisher and want a value, a credit or a table changed or removed, tell us and we will act quickly.

Last updated 2026-11-09.

Related tools

Traverse calculator #132 Paste or open a survey traverse as bearings and distances or as angles and distances. Get the angular and linear misclosure, the precision ratio, Bowditch or transit adjusted coordinates, the area inside a loop, and the bearing and distance between points and where two lines or two distances meet. Level book reducer #133 Paste or open a levelling field book (back, intermediate and fore sights). Get reduced levels by both rise-and-fall and height of collimation, every arithmetic check, the closing error against a benchmark or loop, the allowed misclosure from your own k, adjusted levels and a profile. GPS track analyser #134 Open a GPX file or paste a CSV of time, latitude, longitude and elevation. Get the distance on the WGS84 ellipsoid, moving and stopped time, average and top speed, climbing with a noise threshold, splits per km or mile, a plan, an elevation profile and a speed chart. The file never leaves your device. Harris matrix builder #403 Type or open your context relations (above, below, cuts, same as, contemporary with), find impossible loops and contradictions, drop redundant relations, and get a layered Harris matrix as SVG, PNG, PDF or CSV. Nothing is uploaded. Artefact measurement scale tool #404 Open a photo of a find with a scale bar in it, tap both ends of the bar and type its length, then measure lengths, edge angles and outline areas in millimetres. Includes a perspective check, click uncertainty, an annotated PNG and a CSV. The photo never leaves your device. Seriation and correspondence analysis #405 Paste or open a table of type counts per site, and get a correspondence analysis (inertia per axis, site and type scores, map), the sites and types ordered along the first axis, a battleship (frequency seriation) plot and the Brainerd-Robinson similarity matrix. Nothing is uploaded.