U Love Office
Home › Blog › Excel & Data
Excel & Data

CSV Arabic encoding Excel: fix garbled text

✍️ admin 📅 26 August 2026

CSV Arabic encoding Excel: fix garbled text

Fix CSV Arabic encoding Excel problems with UTF-8, Power Query and correct delimiters. Follow clear steps, an AED example and tips for clean imports.

If Arabic text in a CSV opens as strange symbols, question marks or unreadable characters in Excel, the usual fix is to import the file with the correct character encoding instead of double-clicking it. For a UTF-8 CSV, use Excel’s Data > From Text/CSV or Power Query workflow, confirm the file origin or encoding, check the delimiter in the preview, then load the data. Microsoft also notes that a UTF-8 CSV can open normally when it includes a byte order mark (BOM). This guide explains the csv arabic encoding excel fixes that preserve Arabic names, addresses and business data.

Why Arabic CSV text opens incorrectly in Excel

A CSV is a text file, not a full Excel workbook. It stores values separated by delimiters such as commas, while the characters themselves must be interpreted using an encoding. If the software reads the bytes using a different character set from the one used to create the file, Arabic letters can appear as mojibake, boxes, replacement symbols or question marks.

Microsoft explains that Excel can open CSV files directly, but direct opening uses current default data-format settings to interpret the columns. Microsoft separately advises that UTF-8 CSV files without a BOM can be opened through Power Query or the text import workflow. That is why a file can look broken after a double-click yet display correctly when imported through the Data tab.

How to fix CSV Arabic encoding in Excel step by step

Step 1: Keep an untouched copy of the CSV

Before experimenting, duplicate the original CSV. Do not repeatedly open, edit and save the only copy. CSV is a plain-text exchange format and does not preserve the full feature set of an Excel workbook. Microsoft notes that saving to text formats can also lose workbook formatting and other features, so keep the source file until you confirm the Arabic content is correct.

Step 2: Import the file instead of double-clicking it

Open a blank workbook in Excel. Go to Data, choose Get Data or From Text/CSV, and select the CSV. Microsoft’s current import guidance uses Data > Get & Transform Data > Get Data > From File > From Text/CSV. This route gives you a preview before the content is committed to the worksheet.

Step 3: Select the correct encoding or file origin

If the source file is UTF-8, make sure the import preview is interpreting it as UTF-8. In Excel’s Text Import Wizard, the File origin setting controls the character set used for the text file. Microsoft’s newer IMPORTTEXT function also exposes an encoding argument and uses UTF-8 by default, although that function is currently limited to qualifying Microsoft 365 Insider builds. For ordinary office use, From Text/CSV remains the safer broadly documented route.

Step 4: Check the Arabic preview before loading

Look at several Arabic fields in the preview: customer names, company names, addresses and notes. Do not check only the first row. If text such as دبي, الإمارات or فاتورة displays correctly, the character encoding is probably being interpreted properly. If it is still corrupted, cancel the import and confirm how the source system exported the CSV.

Step 5: Confirm the delimiter

Encoding and delimiter are separate issues. A file can show perfect Arabic but still place an entire row in one column if Excel chooses the wrong separator. Microsoft’s From Text/CSV workflow lets you choose the delimiter and immediately see the result in the preview. Common separators include comma, semicolon and tab, depending on the exporting application and regional settings.

Step 6: Load the data and verify important columns

When the preview is correct, load the data. Check IDs with leading zeros, dates, phone numbers and monetary values as well as Arabic text. Microsoft notes that CSV import can interpret columns according to default data settings, so values that look numeric may need to be treated as text when their exact formatting matters.

Step 7: Save the cleaned result appropriately

If the file is now intended for ongoing Excel work, save a working copy as an Excel workbook such as XLSX so you can retain workbook features. If another system specifically requires CSV, export a new CSV in the encoding that system expects and test it before replacing the source. Remember that a CSV stores only the active sheet when exported from Excel and does not preserve normal workbook formatting.

Worked example with AED figures

Assume a Dubai office exports a sales CSV containing Arabic customer names and invoice values. One row should read شركة النور with an invoice amount of AED 12,500, while another contains an AED 7,800 invoice. When the employee double-clicks the CSV, the Arabic customer names appear as unreadable characters, although the AED figures still look normal.

The employee closes the file without saving, opens a blank workbook, and imports the original through Data > From Text/CSV. The preview is set to the correct UTF-8 interpretation and comma delimiter. The Arabic names now display correctly, and the two invoice values remain AED 12,500 and AED 7,800. The employee loads the table and saves the working file as XLSX. Total invoice value is AED 20,300, and the Arabic customer data remains readable.

