How to Copy Tables from PDF to Excel

X

This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.

The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.

This article has been viewed 13,253 times.

Are you looking to add some PDF table to your Excel sheet? When copying data in a PDF document and pasting it into an Excel sheet, there is a chance that you will get messy and unreasonable results. PDF and Excel use different formats, so it’s not easy to move information between the two. This wikiHow teaches you how to copy a table from a PDF file to Excel using the import feature in spreadsheet software.

Steps

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/b/be/Copy-a-Table-from-a-PDF-to-Excel-Step-1.jpg/v4-728px- Copy-a-Table-from-a-PDF-to-Excel-Step-1.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/b/be/Copy-a- Table-from-a-PDF-to-Excel-Step-1.jpg/v4-728px-Copy-a-Table-from-a-PDF-to-Excel-Step-1.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Open Excel. You can open a new project or resume a saved project in Excel.

You also need to know where the PDF file containing the table is so that it can be easily found when importing.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/2/22/Copy-a-Table-from-a-PDF-to-Excel-Step-2.jpg/v4-728px- Copy-a-Table-from-a-PDF-to-Excel-Step-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/2/22/Copy-a- Table-from-a-PDF-to-Excel-Step-2.jpg/v4-728px-Copy-a-Table-from-a-PDF-to-Excel-Step-2.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Select the cell that will start the table. This will be the cell in the upper left corner of the table that you are about to copy from the PDF.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/0/06/Copy-a-Table-from-a-PDF-to-Excel-Step-3.jpg/v4-728px- Copy-a-Table-from-a-PDF-to-Excel-Step-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/0/06/Copy-a- Table-from-a-PDF-to-Excel-Step-3.jpg/v4-728px-Copy-a-Table-from-a-PDF-to-Excel-Step-3.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Click Data , located in the menu above the edit ribbon, near the File and Review sections.

If you’re on a Mac, this will be the menu that runs along the top of the screen.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/7/74/Copy-a-Table-from-a-PDF-to-Excel-Step-4.jpg/v4-728px- Copy-a-Table-from-a-PDF-to-Excel-Step-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/7/74/Copy-a- Table-from-a-PDF-to-Excel-Step-4.jpg/v4-728px-Copy-a-Table-from-a-PDF-to-Excel-Step-4.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Click Get Data . On Windows, this is the farthest icon to the left of the menu.

If you’re on a Mac, you’ll see this option in the drop-down menu when you click Data .

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/e/e5/Copy-a-Table-from-a-PDF-to-Excel-Step-5.jpg/v4-728px- Copy-a-Table-from-a-PDF-to-Excel-Step-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/e/e5/Copy-a- Table-from-a-PDF-to-Excel-Step-5.jpg/v4-728px-Copy-a-Table-from-a-PDF-to-Excel-Step-5.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Click From File and select From PDF . When hovering over the first option, the menu will keep expanding for you to choose From PDF . Then Excel will open the file manager (Finder for Mac and File Explorer for Windows).

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/7/74/Copy-a-Table-from-a-PDF-to-Excel-Step-6.jpg/v4-728px- Copy-a-Table-from-a-PDF-to-Excel-Step-6.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/7/74/Copy-a- Table-from-a-PDF-to-Excel-Step-6.jpg/v4-728px-Copy-a-Table-from-a-PDF-to-Excel-Step-6.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Navigate and double-click the PDF file. You can also select the PDF file and then click Import .

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/4/4b/Copy-a-Table-from-a-PDF-to-Excel-Step-7.jpg/v4-728px- Copy-a-Table-from-a-PDF-to-Excel-Step-7.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/4/4b/Copy-a- Table-from-a-PDF-to-Excel-Step-7.jpg/v4-728px-Copy-a-Table-from-a-PDF-to-Excel-Step-7.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Click the table that you want to copy from the PDF to Excel. Knowing where the table is to be copied is also useful because the data will be labeled by location (the page containing the table).

When you click on the table on the left, a preview of the table will appear in the right pane.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/4/4f/Copy-a-Table-from-a-PDF-to-Excel-Step-8.jpg/v4-728px- Copy-a-Table-from-a-PDF-to-Excel-Step-8.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/4/4f/Copy-a- Table-from-a-PDF-to-Excel-Step-8.jpg/v4-728px-Copy-a-Table-from-a-PDF-to-Excel-Step-8.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Click the Load button. This option located in the lower right corner will allow you to copy the table from the PDF file to the Excel sheet.

If you want to make changes in the table, you can do so after clicking the Load button. ^{[1] X Research Source}

Steps

Related Posts