Convert Angles From Radians to Degrees in Excel

If Excel had a personality, it would be that brilliant friend who’s amazing at math but occasionally forgets humans prefer degrees. Excel loves radians in many trigonometric situations, which is great for engineers and mathematiciansbut not so great when you’re trying to explain a 30° angle to your team and Excel keeps handing you 0.523598776.

The good news: converting angles from radians to degrees in Excel is incredibly easy. In this guide, you’ll learn the fastest built-in formula, a manual conversion method, common mistakes to avoid, and a few practical examples that make the whole thing stick. Whether you’re working on geometry, engineering, data analysis, or just untangling a spreadsheet someone else built at 2 a.m., this tutorial has you covered.

Why Convert Radians to Degrees in Excel?

Radians and degrees are just two ways to measure the same thing: angles. Excel often uses radians in trig and inverse trig workflows, but many people read and report angles in degrees.

That means angle conversion in Excel comes up all the time when you’re:

• Checking outputs from trigonometric functions
• Building engineering or construction spreadsheets
• Presenting results to non-technical teams
• Comparing sensor or instrument data
• Creating charts or dashboards with angle labels

In short: Excel is doing the math correctlyyou just need to translate the angle into the format humans usually expect.

The Fastest Method: Use the DEGREES Function

Excel formula for radians to degrees

The easiest way to convert radians to degrees in Excel is:

=DEGREES(angle)

Where angle is a radian value, a number, or a cell reference.

Examples

• =DEGREES(PI()) → 180
• =DEGREES(PI()/2) → 90
• =DEGREES(1) → 57.29577951 (approximately)

If your radian values are in column A (starting in A2), enter this in B2:

=DEGREES(A2)

Then drag the fill handle down to convert the whole list.

Manual Method: Convert Radians to Degrees Without DEGREES()

If you want to see the math behind the curtain (or you’re building a workbook where formula transparency matters), use the standard conversion formula:

Degrees = Radians × 180 ÷ π

In Excel, that becomes:

=A2*180/PI()

This produces the same result as =DEGREES(A2) in most use cases.

When the manual formula is useful

• You want to show the conversion logic directly in the sheet
• You’re teaching students or coworkers how the formula works
• You’re troubleshooting a complex workbook and want a visible math path

Functionally, both methods are solid. If you want clean and readable formulas, use DEGREES(). If you want “math class but make it spreadsheet,” use *180/PI().

Step-by-Step: Convert a Column of Radians to Degrees in Excel

Example setup

Let’s say you have radian values in column A:

Conversion steps

1. Click cell B2.
2. Enter: =DEGREES(A2)
3. Press Enter.
4. Drag the fill handle down from B2 to copy the formula.

Your results in column B should be approximately:

• 30
• 60
• 90
• 180

Round the output (optional)

If you don’t need 12 decimal places staring into your soul, wrap the formula in ROUND():

=ROUND(DEGREES(A2),2)

This keeps your spreadsheet neat and much easier to read in reports.

Radians vs Degrees in Excel Trig Functions (Important!)

Here’s where many people get tripped up: Excel’s trig functions like SIN(), COS(), and TAN() expect angles in radians, not degrees.

So if you type:

=COS(60)

Excel treats 60 as 60 radians, not 60 degreeswhich is definitely not what most humans mean.

Correct ways to calculate cosine of 60 degrees

• =COS(RADIANS(60))
• =COS(60*PI()/180)

Both formulas return 0.5.

When DEGREES() becomes extra helpful

Inverse trig functions such as ASIN(), ACOS(), and ATAN() return results in radians. If you want a degree result, wrap them in DEGREES().

Example:

• =ASIN(-0.5) → returns radians
• =DEGREES(ASIN(-0.5)) → returns -30

This is a great pattern for cleaner dashboards and easier interpretation.

Common Errors When Converting Radians to Degrees in Excel

1) Mixing up radians and degrees

The biggest mistake is feeding degree values into formulas that expect radians (or vice versa). If your numbers look “wildly wrong,” this is usually the culprit.

2) Using text instead of numbers

If a cell contains text like "1.57 rad" instead of a pure numeric value, DEGREES() may return an error.

Fix it by cleaning the input first or separating units into another column.

3) Forgetting parentheses in manual formulas

This is correct:

=A2*180/PI()

This is not:

=A2*180/PI (because PI must be used as PI())

4) Over-formatting and thinking the value changed

Formatting a cell to show a degree symbol (like 45°) changes appearance, not the underlying number. Excel still stores the numeric value, which is exactly what you want.

How to Display a Degree Symbol in Excel Results

Want your converted angles to look polished? Add a degree symbol without breaking calculations.

Option 1: Custom number format (best for calculations)

Keep the result numeric, then apply a custom format:

0.00°

This displays values like 57.30° while preserving the number for charts and formulas.

Option 2: Concatenate the degree symbol (display text only)