That clean data can then feed office calculations. For example, if the business compares selling prices and costs, it may calculate markup vs margin in the same workbook. Markup measures profit relative to cost, while margin measures profit relative to selling price. Encoding does not change those formulas, but corrupted customer or product labels can make reports difficult to audit.

UTF-8, BOM and Arabic CSV files

UTF-8 is widely used because it can represent Arabic alongside English and many other scripts. Microsoft specifically says Excel can normally open a UTF-8 CSV if it was saved with a BOM. If the UTF-8 file has no BOM, Microsoft recommends opening it through Power Query using Get Data > From Text/CSV or through the text import option rather than relying on a normal direct open.

A BOM is not a visible word at the start of your spreadsheet; it is a marker that can help software identify the text encoding. You do not need to manually type one into the CSV. If you control the exporting system, use a UTF-8 CSV option that is known to work with the receiving application. If you do not control the export, use Excel’s import controls to interpret the file correctly.

What if Arabic is already replaced by question marks?

Import settings can fix a file that contains valid Arabic bytes but is being decoded incorrectly. They cannot reliably restore characters that were already destroyed during an earlier export. If the raw CSV itself contains literal question marks where Arabic letters should be, return to the source system and export the data again using a Unicode-capable encoding such as UTF-8. Keep the original database or source report until the new CSV has been checked.

Can I fix CSV Arabic encoding free unlimited times?

The encoding method itself can be repeated whenever you import files, but whether an online uloveoffice.com CSV utility is free and unlimited depends on the live tool’s current limits. If the tool permits repeated conversions or fixes without a stated daily, account or file-count cap, the page can accurately describe that feature as free unlimited use. If a limit exists, publish the real limit rather than promising unlimited processing.

For repeated office work, a consistent export process is better than repairing every file manually. Configure the source system to produce UTF-8 where possible, document the expected delimiter, and give staff a standard Excel import procedure. This reduces errors in Arabic customer lists, payroll exports, invoice registers and UAE reporting files.

Frequently asked questions

Why does Arabic text appear as symbols in Excel CSV files?

The CSV is usually being interpreted with a character encoding different from the one used to create it. Import the file through Data > From Text/CSV and check the encoding or file origin in the preview rather than relying only on direct opening.

How do I open a UTF-8 CSV correctly in Excel?

Microsoft says a UTF-8 CSV with a BOM can normally be opened directly. For a UTF-8 file without a BOM, use Power Query or Data > From Text/CSV so Excel can import the text correctly.

Why is my CSV all in one Excel column?

That is usually a delimiter problem rather than an Arabic encoding problem. During From Text/CSV import, choose the separator actually used by the file, such as comma or semicolon, and confirm the columns in the preview.

Can Excel preserve Arabic when I save the file?

Yes, provided the chosen output format and encoding support the characters. For continued Excel editing, XLSX is usually more suitable because CSV is a plain-text interchange format and does not retain normal workbook formatting or multiple sheets.

Can corrupted Arabic question marks be recovered?

If the underlying file still contains valid Arabic data, importing it with the correct encoding can display it correctly. If an earlier system already replaced the original Arabic characters with literal question marks, re-export from the original source using a Unicode-capable encoding.

Conclusion

For a csv arabic encoding excel problem, avoid repeatedly opening and saving the broken-looking file. Import the original through Excel’s From Text/CSV workflow, select the correct encoding, confirm the delimiter, inspect Arabic text in the preview, then load and save a clean working copy. For additional spreadsheet and document utilities, use the relevant tool on uloveoffice.com and check its live options before processing important business data.

Screenshots needed

  1. Step 1 — Example CSV opened incorrectly in Excel, showing garbled Arabic text.
  2. Step 2 — Excel Data tab with From Text/CSV selected.
  3. Step 3 — File import preview showing the encoding/file-origin control and Arabic preview.
  4. Step 4 — Delimiter selection with columns separated correctly.
  5. Step 5 — Loaded worksheet showing readable Arabic names and AED values.
  6. Step 6 — Save As screen showing XLSX for the cleaned working copy.
  7. Optional uloveoffice.com step — live CSV-related tool page and result screen, if a relevant tool exists.

Internal links to add

Sources for factual claims

Editorial note: The supplied brief names “working days uae 2026” as the target keyword but gives “csv arabic encoding excel” as the search query. This draft treats “csv arabic encoding excel” as the primary SEO query because it matches the requested article topic, while retaining “working days uae 2026” in the keyword notes. Verify the exact uloveoffice.com tool and any free/unlimited claims before publication.

🏠 Home More in Excel & Data