Blog
Excel's CONVERT() function works — if you can remember the exact unit codes. =CONVERT(70,"kg","lbm") converts 70 kg to pounds. But mistype "lbs" instead of "lbm" and you get a #N/A error. Our converter uses dropdown menus — no codes to memorize.
If you have ever tried to use Excel's CONVERT function for a quick unit conversion, you have probably experienced the frustration: you type =CONVERT(100, "km", "miles") and get a #N/A error because the correct code is "mi", not "miles". Or you try "lbs" for pounds and discover it has to be "lbm". The function works, but it was designed for people who have memorized a list of cryptic abbreviations — not for someone who just wants to know how many pounds 70 kilograms is.
| Feature | WildandFree Converter | Excel CONVERT() | Google Sheets CONVERT() | Custom Excel Formula |
|---|---|---|---|---|
| Requires formula knowledge | ✓ No — dropdown menus | ✗ Must know =CONVERT() syntax | ✗ Must know =CONVERT() syntax | ✗ Must write formula from scratch |
| Case-sensitive codes | ✓ No codes at all | ✗ "C" not "c", "lbm" not "lbs" | ✗ Same as Excel | ✓ N/A (uses cell references) |
| Handles all unit types | ✓ 8 categories with all common units | ~Most units, some missing | ~Most units, some missing | ~Only what you build |
| Risk of typo errors | ✓ None — select from lists | ✗ High — cryptic codes | ✗ High — same codes | ~Medium — formula errors |
| Batch conversion | ~One value at a time | ✓ Drag formula to convert entire columns | ✓ Drag formula to convert entire columns | ✓ Drag formula down |
| Works on mobile | ✓ Fully responsive browser tool | ✗ Mobile Excel is limited | ~Google Sheets mobile works | ✗ Same Excel limitations |
| Works offline | ✓ Browser-based, works offline | ✓ Desktop Excel works offline | ✗ Requires internet | ✓ Desktop Excel works offline |
| Free | ✓ Completely free | ✗ Requires Excel license | ✓ Free with Google account | ✗ Requires Excel license |
| Instant results | ✓ As you type | ~After pressing Enter | ~After pressing Enter | ~After pressing Enter |
| Learning curve | ✓ Zero — intuitive interface | ✗ Must learn unit codes | ✗ Must learn unit codes | ✗ Must know math formulas |
If you do use Excel's CONVERT function, here are the codes that trip people up. Note the case sensitivity — "C" works, "c" does not.
| What You Want | Correct Code | Common Wrong Guesses | Notes |
|---|---|---|---|
| Pounds | lbm | lbs, lb, pounds, LBM | lbm = pound-mass (physics term) |
| Kilograms | kg | KG, kgs, kilogram | Lowercase only |
| Ounces | ozm | oz, ounce, OZM | ozm = ounce-mass |
| Celsius | C | celsius, c, cel | Uppercase C only |
| Fahrenheit | F | fahrenheit, f, fah | Uppercase F only |
| Kelvin | K | kelvin, k, kel | Uppercase K only |
| Miles | mi | miles, mile, MI | Lowercase only |
| Kilometers | km | KM, kms, kilometer | Lowercase only |
| Feet | ft | feet, foot, FT | Lowercase only |
| Inches | in | inches, inch, IN | "in" also means input range in some contexts |
| Meters | m | meters, meter, M | Lowercase m only |
| Gallons (US) | gal | gallon, gallons, GAL | Lowercase only |
| Liters | l | liter, L, liters | Lowercase L only |
| Fluid ounces | oz | fl_oz, floz, fl oz | Just "oz" in Excel |
| Hours | hr | h, hour, hours | hr only |
| Minutes | mn | min, m, minute | mn — not min |
This table covers roughly half the codes people get wrong. The full list is in Microsoft's documentation, but even experienced Excel users regularly mistype these.
Excel's CONVERT function has been available since Excel 2007, and people have been searching for alternatives ever since. The core issues:
=CONVERT(100, "C", "F") works. =CONVERT(100, "c", "f") returns #N/A. There is no warning, no suggestion, no "did you mean" — just a flat error. For a function designed to make conversions easier, this is needlessly strict.
Why is pounds "lbm" and not "lbs"? Because "lbm" stands for "pound-mass" — a distinction from physics between mass and force that is irrelevant for 99% of users converting body weight or package weight. Similarly, ounces are "ozm" (ounce-mass), not "oz" (which Excel uses for fluid ounces). This kind of thing makes sense to an engineer but baffles everyone else.
Excel's CONVERT function does not support every unit. For example, it has limited data size conversions (no terabytes in older versions), no stone (the UK weight unit), and inconsistent coverage of less common units. If the unit you need is not in Excel's list, you are stuck writing a manual formula.
When CONVERT fails, it returns #N/A. That is it. No indication of whether the from_unit is wrong, the to_unit is wrong, the units are incompatible (trying to convert kg to miles), or the syntax is malformed. You have to troubleshoot blind.
Here is the honest take: if you are converting an entire column of measurements in a spreadsheet, Excel's CONVERT() function is genuinely faster. Apply the formula once and drag it down — 10,000 conversions in seconds. No online tool matches that for batch operations.
Excel also wins when conversions are part of a larger calculation. If you need to convert raw data, apply a formula, sum results, and chart the output — all within one spreadsheet — staying in Excel makes sense. Opening a browser-based tool for each individual value would be slower.
Use cases where Excel CONVERT is the right choice:
For quick, one-off conversions — which is what most people need — a browser-based converter with dropdown menus is faster and less error-prone than CONVERT():
Google Sheets has the same CONVERT function with the same syntax: =CONVERT(value, "from_unit", "to_unit"). It uses the same unit codes, has the same case sensitivity, and returns the same unhelpful #VALUE! error when a code is wrong.
One advantage of Google Sheets: it is free and browser-based, so you do not need an Excel license. But the CONVERT function has all the same pain points — cryptic codes, case sensitivity, and limited error messages.
Google Sheets also supports =CONVERT() in the mobile app, though typing formulas on a phone is rarely a pleasant experience.
If you find CONVERT's unit codes frustrating, you can always write the conversion formula directly. These are the common ones:
Manual formulas avoid the unit code problem entirely. They are transparent (you can see exactly what math is happening) and work in any spreadsheet application. The tradeoff: you need to know the conversion factor, while CONVERT looks it up for you (if you can get the code right).
Convert any unit instantly — dropdown menus, no formula codes, no #N/A errors. Just pick your units and type a number.
Open Unit Converter