How to convert units in excel without writing multiply formulas or helper columns
- Step 1Open the converter (Pro tier) — Unit Converter needs Pro or higher; the Free tier can't run it. Pro handles 50 MB / 100,000 rows — far more than the manual helper-column method comfortably scales to.
- Step 2Drop your file in — Accepts
.xlsx,.xls,.ods, and.csv. Only the first sheet is processed. SheetJS parses it in your browser — no upload, no server round-trip. - Step 3Add a rule instead of a formula — Type the Column name exactly as the header reads, pick × Multiply or ÷ Divide, and enter the Factor. This replaces writing
=A2*factorand dragging it down the column. - Step 4Decide: overwrite or keep the original — Leave New col name blank to overwrite the column in place (like Paste Special → Multiply, but without destroying it irreversibly — your uploaded file is untouched). Type a name to write results to a new column and keep the source, which Paste Special can't do in one move.
- Step 5Stack more rules, no extra cleanup — Click + Add rule for each additional column. There's no helper column to delete per rule — every rule writes its result straight into the output.
- Step 6Download the clean file — Download
units-converted.xlsx— values only, no formulas, no helper columns. The metrics showchangesAppliedso you can confirm every intended cell was rewritten.
Manual Excel methods vs the rule-based converter
Why the rule list beats the spreadsheet workarounds for anything past a single quick column.
| Method | Steps per column | Leaves formulas? | Keeps original? |
|---|---|---|---|
Helper column + =A2*f + Paste Special Values | ~6 (insert, type, fill, copy, paste-values, delete) | Only if you forget the paste-values step | No (overwrites source) |
| Paste Special → Multiply (factor in a cell) | ~4 (type factor, copy, select, paste-multiply) | No | No (destroys source in place) |
| CONVERT() function | Helper column + formula (limited unit list) | Yes (live formula) | Needs separate paste-values |
| JAD Unit Converter (this tool) | 1 rule (column, op, factor) | No | Yes, if you name a new column |
The rule fields, no formula required
Each rule has four inputs plus the + Add rule button. No cell references, no fill handle, no paste-special.
| Field | Replaces | Notes |
|---|---|---|
| Column name | The A:A range you'd select | Match the header exactly (case + spaces) |
| Operation | The * or / in your formula | × Multiply or ÷ Divide only |
| Factor | The constant in =A2*2.20462 | Non-zero, finite, and not exactly 1 |
| New col name | Inserting a helper column | Blank = overwrite in place |
Tier limits
Pro-gated. Free cannot run it. One file per run.
| Tier | Max file size | Max rows | Runs this tool? |
|---|---|---|---|
| Free | 5 MB | 10,000 | No — Pro required |
| Pro | 50 MB | 100,000 | Yes |
| Pro-media | 200 MB | 500,000 | Yes |
| Developer | 500 MB | Unlimited | Yes |
Cookbook
Side-by-side comparisons of the formula you'd otherwise write and the rule that replaces it, plus the before/after cells.
Replace =A2*2.20462 with one rule
The classic kg→lbs helper-column formula, expressed as a rule with no helper column in the result.
Old way: B2: =A2*2.20462 (then fill down, copy, Paste Special Values, delete A) New way (one rule): Column = Weight_kg, × Multiply, Factor = 2.20462, New col = Weight_lbs Input: Weight_kg = 10 Output: Weight_kg = 10, Weight_lbs = 22.0462 (no formula in cell)
Overwrite in place, like Paste Special Multiply
Leaving the new-column field blank overwrites the column — same end state as Paste Special → Multiply, but your uploaded file is never modified.
Rule: Column = Price_cents, ÷ Divide, Factor = 100, New col = (blank) Input: Price_cents = 1999 Output: Price_cents = 19.99 (header unchanged; rename if needed)
Five columns, five factors, zero helper columns
The scenario that makes the manual method painful — five different conversions — collapses to five rules in one pass.
Rule 1: Weight_kg × Multiply 2.20462 → Weight_lbs Rule 2: Height_cm × Multiply 0.393701 → Height_in Rule 3: Dist_km × Multiply 0.621371 → Dist_mi Rule 4: Vol_L × Multiply 0.264172 → Vol_gal Rule 5: Temp_C × Multiply 1.8 → Temp_scaled (offset added later) One download, no helper columns to delete.
Output has no live formulas to break
Because the result is static values, the file is safe to email — there's no helper column whose deletion would turn other cells into #REF!.
Helper-column risk: recipient opens file, helper col A was deleted
before paste-values → B shows #REF! everywhere
Converter output: Weight_lbs cells contain 22.0462 (a number),
not =A2*2.20462 → nothing to breakNon-numeric cells pass through untouched
Unlike a formula that returns #VALUE! on text, the converter just skips non-numbers and copies them through.
Rule: Weight_kg × Multiply 2.20462 → Weight_lbs Input Weight_kg: Formula =A2*2.20462 would give: 5 → 11.0231 5 → 11.0231 'TBD' → 'TBD' (skipped) 'TBD' → #VALUE! 3.2 → 7.054784 3.2 → 7.054784
Edge cases and what actually happens
Factor of exactly 1
RejectedA rule with factor 1 is rejected as a no-op — there's no point writing a value unchanged. If you only wanted to duplicate a column under a new header, that's a copy operation, not a conversion; this tool won't do it.
Column name doesn't match the header
No cells changedThe Column name has to match the header text exactly — same as selecting the right range for a formula. A typo or case difference means the rule converts nothing and the file is unchanged. If the output equals the input, recheck the header.
Blank New col name overwrites in place
By designLeaving New col name empty overwrites the source column — equivalent to Paste Special → Multiply. The header keeps its old name even though the unit changed. Rename the header afterward if the label matters, or set a New col name to keep both columns.
Offset conversions (temperature)
Not supportedThere's no add/subtract operation, so a formula like =A2*1.8+32 (°C→°F) can't be a single rule. Do the ×1.8 here and add the +32 in an Excel formula column, then flatten it to a value with Formula to Value: /excel-tools/excel-formula-to-value
Text-stored numbers with commas
Partial parseWhere a formula like =A2*2 would also fail on text, the converter's parseFloat stops at the first non-digit. "1,000" parses as 1, and "5 kg" parses as 5 (unit dropped). Store the column as real numbers for correct results; the Format Inspector shows which cells are text: /excel-tools/excel-format-inspector
Source file with formulas in the target column
Reads the valueFiles are read with computed values, so a cell containing a formula is converted on its current result, not its formula text. The output is values-only regardless. If you want to flatten formulas across the whole sheet first, use Formula to Value: /excel-tools/excel-formula-to-value
Multi-sheet workbook
First sheet onlyOnly the first sheet is read and written; other sheets are dropped. The output is always a single-sheet Converted workbook. Consolidate to the first sheet before uploading.
Two rules writing to the same column
Last rule winsIf two rules overwrite the same target (same blank source or same New col name), they apply in listed order and the later one wins per row. Give each conversion its own output column to avoid surprises.
Floating-point display
By designResults round to 10 decimal places, so you won't see the 0.30000000000004 artefacts a raw formula sometimes shows. For a fixed display precision, apply ROUND() in Excel after download — the tool has no precision setting.
Formatting and extra sheets
Not preservedThe values-only output drops cell formatting, conditional formatting, and any sheet beyond the first. That's the trade for a clean, formula-free file — re-apply formatting in Excel if you need it.
Frequently asked questions
Do I need a helper column to convert units this way?
No. The converter writes results directly into the column (or a new one you name). There is no helper column in the output and nothing to delete afterward — that's the whole point of the rule-based approach.
Will there be live formulas in the downloaded file?
No. The output is values-only. Converted cells hold plain numbers, not =A2*factor, so there are no formulas to break if the file moves to another machine or a column is later deleted.
How is this different from Paste Special → Multiply?
Paste Special → Multiply overwrites the source range in place and only does one factor at a time. The converter can overwrite in place too (blank New col name) but also lets you keep the original by naming a new column, and lets you stack many columns with different factors in one pass.
Can I keep the original values?
Yes — fill in New col name (e.g. Weight_lbs). The converted values go to that new column and the source stays intact. Leave it blank to overwrite in place. Either way, your uploaded file itself is never modified.
Does it change the data type of converted cells?
No. Numeric cells stay numeric after multiply or divide; the output column holds numbers, not text. Cells that weren't numbers to begin with are skipped and passed through unchanged.
Can I undo a conversion I set up wrong?
Keep your original file — the tool never edits the upload, it only produces a separate download. If a rule was wrong, fix the factor or column and re-run on the original. The result file is disposable.
What about temperature, which needs +32?
Offset conversions can't be one rule, because the tool only multiplies and divides. Apply the multiplicative part here, add the offset in a quick Excel formula, then flatten it with Formula to Value (/excel-tools/excel-formula-to-value) so the final file is still values-only.
Why did my factor of 1 get rejected?
A factor of 1 changes nothing, so it's rejected as a no-op (same for 0 or any non-finite value). Use a real conversion factor. If you genuinely wanted to duplicate a column, that's a copy task, not a conversion.
Will text or blank cells become errors like a formula would?
No. A formula =A2*2 returns #VALUE! on text, but the converter simply skips non-numeric cells and copies them through. Only cells parseFloat reads as numbers are converted.
How many rows can it handle vs the manual method?
Pro processes 100,000 rows / 50 MB in one pass — well beyond where dragging a fill handle becomes painful. Pro-media reaches 500,000 rows and Developer is uncapped. Free can't run the tool.
What format do I get back?
A single-sheet units-converted.xlsx (sheet Converted), values only. It accepts .xlsx, .xls, .ods, and .csv; the download is always a clean XLSX with no formulas or helper columns.
Can I run it without the browser UI?
Yes. GET /api/v1/tools/excel-unit-converter returns the schema; execution is runner-backed via @jadapps/runner. The file never reaches JAD's servers — the runner converts locally and streams back the XLSX.
Privacy first
Every JAD Excel tool runs entirely in your browser using SheetJS and ExcelJS. Your spreadsheets, formulas, and data never leave your device — verified by zero outbound network requests during processing.