How to Import Web Page Content and Icons into Excel or Word
Question details
The user wants to import web page content, including text formatting and icons, into Microsoft Excel or Word, and understand why Excel Power Query sometimes fails to extract the expected data.
- Product
- Microsoft Excel, Microsoft Word
- Device & OS
- not provided
- Scenario
- Transferring content from a web page to a document or spreadsheet while maintaining text formatting, layouts, and icon sizing.
- Observed behavior
- Copy-pasting often results in lost formatting or oversized icons, and Excel Power Query or PDF imports frequently fail to extract the expected page content due to unsupported structures.
Check if the web page data is structured in an HTML table, as this determines whether you should use Excel's data import tools or rely on formatted copy-pasting.
Use Excel Power Query for HTML Tables
Best for extracting structured data that is exposed as standard HTML tables on a web page.
Excel Power Query is the most reliable method for importing web data, provided the target website uses traditional HTML tables. If the site relies on dynamic JavaScript loading or div-based grid layouts, this method may only pull limited structural data.
Open Microsoft Excel, navigate to the 'Data' tab on the ribbon, and click on 'Get Data' > 'From Other Sources' > 'From Web'.
In the dialog box that appears, paste the URL of the web page containing the table and click 'OK'.
Wait for the Navigator window to load. Browse through the detected tables on the left panel, click on the one you need, and preview the data on the right.
Click the 'Load' button to import the structured web table directly into your Excel spreadsheet.
Paste into Word with Source Formatting
Ideal for unstructured web content where you need to preserve general text formatting, layouts, and icons.
Save as HTML and Open in Word
A great alternative if traditional copy-pasting fails to maintain the overall page layout.
Easily Import and Format Web Data with WPS Office
WPS Office provides robust tools to paste web content with source formatting in Writer or import structured web data directly into Spreadsheets, ensuring your icons and layouts are beautifully preserved.
- 1. Open a new document: Launch WPS Office and open a new Writer document or Spreadsheet workbook depending on your data type.
- 2. Paste with formatting in Writer: To copy web text and icons into Writer, right-click on the canvas and choose 'Keep Source Formatting' to preserve the web layout.
- 3. Import data in Spreadsheet: To import tables into Spreadsheet, go to the 'Data' tab, select 'Import Data', choose the web data source, and paste the URL to extract tables.
Frequently Asked Questions
Why do web icons become oversized when I paste them into Word?
Web icons are often scalable vector graphics (SVGs) or web-font elements styled by CSS. When pasted into Word, they lose their website CSS sizing constraints, causing them to render at their original, much larger baseline resolution. You can fix this by manually dragging the image corners to resize them in your document.
Why does Excel Power Query show an error when importing from a web page?
Power Query relies on clean, structured HTML tables (using <table> tags). If the website generates tables dynamically using JavaScript, relies on <div> based grids, or requires a user login, Power Query cannot reliably read the underlying data, resulting in missing information or preview errors.
Is it effective to save a webpage as a PDF and then import it into Excel?
Generally, no. Extracting data from a web-to-PDF conversion is highly unreliable. Printed PDFs often contain flattened images, unsupported layout elements, or inaccessible text layers. This frequently causes missing data or formatting errors when imported via Excel Power Query.
