How to Convert Preeti Excel Files to Unicode Without Losing Formatting or Data

If you've ever opened an old Excel file and seen perfectly readable Nepali text turn into random symbols after changing fonts, you're not alone. It happens in almost every Nepali office that has been keeping records for more than a few years.

Many Nepali offices, schools, and cooperatives still store years of data in Excel files typed in the Preeti font: student rosters, salary sheets, land records, member lists, voter rolls. These files worked fine for a long time, because everyone who opened them had Preeti installed. The problem shows up the moment that file needs to leave that one narrow environment, get shared with someone on a phone, get imported into a website or database, or get opened on a computer that has never heard of Preeti.

That's when the text that looked like normal Nepali turns into a row of question marks, boxes, or strange English-looking fragments. Nothing is actually broken. The data is exactly where you left it. It's just been speaking a language that only one specific font can translate, and Unicode has become the language everything else expects.

This guide walks through why that happens specifically inside Excel, and how to move your spreadsheet data from Preeti to Unicode without losing your rows, your columns, or your formulas along the way.

What Is the Difference Between Preeti and Unicode?

Preeti is a legacy Nepali font that was never actually Devanagari underneath. When you type in Preeti, each key you press gets stored as an ordinary Latin character, the kind used in English, and the Preeti font simply redraws that character to look like a Nepali letter on screen. It's a visual trick, not a true encoding. Take away the Preeti font, or open the file somewhere it isn't installed, and the trick stops working. You're left staring at the raw Latin characters underneath.

Unicode works completely differently. Every Devanagari letter, matra, and sign has its own fixed, permanent code that every modern device already understands. There's no font dependency involved. A Unicode Nepali document looks exactly the same whether you open it on a five-year-old laptop, a brand-new phone, or inside a web browser on the other side of the world.

This difference is exactly why old Preeti Excel files need real conversion rather than a quick font change. Swapping the font on a Preeti cell doesn't fix anything, it just changes which disguise is being applied to the same underlying Latin characters. Real Nepali font conversion means changing what's actually stored in the cell, not just how it's displayed.

Why Excel Files Break During Conversion

Excel makes this trickier than a Word document or a plain text file, mainly because a spreadsheet almost never contains only one kind of data. A typical sheet mixes Nepali names in Preeti, English labels, dates, ID numbers, and formulas, all sitting in neighboring cells. A few specific things tend to go wrong when people try to convert that mix without a plan:

Missing characters. Some conversion methods handle common letters fine but drop conjuncts or matras that appear less often, so names that use joint letters like क्ष or ज्ञ come out with gaps or wrong characters.

Broken formatting. Column widths, merged cells, and custom number formats can get stripped away if the conversion process involves copying everything out as plain text and pasting it back in without care.

Mixed English and Nepali text. If a column has both, like a name in Nepali followed by a designation in English, running a blanket conversion over the whole column can corrupt the English portion or leave the Nepali portion half-converted.

Incorrect copy-paste process. Copying Preeti cells directly into a Unicode-only field, like a website form or a database, without converting first, produces exactly the kind of broken text this guide is trying to prevent. The characters need to change, not just travel.

Formula-related mistakes. A formula that compares or looks up Nepali text, such as VLOOKUP matching a name across two sheets, depends on the underlying characters being identical. If one sheet gets converted and the other doesn't, matches that used to work silently stop working, even though both cells still look the same to your eyes.

How to Convert Preeti Excel Data Safely

None of this is difficult once you follow it in order. The mistakes above almost always come from skipping a step, not from the conversion itself being hard.

A Real Example: Converting a School Records Spreadsheet

A school office reached out with a familiar situation: years of student and staff records sitting in an Excel file typed entirely in Preeti. One of the column headers, meant to read "प्रतिवेदन" (report), had started showing up as this instead once the file was opened on a laptop without Preeti installed:

That's not a typo or file damage, it's simply what Preeti's underlying Latin characters look like once the font that was hiding them is gone. Running that header, and the columns beneath it, through a Nepali Unicode conversion tool turned every cell back into readable, searchable Nepali, permanently this time, with no font dependency left to break again later. The school kept its original Preeti file as an archive copy and moved forward using the converted version for anything shared outside the office.

Common Mistakes to Avoid

Frequently Asked Questions

Can I convert an entire Excel file from Preeti to Unicode?
Yes, but converting column by column gives you far more control than converting the whole file in one pass. Excel sheets usually mix Nepali text with numbers, dates, and English labels, and only the genuine Preeti text needs to go through conversion.

Will Excel formulas break during conversion?
The formulas themselves won't break just from converting text. But any formula that matches or compares Nepali text, like a VLOOKUP pulling a name from another sheet, needs to be checked afterward, since the underlying characters have changed even though the cell looks identical on screen.

Is Unicode better than Preeti for new documents?
For nearly everyone, yes. Unicode displays correctly on any device without needing a specific font installed, which makes it the practical choice for anything you plan to share, publish, or store long-term.

Can I use converted Unicode text in websites?
Yes. Websites, content systems, and search engines are all built around Unicode text. Preeti text pasted directly into a website will typically show up as broken symbols instead of Nepali.

Why does Nepali text become unreadable after changing fonts?
Because Preeti text was never real Devanagari to begin with. Each character you typed was stored as an ordinary Latin character, and the Preeti font simply redrew it to look Nepali. Change or remove that exact font and the disguise falls away, leaving the raw Latin characters visible underneath.

Final Thoughts

Converting Preeti-based Excel data to Unicode is usually straightforward once you do it in the right order. The key is preserving the original structure of your spreadsheet, rows, columns, and formulas, while converting only the actual text content that needs it. Rushing a whole-sheet conversion is almost always where the real damage happens, not the conversion process itself.

If you're sitting on old Nepali records that need to move into modern systems, working through an online Preeti conversion tool one column at a time, backing up first, and rechecking your formulas afterward will save you hours of manual correction later. It's a small amount of care upfront for data that stays usable for years afterward.