Share via

Cannot Cut and Paste Table Data to Excel

Angela Ip 205 Reputation points
2026-05-01T19:56:21.2466667+00:00

I have Windows 11 and Microsoft 365 Personal. I recently had a system update. Now when I want to copy data in a table from the web and try to paste this into Excel, it will not retain the columns and rows of the table from the web. The text is all garbled in one row. Before this system update, I was able to copy and paste data in a table from the web into Excel and maintain the rows and columns. Is there a fix for this so I can get this feature back?

Microsoft 365 and Office | Excel | Other | Windows
0 comments

Answer accepted by question author

  1. Xavier-D 7,920 Reputation points Microsoft External Staff Moderator
    2026-05-02T02:19:37.9666667+00:00

    Hello Angela Ip

    I can see that you are currently cannot cut and paste table data from web to Excel after a system update.

    If Excel is now pasting everything into one row, it likely means the table is being copied as plain text instead of structured table data.

    Here is what you can try:

    Use Excel’s web import tool:

    • Copy the webpage URL.
    • Open Excel.
    • Go to Data > From Web.
    • Paste the URL, then select OK.
    • Choose the detected table in the Navigator window and select Load.

    You can read more about this method here: https://support.microsoft.com/en-us/office/import-data-from-the-web-a1a6b325-17f3-45c8-ae72-c421cb2a8e90

    If the table is not detected correctly:

    • In the web import window, try Add Table Using Examples.
    • Enter a few sample values from the webpage so Excel can identify the correct table structure.

    If the data still paste in only one column, try using this temporary workaround:

    • Paste the data into Excel.
    • If everything appears in one column, use Data > Text to Columns.
    • Choose the correct delimiter, such as Tab, Comma, or Space, then finish the import.

    I hope this help. Feel free reply back to this post and update me on this issue, I'll be happy to help.

    Was this answer helpful?

    2 people found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.