Excel Site Analysis: Methods, Limits, and Examples

How-to basics · Updated November 21, 2026

Excel site analysis means organizing information about a property or project site in a workbook so you can compare conditions, calculate areas, and document early decisions. It works well for structured data and simple calculations, but it is not a substitute for GIS, surveying, engineering, or planning review when precise locations or professional judgments are required.

What site analysis in Excel can cover

Site analysis is the process of examining a place and its surroundings before making a design, purchase, planning, or development decision. The exact factors depend on the project. A building concept might examine parcel size, access, slopes, utilities, nearby uses, and environmental constraints. A retail location comparison might focus on population, travel times, visibility, competing businesses, and available floor area.

Excel is useful when information arrives in tables, when calculations need to be transparent, or when several candidate sites must be compared using the same criteria. A workbook can collect measurements, preserve source notes, calculate subtotals, and create charts for a meeting. It cannot independently verify that a boundary, zoning designation, flood condition, or utility location is correct.

Think of the spreadsheet as an analysis and communication tool rather than a map-making or approval system. A tidy workbook can make assumptions visible, but a polished chart does not make uncertain source data authoritative.

Plan the workbook and its data

Before entering information, decide what one row represents. For a comparison, one row per site is often practical. For detailed constraints, use a separate table with one row per feature per site; this avoids forcing multiple constraints into a single cell. Use clear column headings, consistent units, and a stable site identifier such as Site A or a parcel reference.

Potential fields include:

  • Identification: site name, address, parcel reference, assessment date, and source.
  • Physical conditions: gross area, approximate slope, frontage, access points, and observed site features.
  • Planning context: reported zoning, permitted-use notes, setbacks, easements, and relevant plan references.
  • Constraints and services: known flood or habitat information, utility availability, road access, and required follow-up.
  • Comparison measures: estimated usable area, access rating, data confidence, or other criteria chosen for the project.

Do not mix units in a column. If some sources give acres and others square feet, convert them into a consistent analysis unit and retain the original value or source in another column. Record whether a figure is measured, reported by a source, estimated from a map, or assumed. Add a date because public datasets and site conditions can change.

Build a clear analysis workflow

A dependable workbook separates raw information from calculations and presentation. A simple arrangement is a Sources sheet, a Site Data sheet, a Calculations sheet, and a Summary sheet. A small project may not need four sheets, but separating inputs from derived results makes checking easier.

  1. Define the question. Decide whether the workbook is comparing locations, describing one parcel, or testing a preliminary layout. This determines which data is relevant.
  2. Gather and cite inputs. Record the source, date, units, and limitations beside each important value. Keep links or document references where appropriate.
  3. Standardize the data. Use one row per site or feature, consistent labels, and consistent units. Avoid merged cells in data tables because they interfere with sorting and filtering.
  4. Calculate derived measures. Use formulas for repeatable arithmetic, and label estimates so users do not mistake them for surveyed or approved figures.
  5. Compare and communicate. Use a summary table and restrained charts to show important differences. Keep detailed source records available for anyone reviewing the conclusion.
  6. Check the result. Recheck units, missing values, formulas, source dates, and any assumptions that materially affect the comparison.

In Microsoft Excel for Microsoft 365 on Windows, convert a rectangular data range into a table with Insert > Table, or use Ctrl+T after selecting the range. On Mac, use Command+T or Insert > Table. Tables make it easier to filter records and extend formulas when new rows are added. Use descriptive sheet names and freeze the heading row if the data is long.

Calculate areas and compare sites

Excel can handle arithmetic such as subtracting mapped constraints from a reported parcel area, calculating percentages, or summing cost and area categories. The result is only as reliable as the measurements and definitions behind it. In particular, a calculated net area is not automatically a legally buildable area: setbacks, access requirements, easements, environmental rules, design standards, and other factors may change what is feasible.

For a simple example, suppose a workbook records gross area in B2 and an estimated constrained area in C2, both in hectares. With those values in place, enter this in D2 to calculate the remaining area:

=B2-C2

If B2 is 2.40 and C2 is 0.35, D2 returns 2.05 hectares. This is a straightforward subtraction, not a determination of permitted development area. The input categories must also be defined so they do not overlap or omit relevant constraints.

With gross area in B2 and the calculated remaining area in D2, enter this in E2 to calculate the remaining share of the gross area:

=D2/B2

For the example above, the result is 0.8541667, or about 85.42% when E2 is formatted as a percentage. Use a clear label such as Estimated unconstrained share, rather than a label that suggests a regulatory conclusion.

For multiple sites, apply the same definition and method to every row. A useful comparison may include both the result and a confidence field: for example, high confidence for a documented parcel area, medium confidence for a value interpreted from a public map, and low confidence for an unverified estimate. Define those labels in the workbook rather than assuming every reader uses them the same way.