=ROUND(DEGREES(A2),2)&"°"

This looks nice, but it converts the result to text. Use this only when you need a label, not a calculable value.

Practical Excel Examples for Real Work

Example 1: Convert sensor output from radians to degrees

If a sensor exports angular position in radians to column A, use:

=ROUND(DEGREES(A2),3)

Now your operators or clients can read the values in degrees without doing mental math (or dramatic guessing).

Example 2: Convert inverse trig outputs for reporting

Suppose a formula calculates an angle using arc tangent:

=ATAN(B2/C2)

To report it in degrees:

=DEGREES(ATAN(B2/C2))

Example 3: Create a reusable conversion column

If column A is always radians, label column B as Angle (Degrees) and use:

=IF(A2="","",DEGREES(A2))

This avoids clutter by leaving blank rows blank instead of showing zeros.

Tips for Cleaner, Faster Excel Angle Conversion

• Use DEGREES() for readability: It’s obvious what the formula is doing.
• Use ROUND() for reports: Too many decimals can make good data look messy.
• Label units clearly: Name columns “Radians” and “Degrees” to prevent future confusion.
• Keep raw data separate: Store original radian values in one column and converted results in another.
• Test with known values: PI() should convert to 180, and PI()/2 should convert to 90.

Frequently Asked Questions

Can Excel automatically switch from radians to degrees mode?

No. Excel doesn’t have a calculator-style DEG/RAD mode switch for trig functions. Instead, you convert values using RADIANS() or DEGREES() as needed.

What is the best formula to convert radians to degrees in Excel?

=DEGREES(angle) is the best and simplest option.

Can I convert degrees back to radians in Excel?

Yesuse =RADIANS(angle) or the manual formula =angle*PI()/180.

Why does Excel give strange results for SIN, COS, or TAN?

Because Excel expects radians. If your angle is in degrees, wrap it with RADIANS() first.

Experience Section: Real-World Lessons from Using Radian-to-Degree Conversion in Excel (Extended)

One of the most common “Excel mystery” moments happens when someone inherits a workbook and sees angle values that don’t make intuitive sense. A team member expects to see 45, 90, or 180, but the spreadsheet shows values like 0.7854, 1.5708, or 3.1416. At first glance, it looks like the file is broken. In reality, it’s usually just a radians-vs-degrees mismatchand once you know that, the fix is fast.

In practical workflows, the biggest improvement comes from standardizing how angle data is stored and displayed. For example, analysts often keep raw imported values in radians (because that’s how software, sensors, or formulas output them), then create a clean reporting column in degrees using =ROUND(DEGREES(A2),2). This approach prevents accidental data loss and keeps calculations stable while making the spreadsheet readable for managers, clients, or teammates who don’t think in radians.

Another common scenario appears in geometry and engineering spreadsheets. Someone uses inverse trig functions like ATAN() or ASIN() to calculate angles from dimensions. The math is correct, but the reported angle looks “wrong” because the result is in radians. Wrapping the formula with DEGREES() instantly makes the output intuitive: =DEGREES(ATAN(opposite/adjacent)). This small change can prevent miscommunication in project reviews, especially when numbers move from a technical worksheet into a presentation or printed report.

Formatting also matters more than people expect. A spreadsheet full of long decimal results can make good data look messy or suspicious. Teams often get better adoption by combining conversion with formattingrounding values and applying a custom number format like 0.0°. The data stays numeric, charts work correctly, and the sheet looks polished. That’s a win-win, and it reduces the chances of someone “fixing” the workbook by converting everything to text labels.

There’s also a teaching benefit. When training beginners, showing both formulas side by side=DEGREES(A2) and =A2*180/PI()helps them trust Excel more. The function is simpler, but the manual formula explains the logic. Once users see that PI() converts cleanly to 180, the whole concept clicks. After that, they tend to make fewer mistakes when working with SIN(), COS(), and TAN().

Finally, the most valuable habit is labeling units everywhere. It sounds basic, but it saves hours. Headers like Angle (rad) and Angle (deg) prevent confusion, especially in shared workbooks with multiple contributors. Many spreadsheet headaches aren’t math problems at allthey’re labeling problems in disguise. If you convert angles from radians to degrees in Excel regularly, a clear structure, a simple DEGREES() formula, and consistent formatting will make your sheets faster to use, easier to audit, and far less likely to start an office argument about whether Excel is “wrong.” (Spoiler: it’s usually not.)

Conclusion

Converting angles from radians to degrees in Excel is simple once you know the right formula. The built-in DEGREES() function is the fastest and cleanest method, while *180/PI() is a great manual alternative when you want to show the math. If you’re using trigonometric functions, remember that Excel typically expects radiansso converting values at the right step can save you from confusing results and late-night spreadsheet detective work.

Whether you’re building technical models, classroom worksheets, or business reports, a clear radians-to-degrees workflow makes your Excel files easier to read, easier to trust, and much easier to share.