How to Import Chrome HTML and PDF Content into Excel
Question details
The user needs to extract and import data from a Chrome HTML document or a PDF file into an Excel spreadsheet while preserving the original row and column structure.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to transfer tabular data viewed in a web browser (HTML) or saved as a PDF into Excel for data analysis and editing.
- Observed behavior
- Directly copying and pasting from a PDF or browser often results in unformatted text, losing the necessary table structure, and Excel's built-in PDF import tool is not available in all software versions.
Verify whether your source file is an HTML file saved from Chrome or a standard PDF, as the most effective import method will depend entirely on the file format.
Convert the Source File to CSV Format
This is the most reliable method for preserving tabular data when dealing with difficult PDF or HTML files that refuse to paste correctly into Excel.
By converting your source document into a Comma Separated Values (CSV) file first, you force the data into a structured format that Excel natively understands and can organize perfectly into rows and columns.
Open your original source document (or use an online PDF/HTML to CSV converter) and choose the option to Save As or Export to a CSV format.
Launch Microsoft Excel, navigate to the 'Data' tab on the top ribbon, and click on 'Get Data' or 'From Text/CSV'.
Locate and select the newly created CSV file, review the data preview to ensure the columns look correct, and click 'Load' to import it into your spreadsheet.
Use Microsoft Word as a PDF Intermediary
Use this method if you are trying to extract a table from a PDF and do not have access to a third-party PDF converter.
Import using Power Query (Newer Excel Versions)
Ideal for users with Microsoft 365 or newer versions of Excel that have the built-in PDF and Web data extraction tools.
Extract PDF and HTML Data Seamlessly with WPS Office
WPS Office simplifies the data extraction process by offering a built-in PDF to Excel conversion tool. Instead of relying on manual copying or complex intermediaries, you can directly convert PDF tables into fully formatted spreadsheets in just a few clicks.
- 1. Open WPS Office: Launch WPS Office and navigate to the 'PDF' tab on the left-side menu or open your PDF file directly in the application.
- 2. Select PDF to Excel: On the top toolbar, click on 'PDF to Excel' to launch the conversion utility.
- 3. Convert the file: Confirm your desired pages and output location, then click 'Start'. The file will be converted and instantly opened as a fully editable, structured spreadsheet.
Frequently Asked Questions
Why does my data lose its column structure when I copy it from a PDF to Excel?
PDFs are designed as visual, fixed-layout documents and do not inherently contain tabular data structures. When you highlight and copy text from a PDF, Excel interprets it as a single block of text, causing everything to paste into a single column.
Can I open an HTML file directly in Excel?
Yes, Excel can open HTML files directly. You can simply go to File > Open and locate your HTML file, or right-click the HTML file on your computer and choose 'Open with > Microsoft Excel'. This often preserves basic table formatting.
What should I do if my Excel version doesn't have the 'From PDF' import option?
The 'Get Data From PDF' tool is typically available only in Microsoft 365 and Excel 2021. If you are using an older version, your best alternatives are to use Word to open the PDF and copy the table, or use a free online converter to turn the PDF into a CSV file first.
