'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Excel Files Displaying Gibberish in Edge or Chrome
Question details
The user needs to resolve an issue where an Excel workbook displays garbled or gibberish text when viewed online through a web browser via OneDrive.
- Product
- Microsoft Excel / OneDrive Web
- Device & OS
- not provided
- Scenario
- Opening and viewing an Excel workbook online through OneDrive using a web browser like Edge or Chrome.
- Observed behavior
- The Excel file displays gibberish in the web browser but opens correctly without data loss in the desktop Excel application.
Verify that the Excel file opens correctly in a desktop application to confirm the file itself is not corrupted before troubleshooting the browser.
Clear Browser Cache and Test in Private Browsing Mode
Clearing outdated or corrupted cache data can resolve browser-specific rendering and encoding issues.
Browser cache or cookies can sometimes interfere with how web applications like OneDrive render files, resulting in garbled text.
Launch your browser (Edge or Chrome) and press Ctrl + Shift + Delete to open the Clear browsing data menu.
Select 'Cookies and other site data' and 'Cached images and files', then click the 'Clear data' button.
Open a new InPrivate window in Edge by pressing Ctrl + Shift + N, or an Incognito window if using Chrome.
Log in to OneDrive within the private window and try opening the Excel workbook again to see if the text renders correctly.
Download the Workbook to Desktop Excel
Use the desktop version of Excel to bypass web browser rendering problems and verify data integrity.
Check Office Build and Report to Support
If the issue persists across different browsers and computers, it may be a software bug requiring Microsoft Support.
Avoid Browser Errors with WPS Office
Experiencing garbled text or gibberish in OneDrive? Switch to WPS Office for a lightweight, free, and reliable desktop application. Enjoy seamless document viewing and editing without relying on a web browser, ensuring your files are displayed exactly as intended.
- 1. Download and Install: Get the free WPS Office suite from the official website and install it on your computer.
- 2. Download the File from OneDrive: Right-click the problematic file in your OneDrive web view and select Download to save it locally.
- 3. Open Your Excel File: Right-click your downloaded .xlsx file, choose 'Open with', and select WPS Office to view your data properly without gibberish.
Frequently Asked Questions
Why do my Excel files show up as gibberish in my web browser?
This usually happens due to browser cache conflicts, outdated browser versions, incorrect text encoding settings, or temporary rendering glitches within the OneDrive web viewer.
Does seeing garbled text in OneDrive mean my Excel file is corrupted?
Not necessarily. If the file opens perfectly in a desktop application without missing data, the file is intact and the issue is strictly related to the browser or web platform.
How do I change the character encoding in Edge or Chrome to fix gibberish text?
Modern versions of Edge and Chrome automatically detect encoding. If it fails, clearing your browser cache or trying an Incognito/InPrivate window forces the browser to fetch a fresh, correctly encoded version of the page.
