'%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 for the Web Pasting Text Without Formatting into Outlook
Question details
Users are experiencing an issue where copying formatted tables or text from Excel for the Web pastes only as plain text into Outlook and other Office desktop applications.
- Product
- Excel for the Web, Outlook Desktop
- Device & OS
- not provided
- Scenario
- Copying formatted spreadsheet data from the web version of Excel to send via an Outlook email or document.
- Observed behavior
- The pasted content loses all source formatting, colors, and table structures, resulting in plain, unformatted text in the desktop application.
Ensure your web browser is fully updated and try clearing your browser cache, as clipboard interaction between web environments and desktop applications relies heavily on the browser's clipboard API capabilities.
Use the HTML Source Code Workaround
Extract the raw HTML code from the web page to bypass the clipboard plain-text restriction and retain your cell formatting.
Because a recent Office update may have disrupted how the browser transfers formatted clipboard data to desktop apps, you can manually bridge the gap by saving the web element as an HTML file. This forces the computer to read the rich text data locally.
With your spreadsheet open in Excel for the Web, press F12 on your keyboard or right-click on the page and select 'Inspect' to open the browser's Developer Tools.
In the Elements tab, locate the block of HTML code that contains your formatted Excel data. Right-click the element and select 'Copy' > 'Copy element'.
Open Notepad or any basic text editor on your computer, paste the copied HTML code, and save the file with a '.html' extension (for example, 'table-data.html').
Double-click your newly saved HTML file to open it in a standard web browser. Highlight the formatted table displayed on the page, copy it (Ctrl+C), and paste it (Ctrl+V) directly into your Outlook desktop application.
Escalate to Microsoft 365 Support
Since this plain text pasting behavior is recognized as a bug following an Office update, escalating it to Microsoft support can help push for a permanent software patch.
Use WPS Office to Keep Your Formatting Intact
Avoid frustrating clipboard limitations and bugs between web browsers and desktop apps. WPS Office provides a fully featured, lightweight desktop application suite where copying from spreadsheets to emails or documents retains 100% of your formatting seamlessly.
- 1. Download and Install: Download WPS Office Free from the official website and install the lightweight suite on your PC or Mac.
- 2. Open Your Spreadsheet: Launch WPS Spreadsheet and easily open your existing Microsoft Excel (.xlsx) documents directly from your local drive.
- 3. Copy and Paste Seamlessly: Select your formatted table, copy it, and paste it directly into your email client or document with zero formatting loss.
Frequently Asked Questions
Why does Excel for the web lose formatting when pasting into desktop Outlook?
This issue is typically caused by a mismatch in how modern web browsers interact with your operating system's clipboard. Recent browser security updates or specific Office web updates can disrupt the HTML payload, leaving only plain text available to be pasted into desktop apps.
Can I use 'Paste Special' to keep the Excel formatting?
If the clipboard bug prevents the browser from sending HTML data, the desktop application will only receive plain text. Consequently, the 'Keep Source Formatting' or 'HTML' options will not appear in the Paste Special menu.
Are there other ways to share this Excel data without losing the format?
Yes. The simplest alternative is to download a copy of the workbook to your computer and open it in a desktop spreadsheet application, such as WPS Spreadsheet or Excel Desktop. Copying directly from desktop to desktop applications avoids browser clipboard bugs entirely.
