Data Import & Export

How to Fix Excel Pasting Website Data Into One Column

WPS Content Manager Oct 10, 2026 869 views

Question details

Users experience an issue where copying tabular data from a website and pasting it into Excel results in all values appearing in a single column instead of multiple columns.

How to Fix Excel Pasting Website Data Into One Column

Product: Microsoft Excel
Device & OS: not provided
Scenario: Copying and pasting table data from a web browser into an Excel spreadsheet.
Observed behavior: The data is pasted entirely into a single column, failing to preserve the original HTML table layout and multiple columns.

Before you start

Before attempting to reformat the data, check if the website offers an export option (like a CSV or Excel download button) for cleaner data extraction.

Solution 1Recommended

Use the Text to Columns Feature

The quickest way to split data pasted into a single column into multiple columns based on a delimiter like a space, comma, or tab.

When Excel fails to recognize the table layout, all text gets grouped into one cell per row. The Text to Columns wizard allows you to manually split this text into separate columns.

Select the Data

Highlight the entire single column that contains the pasted website data.

Open Text to Columns

Navigate to the 'Data' tab on the Excel ribbon and click on 'Text to Columns'.

Choose Data Type

In the wizard, select 'Delimited' if your data is separated by characters like commas or spaces, then click 'Next'.

Select Delimiters

Check the boxes for the delimiters that separate your data (e.g., Space or Tab). Check the Data preview window to ensure it splits correctly, then click 'Finish'.

Preview Your Data: Always use the Data preview pane in the wizard to verify your columns align perfectly before clicking Finish.

Solution 2

Import Data Using 'From Web'

Bypass the clipboard entirely and let Excel extract the table structure directly from the website URL.

Solution 3

Utilize Paste Special Options

Try different paste formatting options immediately after copying the data to see if Excel can natively parse the HTML table.

Smart Data Formatting

Easily Import and Organize Web Data with WPS Spreadsheets

WPS Office provides robust data processing tools, including Text to Columns and intelligent Paste Options, helping you effortlessly organize pasted website data into proper columns for free.

1. Paste Data: Paste the copied website data directly into a WPS Spreadsheets workbook.
2. Select the Column: Highlight the single column containing the incorrectly formatted data.
3. Open Text to Columns: Navigate to the Data tab and click on the 'Text to Columns' button.
4. Choose Delimiter: Select 'Delimited', choose the appropriate delimiter (like Space or Tab), and click Finish to organize your table instantly.

100% compatibility with Microsoft Excel (.xlsx) formatsIntuitive Text to Columns feature to quickly split grouped dataLightweight and fast, even when handling large datasetsFree built-in tools for data cleaning and formatting

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel paste my website data into one row or one column?

This happens when Excel cannot recognize the underlying HTML table structure from the website, or when the clipboard copies the text without structural delimiters (like tabs), causing Excel to treat the entire block as a single string of text.

Can I automate the process of splitting imported web data?

Yes. By using Excel's Power Query (Data > From Web) instead of copy-pasting, you create an automated connection to the website. This pulls and correctly formats the table data automatically, and can be updated simply by clicking 'Refresh'.

What delimiter should I use in Text to Columns for web data?

It depends on how the text was pasted. Often, pasted web data items are separated by a Space or a Comma. You can check the preview box in the Text to Columns wizard to see which delimiter correctly separates your data into columns before applying it.

Excel & Data Problems