This article was co-authored by wikiHow staff writer, Nicole Levine, MFA. Nicole Levine is a Technology Writer and Editor for wikiHow. She has more than 20 years of experience creating technical documentation and leading support teams at major web hosting and software companies. Nicole also holds an MFA in Creative Writing from Portland State University and teaches composition, fiction-writing, and zine-making at various institutions.
This article has been fact-checked, ensuring the accuracy of any cited facts and confirming the authority of its sources.
This article has been viewed 278,220 times.
Learn more...
Do you have a PDF table that you want to add to an Excel sheet? If you try copying the table from the PDF and then pasting it into Excel, you'll get jumbled and non-sensical text. Fortunately, it's easy to copy a table from a PDF to Excel if you have Microsoft 365 (Office 365) for Windows. If you're using a Mac or have an earlier version of Excel, you can still copy and paste the table by opening the PDF in Microsoft Word. This wikiHow article will teach you two simple ways to copy a table from a PDF to an Excel workbook.
Things You Should Know
- With a Microsoft 365 subscription on Windows, you can use Power Query to import a table from any PDF.
- You can also open a PDF in Word and enable editing to copy the table into an Excel worksheet.
- When you paste a PDF table into Excel with either method, the data will be organized into columns and rows just as it was in the PDF. [1]
Steps
-
Open Excel on your Windows PC. You can open a new project or continue a saved project in Excel.
- This method covers using the Power Query feature to import a table from a PDF into Excel. This feature is only available with a Microsoft 365 (Office 365) subscription on Windows. Unfortunately, this feature is not yet available on Excel for Mac.[2]
-
Select a cell. Click the cell into which you want to begin pasting the table. For example, click A1 to begin pasting the table at the upper-left corner of the sheet.Advertisement
-
Click the Data tab. It's in the menu above the editing ribbon.
-
Click Get Data. For Windows, it's the furthest icon on the left of the menu.
-
Select From File and choose From PDF.[3] With each selection, the menu will continue expanding until you select From PDF, after which Excel will open your file manager (Finder for Mac and File Explorer for Windows).
-
Select your PDF and click Open. Excel will connect to the PDF file and display a list of tables.
-
Select a table to copy. In the left panel, click the table you want to import. You can click through each table to see a preview in the right panel. To copy multiple tables into your Excel workbook, check the box next to "Select multiple items" at the top.
- Knowing the page number on which the table you want is located in the PDF will be helpful, as each table is labeled by page number.
-
Click Load. It's in the bottom right corner. This copies the table from the PDF to the current worksheet in Excel.
- If you'd rather work with the table data in Power Query before copying it to your worksheet, click Transform Data instead.[4]
-
Open the PDF in Microsoft Word. If you're not using Microsoft Office 365 on a Windows PC, the easiest way to copy a table from a PDF into Excel is to first open the PDF in Word. This method will work in any version of Excel beginning with Office 2013 on a PC or Mac. To open the PDF in Word:
- Open Microsoft Word.
- Click the File menu and select Open. If you don't see a File menu, just click Open.
- Select the PDF that contains the table and click Open.[5]
- Click OK when prompted to convert the PDF into a Word document. It may take a few moments to display the file.
-
Use your mouse or trackpad to highlight the table you want to copy. Now the PDF is in the Word format, it should be easier to copy while retaining the original table structure.
-
Click the Enable Editing button. You'll see this in the alert bar at the top of the file. This allows you to edit the document.
- If prompted, click OK again to make the file editable.
-
Select the table you want to copy to Excel. If Word recognizes the table in the file, you'll see a crosshair icon at the table's top-left corner. In this case, just click that icon to select the entire table at once. If Word doesn't recognize the table, use your mouse or trackpad to select the table you want to copy.
-
Press Ctrl+C (PC) or ⌘ Cmd+C (Mac) to copy. The table is now copied to your clipboard.
-
Open your Excel sheet and click a cell. Click the cell into which you want to begin pasting the table. For example, click A1 to begin pasting the table at the upper-left corner of the sheet.
-
Press Ctrl+⇧ Shift+V (PC) or ⌘ Cmd+⇧ Shift+V (Mac) to paste. This copies the table data into the sheet without pasting any special colors or formatting from the PDF. This is a great way to paste if you want the data from the table to be plain text or automatically inherit the formatting of your Excel sheet.
- If you'd rather keep the formatting of the original table, such as custom colors, fonts, and bold text, you can use Ctrl + V (PC) or Cmd + V (Mac) instead.
Expert Q&A
Video
Tips
References
- ↑ https://nanonets.com/blog/copy-tables-from-pdfs-excel/
- ↑ https://techcommunity.microsoft.com/t5/excel-blog/announcing-data-import-from-pdf-documents/ba-p/1569202
- ↑ https://nanonets.com/blog/copy-tables-from-pdfs-excel/
- ↑ https://support.microsoft.com/en-us/office/import-data-from-data-sources-power-query-be4330b3-5356-486c-a168-b68e9e616f5a#ID0EBH=Mac&ID0EBF=Windows_newer_versions
- ↑ https://www.adobe.com/acrobat/resources/how-to-convert-pdf-to-word-on-mac.html
About This Article
1. Open Excel.
2. Select a cell where you want to start the table.
3. Click Data.
4. Click Get Data.
5. Click From File and From PDF.
6. Navigate to and double-click your PDF.
7. Click the table you want to copy from the PDF to Excel.
8. Click Load.