ThisCalculator

Everyday

Feet to Acres Conversion in Excel (2 Easy Ways)

Updated · Standard formula, shown below

Area (acres) 0.4591 acres
Area (sq ft)
20,000 sq ft
Result
Length (ft)
200 ft
You entered
Width (ft)
100 ft
You entered

To convert feet to acres in Excel, divide the area in square feet by 43,560, because one acre equals exactly 43,560 square feet. If your measurements are in linear feet (length and width), multiply them first to get square feet, then divide by 43,560. This article shows you the formulas, a few real-world examples, and how to avoid the most common mistakes.

Formula

The conversion relies on one fixed number: 1 acre = 43,560 square feet. That is a legal definition in the United States and is also used in most other countries that still use the acre for land measurement. The formula is:

Acres = Square feet ÷ 43,560

If you only have linear dimensions, first calculate the area in square feet:

Square feet = Length (ft) × Width (ft)

Then apply the conversion. For example, a rectangular plot that is 200 feet long and 100 feet wide has an area of 20,000 square feet. Dividing 20,000 by 43,560 gives approximately 0.459 acres.

Worked Example

Using the default values from the calculator above (length = 200 ft, width = 100 ft):

  1. Calculate square feet: 200 × 100 = 20,000 sq ft
  2. Divide by 43,560: 20,000 ÷ 43,560 = 0.459136…
  3. Round to 4 decimal places: 0.4591 acres

The calculator shows 0.4591 acres, which matches. If you instead have a single value in square feet, just enter that number directly in place of the product.

Why 43,560? A Quick Background

The acre is an old unit that dates back to medieval England. It was originally defined as the amount of land a yoke of oxen could plow in one day—roughly a furlong (660 feet) by a chain (66 feet). Multiplying those gives 43,560 square feet. That definition was standardized over time and remains the official value in the U.S. customary system and the imperial system. Because it is an exact number, the conversion is always precise—there are no rounding issues in the definition itself.

In Excel, you do not need any special add-ins or functions. A simple division formula works everywhere, including Google Sheets, LibreOffice, and most other spreadsheet programs.

How to Write the Formula in Excel

There are two common scenarios, and each has a slightly different approach.

Scenario 1: You have square feet already

If a cell (say A1) contains the area in square feet, put this in another cell:

=A1/43560

Format the result cell as a number with 4 or 5 decimal places to see a meaningful fraction of an acre. If you want to show the result in acres and square feet separately, you can use =INT(A1/43560) for whole acres and =MOD(A1,43560) for the remaining square feet.

Scenario 2: You have length and width in feet

If length is in B2 and width is in C2, the formula is:

=(B2*C2)/43560

This multiplies the two dimensions first, then converts. Make sure both cells are in feet—if one is in yards or meters, convert them first (1 yard = 3 ft, 1 meter ≈ 3.28084 ft).

Common Mistakes and How to Avoid Them

  • Mixing units: The most frequent error is entering one dimension in feet and the other in yards or meters. Always verify the unit of each input.
  • Using the wrong conversion factor: Some people mistakenly use 43,560 square yards (which is actually a different unit) or 4,840 (square yards in an acre). Stick to 43,560 for square feet.
  • Forgetting to multiply length × width: If you only have a single linear measurement, you cannot get an area. You need two perpendicular dimensions.
  • Rounding too early: If you round the square feet to a whole number before dividing, you may lose precision. Keep full precision in the intermediate step.
  • Formatting the result as a date or fraction: Excel sometimes auto-formats cells. Set the result cell to “Number” with the desired decimal places.

When to Use This Conversion

You will need this conversion in real estate, agriculture, landscaping, and construction. For example:

  • Calculating the size of a residential lot from a deed that lists dimensions in feet.
  • Estimating how much seed, fertilizer, or sod is needed for a lawn area.
  • Comparing the size of two parcels when one is given in acres and the other in square feet.
  • Converting survey data from feet to acres for a property report.

The same formula works for any shape if you know the total area in square feet. For irregular shapes, you may need to break the area into rectangles or triangles, calculate each part, and sum them before converting.

Alternatives and Related Conversions

If you need to convert between other land units, here are the key factors:

  • 1 acre = 4,840 square yards (since 1 yard = 3 ft, 1 sq yard = 9 sq ft, and 43,560 / 9 = 4,840)
  • 1 acre = 0.404686 hectares (a metric unit)
  • 1 hectare = 10,000 square meters
  • 1 square mile = 640 acres

In Excel, you can also use the built-in CONVERT function for some unit pairs, but it does not support acres directly. So a manual division is the most straightforward method.

Frequently Asked Questions

How do I convert square feet to acres in Excel without a calculator?

Simply divide the square footage by 43,560. For example, if cell A1 has 87,120, enter =A1/43560 in another cell. The result will be 2, because 87,120 ÷ 43,560 = 2.

Can I convert feet (linear) directly to acres?

No, because feet measure length and acres measure area. You must have two perpendicular dimensions to get an area. If you have a single length, you cannot determine the acreage without knowing the other dimension.

What if my lot is not a perfect rectangle?

Break the shape into rectangles, triangles, or other simple shapes. Calculate each area in square feet, sum them, then divide by 43,560. For very irregular boundaries, you may need a surveyor or GIS software.

Is the acre the same in every country?

In most English-speaking countries, the acre is defined as 43,560 square feet. However, some countries use different definitions historically, but the international acre is the most widely accepted. Always confirm the local definition if you are working internationally.

How many decimal places should I use for acreage?

For most purposes, 2 to 4 decimal places is enough. For example, 0.4591 acres is more precise than 0.46 acres. If you need extreme accuracy for legal documents, keep more decimals or use the exact square footage.

Can I use this formula in Google Sheets?

Yes, the same formula works in Google Sheets, LibreOffice, and any spreadsheet that supports basic arithmetic. Just type the division formula and it will calculate.

Related

Formula used
in len | Length (ft) | ft | 200 | 0
in wid | Width (ft) | ft | 100 | 0
out acres | Area (acres) | acres | (len * wid) / 43560 | 4
out sqft | Area (sq ft) | sq ft | len * wid | 0

Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work

Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.