Use charts and maps appropriately

Charts can make a comparison easier to scan. A bar chart can compare reported parcel areas or travel-time estimates; a stacked chart can show how categories contribute to a total if the categories are mutually exclusive. In Excel, select the relevant data and use Insert > Recommended Charts, then choose a chart that matches the question. Include units, a clear title, and any important date or qualification.

Excel also offers a Filled Map chart for supported geographic data. It is intended to visualize regions such as countries, states, or other recognized geographic areas, not to produce a precise site plan. It does not replace parcel geometry, aerial imagery, topographic mapping, or a spatial overlay. A chart that colors a region cannot establish the exact location of a building, boundary, hazard, or access point.

If a map is needed in a workbook, it can be helpful to include a link to an authoritative map or insert a clearly labeled reference image where appropriate. Keep the map date and source visible. Do not treat an image pasted into Excel as spatially measured data unless it has been properly georeferenced and analyzed with suitable tools.

Choose comparison criteria carefully

Some site comparisons use a scorecard, but scores can create false precision if the criteria are vague or weighted without a reason. Before scoring, write down what each criterion means, the scale, and how missing information is handled. A score of 1 to 5 for access, for example, is not meaningful unless the workbook explains what qualifies as a 1 and what qualifies as a 5.

Separate facts from preferences. Parcel area or a documented road connection may be reported as facts with sources; preference for a particular orientation or neighborhood may be a project-specific judgment. If weighted scores are used, show the weights and the underlying ratings so a reader can see how the total was produced. Test whether changing a subjective rating changes the ranking. A close result may indicate that the sites are effectively tied, or that further information matters more than the current score suggests.

Missing data should not silently become zero. Zero can mean a measured absence, while a blank may mean unknown. Distinguish those cases with an explicit status such as Unknown, Not applicable, or Not yet checked. This is especially important if formulas or rankings use the values.

Common problems and quality checks

The most frequent spreadsheet errors are often basic: mixed units, copied values without sources, hidden rows, inconsistent site names, formulas that fail to include a new row, and confusion between a measured value and an estimate. A visually attractive summary may conceal these issues unless the workbook is structured for review.

  • Check that all areas use the same unit and that conversions are documented.
  • Confirm that formulas reference the intended cells and that copied formulas adjust correctly.
  • Look for blank inputs, duplicate records, and values that are unusually large or small.
  • Keep assumptions and source dates visible, particularly for constraints or planning information.
  • Use conditional formatting sparingly to flag missing information or thresholds; do not rely on color alone to communicate meaning.
  • Ask another reader to trace a key result from the summary back to its inputs and source.

Excel features such as filters, data validation, and conditional formatting can reduce some entry mistakes, but they do not validate the real-world truth of a value. For instance, a dropdown can enforce consistent entries for a confidence category; it cannot confirm that a reported boundary is correct.

When Excel is not enough

Use GIS when the question depends on accurate spatial relationships: whether a parcel intersects a flood layer, how far a site is from a transit stop, what area lies inside a buffer, or how terrain changes across a property. GIS software is designed to manage coordinates, map projections, spatial layers, and spatial analysis. The data quality and correct interpretation still matter, but these tasks are beyond what a normal Excel table or map chart is designed to do.

Use CAD or architectural design software for measured drawings and design geometry, and consult appropriately qualified professionals for surveying, engineering, environmental assessment, or regulatory interpretation as needed. The right tool depends on the decision and the required accuracy. Excel remains useful alongside those tools for schedules, comparisons, assumptions, and tabular summaries; it does not need to be the only tool in the workflow.

Frequently Asked Questions

Can Excel create a site analysis map?
Excel can display certain geographic data with a Filled Map chart and can contain linked or inserted map references. It is not a GIS and is not suited to precise parcel mapping, spatial overlays, or measuring site features from an unreferenced image.

What should a site analysis spreadsheet include?
Include site identifiers, relevant measurements, constraints or context, source and date for important data, units, assumptions, and any calculated comparison measures. The fields should follow the project question rather than a generic template.

Can Excel calculate a buildable area?
It can perform arithmetic on areas supplied to it, such as subtracting an estimated constraint area from a parcel area. That result is not automatically a legally or technically buildable area; applicable rules, overlapping constraints, design conditions, and verified measurements may require professional review.

Is Excel or GIS better for site analysis?
Excel is usually more convenient for tabular comparisons, calculations, and summaries. GIS is the better fit when the analysis depends on accurate locations, boundaries, distances, terrain, or overlays between spatial datasets. Many projects use both.

How do I make a site analysis workbook easier to trust?
Show the source and date for key inputs, distinguish estimates from verified facts, keep units consistent, make assumptions visible, and check formulas against a small worked example. A reviewer should be able to trace a reported result back to its inputs.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.