How to Convert Currency in an Excel Column (Offline)
You have a column of amounts in one currency and want them in another at a rate you choose — not whatever a live feed reports. Here's the offline way that multiplies the whole column by your rate, rounds it, and can add a currency symbol and thousands separators, without sending your figures anywhere.
Last updated: August 2026
| USD | INR @ 83 (new column) | |
|---|---|---|
| 100 | → | ₹8,300.00 |
| 250 | → | ₹20,750.00 |
| 1000 | → | ₹83,000.00 |
Why Excel makes this hard
Excel's built-in Currencies data type and STOCKHISTORY both need a live Microsoft 365 online connection — they send data out to fetch rates, and can go stale or fail when you're offline or the service hiccups. Third-party FX add-ins vary wildly in trust, and many phone home with your numbers. And the "simple" route — a plain =A2*rate formula — means adding a helper column and re-formatting the currency every single time. Most people just want a quick, offline, controllable conversion at a rate they decide.
The 1-click way — Tellsheet's Currency Converter
Select the amount column and run Currency Converter. Enter the rate — 0.92 for USD→EUR, 83 for USD→INR — set how many decimals to round to, and optionally add a currency symbol ($, €, ₹) and thousands separators. It writes a converted column on a new sheet, leaving the original amounts intact. It's fully offline — nothing leaves your machine, and there's no live-FX API that could break or go stale. Pairs with Unit Converter and India ↔ International Numbers.
Frequently asked questions
Does it need to go online?
No — it's fully offline. It multiplies by the rate you supply and nothing leaves your machine.
Where does the rate come from?
You type it in, so you can pin a contract, month-end, or booking rate and get the same result every time.
Can it round and add a symbol?
Yes — choose your decimals, and optionally a currency symbol ($, €, ₹) and thousands separators.
Does it change my original numbers?
No — the converted values go to a new column on a new sheet, so the source amounts stay untouched.
Related Excel guides
Convert a currency column in one click
Currency Converter turns a column of amounts into another currency at your own rate — fully offline, rounded, with an optional symbol and separators.
Get Tellsheet free See pricing