When a CSV shows ₹ as ₹, the file is saved in UTF-8 but Excel read it with an older single-byte encoding. The fix is to reopen the file through Data > From Text/CSV and set File Origin to 65001: Unicode (UTF-8). If you already saved the garbled version, a Find and Replace can repair most of it.
Why does the rupee symbol turn into ₹?
A text file is only bytes. In UTF-8 the rupee sign takes three bytes, and any program that knows the file is UTF-8 joins them back into one symbol. Excel, when you double-click a CSV that has no special marker at the start, often assumes an older Windows code page where each byte is its own character. Those three bytes then appear as three separate characters, which is the strange string you see. The data in the file is fine; only the reading is wrong.
| What you see | What it should be |
|---|---|
| ₹ | ₹ (rupee sign) |
| – | – (a dash between words or dates) |
| ’ | ’ (an apostrophe in a merchant name) |
| é | é (an accented letter) |
If your sheet shows the left-hand strings anywhere, the same cause applies.
How do you reopen the file with the right encoding?
- Close the workbook without saving. Saving writes the damage into the file.
- Open a blank workbook and choose Data > Get Data > From File > From Text/CSV.
- Pick the statement file. In the preview, set File Origin to 65001: Unicode (UTF-8).
- Check that the preview now shows the rupee sign and plain dashes, and that the delimiter is Comma.
- Choose Load, or Transform Data if you also need to set reference columns to Text.
Older Excel versions use Data > From Text, the legacy wizard. Its first step has a File origin list where you choose 65001: Unicode (UTF-8).
Can you repair characters that are already damaged?
Yes, if the file was only saved as an XLSX and the damage is consistent. Select the affected columns, press Ctrl+H, paste the garbled string into Find what and type the correct symbol in Replace with, then choose Replace All. Do one pair at a time, starting with the rupee sign. For text you cannot easily paste, use a formula in a helper column, such as =SUBSTITUTE(B2,"₹","₹"), then copy the result and paste as values. Always compare against the original download for anything you are unsure about.
Which Save As option keeps the rupee sign?
When you save a cleaned sheet as CSV, choose CSV UTF-8 (Comma delimited) from the Save as type list, not plain CSV (Comma delimited). The plain option writes in your system's older code page, which cannot hold the rupee symbol and swaps it for a question mark. Excel can reopen a CSV UTF-8 file correctly by double-click, because it starts with a small marker that announces the encoding.
What about files you edit in Notepad?
If you open a CSV in Notepad to tidy it and then save, check the Encoding box at the bottom of the Save As dialog. Choose UTF-8, or UTF-8 with BOM where your version offers that option, so Excel recognises it on a double-click. Notepad keeps characters intact; the display problem only appears when the next program guesses the wrong encoding.
Merchant names are the usual casualties. A name with an accented letter or a dash inside a narration shows the same pattern, so look at a few rows rather than only the amount column. If the narration looks right and the symbols look right, the encoding is right.
A two-minute check after every download
- Look at the first narration that contains a rupee sign or dash. If it looks wrong, the encoding is the issue.
- Re-import with UTF-8 rather than fixing cell by cell.
- Keep the untouched original download in a separate folder.
- When you save a cleaned version for a tool that expects a CSV, use CSV UTF-8.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


