Copy Table from PDF to Excel with Formatting (2 Effective Ways)

If you have a table in PDF format that you want to copy to your Excel worksheet, you may get jumbled and non-formatting results. As PDFs and Excel don’t share common interests, it’s not easy to copy PDF tables to Excel with formatting. In this tutorial, you will learn 2 quick ways to do that with proper examples and illustrations.


Download Practice Workbook

You can download the practice workbook that we have used to prepare this article.


2 Handy Ways to Copy Table from PDF to Excel with Formatting

Let’s first introduce our sample dataset. The table is in PDF mode, our goal is to copy the table from PDF to Excel with formatting.

2 Handy Ways to Copy Table from PDF to Excel with Formatting


1. Import Data from PDF and Copy Table to Excel with Formatting

By using the import feature, you can easily copy a table from pdf format to an Excel file. Just follow the steps below.

Steps:

  • First, open a new workbook or continue a running project in Excel.

  • Select a cell (In this example, B2) where you need to start the first cell of your table.
  • Go to Data tab > Get Data > From File > From PDF.

Copy Table from PDF to Excel with Formatting by Importing

  • Excel will show your file manager for windows. Now, double click on the PDF file where your table is. Or single click to select the PDF file and then click Import.

Copy Table from PDF to Excel with Formatting by Importing

  • In the Navigator window, click the table which is already labeled by page number. You can see a preview of the table on the right side. If this is your desired table, then click Load.

Copy Table from PDF to Excel with Formatting by Importing

Finally, here is the result.

Copy Table from PDF to Excel with Formatting by Importing (Result)

Read More: How to Extract Data from PDF to Excel (4 Suitable Ways)


2. Copy Table Data from PDF to Word and Then to Excel

You can copy a table from PDF to Excel by using an intermediary application which is known as a Word document. Just follow the steps below.

Steps:

  • First, open the PDF file where your table is.
  • Select and copy the table by pressing CTRL+C.

Copy Table from PDF to Excel with Formatting by Converting the File

  • Then, open a Blank document in your MS word.

  • Press CTRL+V to paste the table on the word document. The data in the table will appear without grids as the PDF file.

Copy Table from PDF to Excel with Formatting by Converting the File

  • Now, highlight the data in the word document by pressing CTRL+A.
  • Go to Insert > Table > Convert Text to Table. A Convert Text to Table window will pop up.

Copy Table from PDF to Excel with Formatting by Converting the File

  • Select Other under Separate text at section. Leave a space in the box of Other option. Finally, click OK.

Copy Table from PDF to Excel with Formatting by Converting the File

At this stage, an imperfectly formatted table will appear on your word document. Press CTRL+C to copy the table and paste it to your Excel file.

  • Open an Excel worksheet where you wish to have the table. And highlight the 1st cell on this worksheet (in this example, B2). This cell will be the 1st cell of your table.

Copy Table from PDF to Excel with Formatting by Converting the File (Result)

Read More: How to Convert PDF to Excel without Software (3 Easy Methods)


Conclusion

In this article, we have learned how to copy tables from PDF to Excel with formatting. I hope this discussion has been useful for you. If you have any questions or any kind of feedback, please don’t hesitate to let us know in the comment box. You can visit our website ExcelDemy to learn more Excel-related content. Happy reading!


Related Articles

Hafiz Islam
We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo