Formatting Issues

How to Paste Website Data into Excel with Custom Formatting

Aamir Naveed Akram Oct 10, 2026 869 views

Question details

The user needs to paste data copied from a website into an Excel spreadsheet while maintaining a preferred custom font, preventing the original website formatting from altering table alignment and row sizes.

How to Paste Website Data into Excel with Custom Formatting

Product: Excel
Device & OS: not provided
Scenario: Pasting external tabular data or text from a web browser into an Excel workbook.
Observed behavior: The pasted data retains the website's source formatting (e.g., Arial 19.5pt) instead of adopting the workbook's preferred formatting (e.g., Times New Roman 13pt), which disrupts the existing row sizes and table layout.

Before you start

Ensure that your target Excel spreadsheet already has your preferred font style, font size, and row height applied to the destination cells before pasting the new data.

Solution 1Recommended

Use Paste Special or Match Destination Formatting

Utilize Excel's built-in paste options to strip the source HTML formatting and automatically apply your workbook's existing styles.

When copying data from the web, the clipboard retains the source HTML formatting by default. Excel allows you to override this by choosing how the data is pasted into the cells.

Copy the website data

Highlight the text or table on the website and press Ctrl+C (Windows) or Cmd+C (Mac) to copy it to your clipboard.

Select the destination cell

Open your Excel workbook and right-click the specific cell where you want the data to begin.

Apply Match Destination Formatting

From the context menu, look under 'Paste Options' and click the icon for 'Match Destination Formatting' (usually depicted with a clipboard and a small arrow or text icon). Alternatively, select 'Paste Special', choose 'Text', and click OK.

Use Paste Special or Match Destination Formatting

Keyboard Shortcut: You can press Ctrl+Alt+V after copying the data to quickly open the Paste Special dialog box, then press 'T' for Text and hit Enter.

Solution 2

Use a Plain-Text Editor to Strip Formatting

If Excel's paste options do not properly clean complex web tables, use a basic text editor as an intermediary to completely remove all source formatting.

Simplify data entry and formatting

Manage Web Data Easily with WPS Spreadsheet

WPS Office Spreadsheet provides excellent formatting controls, allowing you to seamlessly paste web data as plain text or match your current table styles in just a few clicks.

1. Open WPS Spreadsheet: Launch WPS Office and open the spreadsheet where you want to insert your web data.
2. Access Paste Special: Right-click your destination cell and hover over 'Paste Special' in the context menu.
3. Choose Unformatted Text: Select 'Unformatted Text' from the options. The data will instantly adopt your chosen font, such as Times New Roman at 13 points.
4. Adjust layout if needed: Use the quick formatting toolbar to tweak column widths and ensure your table aligns perfectly.

Easily paste data without unwanted source formatting100% compatible with Microsoft Excel (.xlsx) filesAdvanced table alignment and row adjustment toolsFree and lightweight office suite for Windows, Mac, and Linux

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel row size change when pasting from a website?

When you paste data normally, Excel brings over the website's source formatting, which often includes larger font sizes or specific line heights. Using 'Match Destination Formatting' prevents these external styles from overwriting your spreadsheet's settings.

Do browser language settings affect how fonts are pasted into Excel?

No, browser language settings generally do not control or alter the font formatting of pasted text. The formatting is determined purely by the website's underlying HTML code and CSS styles.

Can I set Excel to always paste as plain text by default?

Excel doesn't have a built-in toggle to make plain text the default pasting method across the entire application. However, you can add the 'Paste and Match Destination Formatting' button to your Quick Access Toolbar for faster access, or rely on the Ctrl+Alt+V shortcut.

Document & File Issues