New Outlook pastes Excel / SQL Developer table data into a single cell

Question

In Classic Outlook, I am able to copy tabular data (multiple rows and columns) from Excel or SQL Developer query results and paste it neatly into an existing table inside an email.

In New Outlook, pasting the same data into an Outlook email table causes all rows to be pasted into a single cell instead of spreading across rows.

This happens consistently with:

• Excel tables
• SQL Developer result grids

Pasting directly into the email body works, but pasting into an existing table does not behave the same way as Classic Outlook.

Is this a known limitation of the New Outlook editor? Any recommended workaround?

Answer 1

Dear @Vinod Kumar Gill,

Good day, and thank you for the detailed description of your issue.

I tested this behavior in my own test environment and observed the following:

• In the new Outlook, when you copy data from Excel and paste it into an existing table using Ctrl + C / Ctrl + V, Outlook correctly respects the table structure and spreads the data across rows as expected.
• In classic Outlook, pasting the same data using Ctrl + V causes all rows to be pasted into a single cell. However, using right‑click > Paste works correctly there.

Please follow these steps to resolve the problem:

When pasting into an existing table in new Outlook

• Prefer keyboard paste (Ctrl + V) inside the table body.
• Right‑click paste can be unreliable and may collapse the data into one cell.

If the data still pastes into a single cell

• Copy the grid directly from Excel or SQL Developer.
• In new Outlook, paste the content directly into the email body (not into an existing table).
• Outlook will usually paste it as a properly structured table or with clear column separation.
• Select the pasted text.
• Go to Insert > Table > Insert Table > select the correct number of rows and columns for your table.
• This creates a clean table and avoids having a table nested inside a single cell.

This should help produce results similar to classic Outlook and avoid formatting issues.

I hope this information is helpful and provides you with workable solutions. If you have any further questions or need additional assistance, please don’t hesitate to reach out, I’m always happy to help. Have a wonderful day!

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".  

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread. 

Answer 2

This behavior matches known issues where table or grid content does not paste into Outlook table cells as expected and is treated as a single block of content. Classic Outlook and New Outlook use different editors, and New Outlook currently lacks some of the table‑pasting behavior of Classic Outlook, so this is effectively a limitation of the New Outlook editor.

Workarounds based on documented behavior in similar scenarios:

1. Paste via Word or Classic Outlook first
   • Copy the table from Excel or SQL Developer.
   • Paste it into Word or Classic Outlook.
   • From Word or Classic Outlook, copy the table again.
   • Paste into the table in New Outlook.
   A similar workaround is documented for Outlook Web App where table text displays incorrectly: pasting via Word/Outlook normalizes the table formatting before sending.
2. Avoid Conversation view–style rendering issues
   • In environments where table rendering is problematic, another documented workaround is to avoid Conversation view. If New Outlook is showing the message in a conversation/threaded view, switching to a non‑conversation view for composing/reading may improve layout behavior, though this is less reliable than the Word/Classic Outlook intermediary.
3. Paste outside the existing table, then rebuild
   • Since pasting directly into the body works correctly, paste the copied grid into the message body (not inside an existing table), then recreate or adjust the table layout around it as needed.

If consistent Classic Outlook behavior is required for heavy table editing and pasting, using Classic Outlook for those messages remains the most reliable option until the New Outlook editor gains full feature parity.

---

References:

• Text in tables is displayed incorrectly in the Conversation view in Outlook Web App in an Exchange Server 2010 environment
• Copy a Word table into Excel