'%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)
Fix Excel Files Displaying Gibberish from OneDrive in Edge or Chrome
Question details
The user needs to fix an issue where Excel files stored in OneDrive display unreadable characters when opened in certain web browsers.
- Product
- Microsoft Excel / OneDrive
- Device & OS
- not provided
- Scenario
- Opening OneDrive-hosted Excel files using a web browser like Microsoft Edge or Google Chrome.
- Observed behavior
- The Excel file contents render as gibberish or unreadable characters in the browser, despite opening perfectly fine on other computers.
Ensure you have your browser login credentials backed up, as clearing browser cache and cookies may temporarily sign you out of active websites.
Use Private Browsing and Clear Browser Cache
Using an InPrivate or Incognito window temporarily disables extensions and uses a fresh cache, helping to quickly identify if outdated browser data is causing the gibberish text.
Browser cache issues or conflicting third-party extensions often disrupt how web pages, including Office Online viewers, decode and render text.
Ensure Microsoft Edge or Google Chrome is updated to the latest version by clicking the three-dot menu in the top right, navigating to 'Help' or 'Settings', and selecting 'About'.
Press Ctrl+Shift+N (for Chrome) or Ctrl+Shift+N (for Edge) to launch a private window. Log into your OneDrive account and attempt to open the Excel file.
If the file displays correctly in the private window, return to your normal browser, press Ctrl+Shift+Del, check 'Cached images and files', and click 'Clear data'.
If the problem continues, access the extensions menu via the puzzle piece icon or browser settings, and toggle off third-party add-ons one by one to isolate the conflict.
Open Your Spreadsheets Seamlessly with WPS Office
Bypass browser caching issues and online display errors by downloading your OneDrive files and opening them directly in WPS Office, a highly compatible desktop application.
- 1. Download the File: From your OneDrive web interface, right-click the problematic Excel file and select 'Download' to save it locally to your computer.
- 2. Install WPS Office: Download and install the free WPS Office application on your device if you haven't already.
- 3. Open with WPS Spreadsheets: Right-click the downloaded file on your computer, select 'Open with', and choose WPS Office to view your data correctly.
Frequently Asked Questions
Why do Excel files show as gibberish in my web browser?
This typically occurs due to corrupted browser cache, outdated browser versions, or conflicting browser extensions that interfere with the web page's text encoding.
Does this mean my OneDrive Excel file is corrupted?
Not necessarily. If the file opens correctly on another computer or correctly renders in an Incognito window, the file itself is safe and the issue is strictly localized to your browser.
How do I fix encoding issues in Microsoft Edge or Chrome?
Modern browsers automatically detect text encoding. If it fails on OneDrive, resetting the browser settings to default or clearing the cache usually forces the browser to re-detect and resolve the encoding issue.
Can I prevent browser gibberish by opening the file in a desktop app?
Yes, downloading the file from OneDrive and opening it in a dedicated desktop application like WPS Office completely bypasses web browser rendering issues.
