Generate Survey Number-Wise Correlation Statement for Village Adangal/Pahani Data

Technical Surveyor Updated August 29, 2026 Online tool

Build a survey-number-wise correlation statement from village Adangal or Pahani Excel data — group farmers by khata/unique number, sum extents, and list correlated survey numbers for AP land resurvey ground validation.

Data format

Expected Excel format

Upload a .xlsx, .xls, or .csv file whose first row contains column headers. Each data row is one Adangal/Pahani record. After upload, map the columns below.

Survey no.	Khata / unique no.	Farmer name	Extent (ac)
100	4521	Rama Rao	1.25
100	4521	Rama Rao	0.50
101	4521	Rama Rao	2.00
102	7830	Lakshmi Devi	0.75

Survey number — main survey number only (without subdivisions like 100-1).

Unique / khata number — one identifier per farmer; rows with the same value are grouped together.

Extent — summed per farmer. Optional concatenate columns merge differing values (e.g. names) with commas.

Use the survey number range (e.g. 1-10 or 1-10, 15, 20-25) to filter which survey numbers appear in the correlation statement.

Upload file

Choose your village Adangal or Pahani export (.xlsx, .xls, or .csv). Column mapping appears after upload.

Map columns

Upload an Excel file to enable column mapping.

Survey number column (survey number without subdivisions)

Unique number column (khata number or farmer unique ID)

Extent column (summed per farmer)

Concatenate columns (optional)

Check columns to merge differing values with commas. Leave all unchecked to merge every column except extent.

Survey number range Include only records whose survey number falls in this range.

Correlation statement

How It Works

1. Upload Adangal/Pahani Excel

Export village Adangal or Pahani data to Excel with a header row, then upload the file here.

2. Map columns & set range

Select survey number, unique/khata, and extent columns. Optionally choose columns to concatenate and enter a survey number range.

3. Generate & export

Review the grouped correlation table — extents summed per farmer, survey numbers listed — then export to Excel or CSV.

About this tool

Excel Adangal/Pahani upload

Survey-number-wise rows

Browser-only processing

DOCX export

Purpose in ground validation

During AP land resurvey, teams often need a survey-number-wise correlation of Adangal or Pahani attributes. Upload the village Excel export, review the mapped columns, then export a DOCX statement for office review.

Data stays local

Excel parsing runs in the browser. Nothing is stored on Technical Surveyor servers. Always verify extents and names against the latest revenue extract before using the statement in notices.

Frequently Asked Questions

What is a survey number-wise correlation statement?

It lists each survey number with aligned Adangal or Pahani attributes for AP land resurvey ground validation — this tool builds the statement from your village Excel export.

Which Excel columns does the generator expect?

Upload your village Adangal or Pahani spreadsheet; the tool maps standard survey-number and extent columns. Review the preview table before exporting DOCX.

Is my village data uploaded to a server?

No. Excel is parsed in your browser. Nothing is sent to Technical Surveyor servers.

Can I use the output for ground validation notices?

Yes. The correlation statement supports Form-26 ground validation workflows — always verify against the latest resurvey SOP before submission.