Formatting Issues

How to Copy a Table from Outlook to Excel Without Losing Formatting

Maira Mehtab Sep 21, 2026 868 views

Question details

The user needs to copy a data table from an email in the new Outlook to a pre-formatted Excel worksheet without altering the existing spreadsheet layout or producing incorrect cell values.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Pasting tabular email data from the new Outlook into an existing, pre-formatted Excel spreadsheet.
Observed behavior: Pasting the table often produces unexpected cell values, alters the target column widths, and overrides the destination worksheet's formatting with the email's HTML styles.

Before you start

Before copying your table, ensure the data in your Outlook email is structured in a clear grid. It is recommended to copy a small test section first to preview how different paste options interact with your existing Excel sheet.

Solution 1Recommended

Use the 'Match Destination Formatting' Paste Option

This method ensures the pasted table strips away the email's original design and adopts the existing styles, fonts, and borders of your target Excel worksheet.

By default, Excel often attempts to keep the source formatting from the copied Outlook email. This includes HTML tables, background colors, and specific font sizes, which can disrupt your clean worksheet layout. By using the destination formatting option, you force the imported data to conform to your current Excel setup.

Copy the table from Outlook

Highlight the entire table in your new Outlook email message and press Ctrl+C to copy it to your clipboard.

Select the destination cell in Excel

Open your formatted Excel worksheet and click exactly once on the top-left cell where you want the imported table data to begin.

Apply Match Destination Formatting

Right-click the selected cell. Under the 'Paste Options' section in the context menu, click the icon labeled 'Match Destination Formatting' (typically represented by a clipboard with an arrow or paintbrush). Alternatively, you can press Ctrl+V to paste, immediately click the small 'Ctrl' pop-up icon that appears next to the pasted data, and select 'Match Destination Formatting'.

Formatting Retained: Your table data is now populated in Excel while maintaining your pre-defined column widths and cell styles.

Solution 2

Paste as Unformatted Text Using Paste Special

If Outlook's HTML formatting is causing completely unexpected values, hidden characters, or broken cells, pasting as raw text strips away all external code.

Efficient Table Management

Seamlessly Paste Email Tables Using WPS Spreadsheet

WPS Office provides highly compatible and flexible paste options, allowing you to copy tables from any email client directly into WPS Spreadsheet without breaking your existing layout or column dimensions.

1. Copy the email table: Highlight the desired data in your email client (such as Outlook) and copy it.
2. Open WPS Spreadsheet: Launch WPS Office, open your target spreadsheet, and select the starting cell for your data.
3. Choose your paste method: Right-click the cell, hover over 'Paste Special', and select 'Unformatted Text' or 'Match Destination Formatting' to keep your existing worksheet layout perfectly intact.

100% compatibility with Microsoft Excel (.xlsx) formats.Smart 'Paste Special' options to effortlessly retain text or match destination formats.Lightweight, free to use, and completely free of format-breaking bugs.Familiar ribbon interface that requires no learning curve.

Frequently Asked Questions

Why do my column widths change when pasting a table from Outlook to Excel?

By default, Excel tries to 'Keep Source Formatting', which brings over the HTML column widths defined in the email layout. Using the 'Match Destination Formatting' paste option forces the new data to respect your current Excel column sizes.

How can I stop Excel from changing numbers to dates when pasting?

This happens when Excel automatically interprets pasted text formats. To fix it, highlight your destination cells, pre-format them as 'Text' before pasting, or use 'Paste Special' > 'Text' to import the exact raw values from the email.

What should I do if the copied table has hidden characters or extra spaces?

After pasting the table into Excel as text, you can use the TRIM() and CLEAN() functions in a helper column to strip out non-printable characters and trailing spaces that are frequently introduced by email HTML formatting.

Can I import an Outlook email table directly without copying and pasting?

Yes. If the table is highly complex, you can save the email as a web page (.htm or .html) locally. Then, use Excel's 'Get Data' (Power Query) feature from the Data tab to extract and import the table cleanly.

Document & File Issues