Using PDF Files is an easy and secure way to mail out and share documents. When you want to retain the format and details of a table, it’s a good idea to convert the document into a PDF file. However, extracting tables from one is quite a task if you’re receiving a PDF file.
Of course, you would want to save time and wouldn’t want to create a new table from scratch. So, how do you extract tables from PDF without relying on copy and paste? Here are some of the ways you can achieve that.
USING ONLINE CONVERTERS
The quickest way is to use the online file converters to change the PDF file to any other document format you want. Several free online tools convert PDF to Excel to extract tabular data. Popular examples are cometdocs and Smallpdf. However, most of these tools offer only basic extraction capabilities.
DISCLAIMER: We strong advise you to avoid using online convertors while dealing with PDF files that contant confidential and sensitive information.
Here’s how to extract tables from PDF files using Smallpdf:
Step 1: Visit the Smallpdf website.
![Extract tables from pdf step 1](https://cdn.guidingtech.com/imager/assets/2021/06/1999895/extract-tables-from-pdf-step-1_2021-06-17-112630_7c4a12eb7455b3a1ce1ef1cadcf29289.jpg?1623930312)
Step 2: Select the conversion to be done.
![Extract tables from pdf step 2](https://cdn.guidingtech.com/imager/assets/2021/06/1999896/extract-tables-from-pdf-step-2_2021-06-17-112638_7c4a12eb7455b3a1ce1ef1cadcf29289.jpg?1623930314)
ALSO ON GUIDING TECH
Top Freemium PDF Editors for Windows 10READ MORE
Step 3: Drag the PDF file to be converted into the PDF converter.
![Extract tables from pdf step 3](https://cdn.guidingtech.com/imager/assets/2021/06/1999897/extract-tables-from-pdf-step-3_2021-06-17-112725_7c4a12eb7455b3a1ce1ef1cadcf29289.jpg?1623930314)
Step 4: Once the file is done uploading, click on Convert to Excel.
![Extract tables from pdf step 4](https://cdn.guidingtech.com/imager/assets/2021/06/1999898/extract-tables-from-pdf-step-4_2021-06-17-112737_7c4a12eb7455b3a1ce1ef1cadcf29289.jpg?1623930319)
Step 5: Click on Download to save the PDF file to your device.
![Extract tables from pdf step 5](https://cdn.guidingtech.com/imager/assets/2021/06/1999899/extract-tables-from-pdf-step-5_2021-06-17-112745_7c4a12eb7455b3a1ce1ef1cadcf29289.jpg?1623930316)
Step 6: Launch the downloaded excel to confirm if your table has been accurately converted.
![Extract tables from pdf step 6](https://cdn.guidingtech.com/imager/assets/2021/06/1999900/extract-tables-from-pdf-step-6_2021-06-17-112753_7c4a12eb7455b3a1ce1ef1cadcf29289.jpg?1623930317)
EXTRACT TABLES USING MICROSOFT POWER BI
Microsoft BI is another useful tool to extract table data from PDF files. Particularly, the Power Query feature on Power BI makes it easy for users to import PDF files and extract the table data inside the document.
However, this works only for those with Office 365 subscription. Alternatively, you will have to purchase a Power BI package separately.
The Power Query feature is also available under the Power BI free trial. Here’s how to use it to extract tabular data:
Step 1: Download, install, and launch Microsoft Power BI.
![Extract tables from pdf step 7](https://cdn.guidingtech.com/imager/assets/2021/06/1999901/extract-tables-from-pdf-step-7_2021-06-17-112804_7c4a12eb7455b3a1ce1ef1cadcf29289.jpg?1623930317)
Step 2: Select Get Data in the Home section of the app’s desktop.
![Extract tables from pdf step 8](https://cdn.guidingtech.com/imager/assets/2021/06/1999902/extract-tables-from-pdf-step-8_2021-06-17-112811_7c4a12eb7455b3a1ce1ef1cadcf29289.jpg?1623930321)
Step 3: Click on File then select PDF.
![Extract tables from pdf step 9](https://cdn.guidingtech.com/imager/assets/2021/06/1999903/extract-tables-from-pdf-step-9_2021-06-17-112813_7c4a12eb7455b3a1ce1ef1cadcf29289.jpg?1623930320)
Step 4: Click on Connect to browse the location of the PDF file on your computer.
![Extract tables from pdf step 10](https://cdn.guidingtech.com/imager/assets/2021/06/1999904/extract-tables-from-pdf-step-10_2021-06-17-112820_7c4a12eb7455b3a1ce1ef1cadcf29289.jpg?1623930321)
Step 5: Select the location of the PDF file to import it into Power BI.
![Extract tables from pdf step 11](https://cdn.guidingtech.com/imager/assets/2021/06/1999905/extract-tables-from-pdf-step-11_2021-06-17-112829_7c4a12eb7455b3a1ce1ef1cadcf29289.jpg?1623930322)
Step 6: Once the file has been imported into Power BI, you should see a Navigator with table numbers and Page numbers. Select the Table Number to be loaded.
![Extract tables from pdf step 12](https://cdn.guidingtech.com/imager/assets/2021/06/1999906/extract-tables-from-pdf-step-12_2021-06-17-112838_7c4a12eb7455b3a1ce1ef1cadcf29289.jpg?1623930323)
Step 7: Select Load to create the Table on Power BI.
![Extract tables from pdf step 24](https://cdn.guidingtech.com/imager/assets/2021/06/1999907/extract-tables-from-pdf-step-24_2021-06-17-112854_7c4a12eb7455b3a1ce1ef1cadcf29289.jpg?1623930325)
USING MICROSOFT EXCEL
Microsoft Excel like Power BI has the Power Query feature which can be used to load PDF files and extract tabular data. However, this feature is only available on Excel 2016 or newer versions. Here’s how it works:
Step 1: Launch Microsoft Excel.
ALSO ON GUIDING TECH
#PDFCLICK HERE TO SEE OUR PDF ARTICLES PAGE
![Extract tables from pdf step 18](https://cdn.guidingtech.com/imager/assets/2021/06/2000111/extract-tables-from-pdf-step-18_2021-06-17-114325_7c4a12eb7455b3a1ce1ef1cadcf29289.jpg?1623930326)
Step 2: Select Data on the Ribbon.
![Extract tables from pdf step 19](https://cdn.guidingtech.com/imager/assets/2021/06/2000112/extract-tables-from-pdf-step-19_2021-06-17-114345_7c4a12eb7455b3a1ce1ef1cadcf29289.jpg?1623930327)
Step 3: Select Get Data to launch the dropdown.
![Extract tables from pdf step 20](https://cdn.guidingtech.com/imager/assets/2021/06/2000114/extract-tables-from-pdf-step-20_2021-06-17-114413_7c4a12eb7455b3a1ce1ef1cadcf29289.jpg?1623930329)
Step 4: Select From File and From PDF.
![Extract tables from pdf step 21](https://cdn.guidingtech.com/imager/assets/2021/06/2000113/extract-tables-from-pdf-step-21_2021-06-17-114407_7c4a12eb7455b3a1ce1ef1cadcf29289.jpg?1623930330)
Step 5: Select the location of the PDF file to import it into Excel.
![Extract tables from pdf step 22](https://cdn.guidingtech.com/imager/assets/2021/06/2000115/extract-tables-from-pdf-step-22_2021-06-17-114419_7c4a12eb7455b3a1ce1ef1cadcf29289.jpg?1623930331)
Step 6: Once the file has been imported into Excel, you should see a Navigator with table numbers, page numbers or a preview of the data within the PDF. Select the Table Number to be loaded.
![Extract tables from pdf step 23](https://cdn.guidingtech.com/imager/assets/2021/06/2000116/extract-tables-from-pdf-step-23_2021-06-17-114426_7c4a12eb7455b3a1ce1ef1cadcf29289.jpg?1623930332)
Step 7: Select Load to create the table on Excel.
![Extract tables from pdf step 24](https://cdn.guidingtech.com/imager/assets/2021/06/1999966/extract-tables-from-pdf-step-24_2021-06-17-113045_7c4a12eb7455b3a1ce1ef1cadcf29289.jpg?1623930334)
If you’re using Microsoft Office 2016 or a newer package and you observe that your data tab does not contain the Power Query feature. Here’s how to install it.
Step 1: Visit the Microsoft Website.
Step 2: Select the Language of the add-on.
![Extract tables from pdf step 13](https://cdn.guidingtech.com/imager/assets/2021/06/1999997/extract-tables-from-pdf-step-13_7c4a12eb7455b3a1ce1ef1cadcf29289.jpg?1623930336)
Step 3: Select Download.
![Extract tables from pdf step 14](https://cdn.guidingtech.com/imager/assets/2021/06/1999998/extract-tables-from-pdf-step-14_7c4a12eb7455b3a1ce1ef1cadcf29289.jpg?1623930336)
Step 4: Select the version of the add-in you want to download.
![Extract tables from pdf step 15](https://cdn.guidingtech.com/imager/assets/2021/06/1999999/extract-tables-from-pdf-step-15_7c4a12eb7455b3a1ce1ef1cadcf29289.jpg?1623930337)
Step 5: Select Next to commence download.
![Extract tables from pdf step 16](https://cdn.guidingtech.com/imager/assets/2021/06/2000000/extract-tables-from-pdf-step-16_7c4a12eb7455b3a1ce1ef1cadcf29289.jpg?1623930338)
Step 6: Once the file has completed download, Run the file to install the add-in.
![Extract tables from pdf step 17](https://cdn.guidingtech.com/imager/assets/2021/06/2000001/extract-tables-from-pdf-step-17_7c4a12eb7455b3a1ce1ef1cadcf29289.jpg?1623930340)
USING ADOBE ACROBAT PRO DC
Adobe Acrobat Pro DC is another tool that can be used to extract tabular data from PDF files or convert PDF files into other file types such as excel for data analysis. The tool has a 7-day trial version and a professional version and can be used online or downloaded to a device.
Adobe Acrobat Web Version
Here’s how to use the web version to extract tabular data:
Step 1: Visit the Adobe Acrobat Pro DC weblink.
Step 2: At the top of the page, select the Convert menu.
![Extract tables from pdf step 25](https://cdn.guidingtech.com/imager/assets/2021/06/2000002/extract-tables-from-pdf-step-25_7c4a12eb7455b3a1ce1ef1cadcf29289.jpg?1623930341)
Step 3: Scroll down the website and locate PDF to Excel.
![Extract tables from pdf step 26](https://cdn.guidingtech.com/imager/assets/2021/06/2000003/extract-tables-from-pdf-step-26_7c4a12eb7455b3a1ce1ef1cadcf29289.jpg?1623930342)
ALSO ON GUIDING TECH
Top 5 PDF Editors for MacREAD MORE
Step 4: On the new pop-up menu, drag and drop the PDF file you want to convert.
![Extract tables from pdf step 27](https://cdn.guidingtech.com/imager/assets/2021/06/2000004/extract-tables-from-pdf-step-27_7c4a12eb7455b3a1ce1ef1cadcf29289.jpg?1623930343)
Step 5: Once the file is done uploading, select Export to XLSX.
![Extract tables from pdf step 28](https://cdn.guidingtech.com/imager/assets/2021/06/2000005/extract-tables-from-pdf-step-28_7c4a12eb7455b3a1ce1ef1cadcf29289.jpg?1623930344)
Step 6: Select the Download icon at the top of the page to save the converted file to your device.
![Extract tables from pdf step 29](https://cdn.guidingtech.com/imager/assets/2021/06/2000006/extract-tables-from-pdf-step-29_7c4a12eb7455b3a1ce1ef1cadcf29289.jpg?1623930345)
ADOBE ACROBAT ON PC
Here’s how to use the PC version to extract tabular data:
Step 1: Launch the Adobe Acrobat Pro DC app.
![Extract tables from pdf step 32](https://cdn.guidingtech.com/imager/assets/2021/06/2000007/extract-tables-from-pdf-step-32_7c4a12eb7455b3a1ce1ef1cadcf29289.jpg?1623930347)
Step 2: On the app, select Open a File.
![Extract tables from pdf step 30](https://cdn.guidingtech.com/imager/assets/2021/06/2000008/extract-tables-from-pdf-step-30_7c4a12eb7455b3a1ce1ef1cadcf29289.jpg?1623930348)
Step 3: Using the file library select the PDF file to be imported to the app.
![Extract tables from pdf step 31](https://cdn.guidingtech.com/imager/assets/2021/06/2000009/extract-tables-from-pdf-step-31_7c4a12eb7455b3a1ce1ef1cadcf29289.jpg?1623930349)
Step 4: Once the file opens, use the cursor to highlight the table data.
![Extract tables from pdf step 33](https://cdn.guidingtech.com/imager/assets/2021/06/2000010/extract-tables-from-pdf-step-33_7c4a12eb7455b3a1ce1ef1cadcf29289.jpg?1623930350)
Step 5: Right-click on the highlighted area and select Export Selection As.
![Extract tables from pdf step 34](https://cdn.guidingtech.com/imager/assets/2021/06/2000011/extract-tables-from-pdf-step-34_7c4a12eb7455b3a1ce1ef1cadcf29289.jpg?1623930352)
Step 6: On the File Library input details of the File Name and select the File Type.
![Extract tables from pdf step 35](https://cdn.guidingtech.com/imager/assets/2021/06/2000012/extract-tables-from-pdf-step-35_7c4a12eb7455b3a1ce1ef1cadcf29289.jpg?1623930353)
COMPARING TWO PDF FILES
Extracting tables from PDF files is not an impossible task. Using Power Query on Excel and Power BI, you can import other file types apart from PDF. On the other hand, using Adobe Acrobat Pro DC, you can compare two PDF files side by side.
More Stories
How to Monitor Backlinks Effectively?
How to use new Immersive View in Zoom video calls
How to enable Mini Menus for text selection in Microsoft Edge