ThisCalculator

Everyday

Square Feet to Acres Excel Formula

Updated · Standard formula, shown below

Acres 2.00 acres
Square feet
87120 sq ft
You entered

This calculator converts an area in square feet to acres using the standard conversion factor. Enter the number of square feet, and it returns the equivalent area in acres, rounded to two decimal places. The formula is simple: acres = square feet ÷ 43,560.

Formula

The conversion from square feet to acres uses a fixed constant:

acres = square feet ÷ 43,560

Where:

  • square feet (sq ft) is the area you want to convert.
  • 43,560 is the number of square feet in one acre (a defined value).
  • acres is the resulting area in acres.

This works because an acre is defined as exactly 43,560 square feet. The number comes from the historical definition of an acre as one furlong (660 feet) by one chain (66 feet), which multiplies to 43,560.

Worked Example

Using the default value of 87,120 square feet:

  1. Start with the area: 87,120 sq ft.
  2. Divide by 43,560: 87,120 ÷ 43,560 = 2.
  3. The result is exactly 2 acres.

So 87,120 square feet equals 2.00 acres, matching the calculator output.

Why 43,560? A Quick History

The acre is an old English unit of area. It was originally defined as the amount of land a yoke of oxen could plow in one day. Over time, it became standardized as one furlong (660 feet) by one chain (66 feet). Multiplying those gives 660 × 66 = 43,560 square feet. This definition has been used in the United States and many other countries for centuries, and it remains the legal definition in the U.S. Customary system.

Because the acre is tied to feet, it works directly with square feet. There is no need for extra conversion factors—just the single constant.

How to Use the Formula in Excel

In Excel, the conversion is straightforward. Suppose you have a list of areas in square feet in column A, starting at A2. In cell B2, enter:

=A2/43560

Then drag the fill handle down to apply the formula to other rows. If you prefer a named constant, you could define a cell (say, C1) with the value 43560 and use =A2/$C$1. That makes it easy to update if needed, though the constant never changes.

For a single conversion, you can also type the number directly: =87120/43560 returns 2.

Common Mistakes and Misconceptions

  • Using the wrong divisor: Some people mistakenly use 43,560 as a multiplier instead of a divisor. Always divide square feet by 43,560 to get acres.
  • Confusing square feet with feet: The formula only works for area (square feet). If you have linear feet, you cannot convert directly to acres without knowing the other dimension.
  • Rounding too early: If you round the intermediate result before the final answer, you may lose accuracy. Keep full precision until the end.
  • Forgetting that an acre is larger than a square foot: One acre is roughly 208.7 feet by 208.7 feet (if square). That’s about the size of a football field without the end zones.

When to Use This Conversion

You’ll need this conversion in real estate, agriculture, land surveying, and construction. For example, a residential lot might be listed as 10,000 square feet, but you want to know how many acres that is (about 0.23). Or a farm might be described as 50 acres, and you need the square footage for planning (50 × 43,560 = 2,178,000 sq ft). This formula is also useful when comparing land prices per acre versus per square foot.

Remember that the acre is used primarily in the United States, the United Kingdom, and a few other countries. Most of the world uses hectares or square meters. If you need to convert to metric, first convert square feet to square meters (1 sq ft = 0.09290304 m²), then to hectares (10,000 m² per hectare).

Limitations and Precision

The formula is exact—there is no approximation. However, the precision of your result depends on the precision of your input. If you measure a plot of land with a tape measure, your square footage may have some error. For official land records, surveys use more precise instruments, but the conversion factor remains the same.

When rounding, consider the context. For real estate listings, two decimal places are usually enough (e.g., 0.25 acres). For legal documents, you might need more. The calculator above gives two decimals, which is typical for most uses.

Frequently Asked Questions

How do I convert acres back to square feet?

Multiply the number of acres by 43,560 to get square feet. For example, 3 acres × 43,560 = 130,680 sq ft.

What is the formula in Excel if my square feet are in a different column?

Just reference the correct cell. If your square feet are in cell C5, use =C5/43560. The formula works with any cell reference.

Is there a way to convert square meters to acres in Excel?

Yes. First convert square meters to square feet (1 m² = 10.7639 sq ft), then divide by 43,560. Or use a direct conversion: 1 acre = 4,046.85642 m², so acres = square meters / 4046.85642.

Why do some sources say an acre is 4,840 square yards?

Because 1 yard = 3 feet, so 1 square yard = 9 square feet. Dividing 43,560 by 9 gives 4,840. Both are correct; they are just different units.

Can I use this formula for hectares?

No, hectares are metric. One hectare is 10,000 square meters, which is about 2.471 acres. If you have hectares, multiply by 2.471 to get acres.

What if my area is in square miles?

One square mile is 640 acres. So acres = square miles × 640. You could also convert square miles to square feet (1 sq mi = 27,878,400 sq ft) and then divide by 43,560, but the direct multiplication is simpler.

Related

Formula used
in sqft | Square feet | sq ft | 87120 | 0
out acres | Acres | acres | sqft / 43560 | 2

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.