How to copy a table from PDF to Excel: 8 methods explained

Did that dreaded "Please find attached PDF" email just land in your inbox? That's another afternoon lost to copy-pasting tables into Excel? I get it.

As someone who helps companies process thousands of PDFs monthly, I've seen how much time gets wasted on manual data entry. The average office worker spends nearly 2 hours every week just copying data between applications — that's over 90 hours a year!

Here's the thing about PDFs: they're designed for viewing, not editing. That's why extracting tables from them is such a headache for businesses worldwide. Whether you're dealing with invoices, financial statements, analytical reports, or customer data, accurately getting this information into a spreadsheet can be a nightmare. Tables break apart, numbers go missing, and formatting disappears, all while those deadlines keep getting closer.

I'm sharing the eight methods I tested to copy tables from PDFs to Excel. Whether you need a quick fix for a one-time task or a robust solution for thousands of documents, you'll find one that fits your needs. No more wasted afternoons manually retyping or reformatting PDF data — just more meaningful work.

A quick overview of all PDF to Excel methods

Here's the table with the links removed:

Copy tables from PDF to Microsoft Excel without any additional software

Sometimes, you may not have the time or permission to install or sign up for new software. You want to quickly transfer the PDF data into an Excel table and continue your work. 

Here are a few different ways to do it:

1. The standard copy-paste method

Let's start with the most basic approach – good old copy and paste. Fair warning: while it's quick and requires no extra tools, you'll likely need to clean up the formatting afterward. This works best for simple tables when you're in a hurry.

Here's a quick step-by-step guide to copy and paste table from PDF to Excel:

1. Open your PDF document
2. Select the data table you want to copy
3. Right-click and choose 'Copy' or press Ctrl+C (Cmd+C on a Mac)
4. Open a new Excel spreadsheet
5. Right-click on the cell where you want to paste the data and select 'Paste' or press CTRL + V (Cmd + V on a Mac)

The content will now be in Excel table. The formatting might be a bit wonky, so you may need to clean it up a bit.

I'd like point out that manually copying tables, with or without the wizard, might not work so well with scanned images or PDFs with really intricate layouts. If you are dealing with bigger or more complex tabular data, I recommend you check out the other methods discussed in this article.

You cannot manually copy PDF data to Excel tables if they are scanned images or documents with complex layouts. Consider one of the other methods discussed in the article for larger or more complicated tasks.

2. Copy PDF tables from Google Docs or MS Word

Google Docs and Microsoft Word have built-in capabilities for opening and editing PDF files. This can be handy if you need to copy from PDF to Excel quickly.  

To use Google Docs to copy data from PDF into Excel tables, follow these steps:

1. Go to your Google Drive
2. Upload your PDF
3. Right-click the file and select 'Open with > Google Docs'
4. Find the PDF content imported into a new Google Docs document
5. Edit the content, if needed
6. Copy and paste the tables into the spreadsheet you’re working on

To use MS Word as an intermediary to copy data from PDF into Excel, follow these steps:

1. Go to 'File' > 'Open' > 'Browse'
2. Select the PDF file you want to open
3. The PDF will be opened in a new Word document
4. Edit the content, if needed
5. Copy and paste the relevant tables into your spreadsheet
6. Format the data in Excel as needed. You may need to adjust column widths, merge cells, or realign data.

In Excel, click on the 'Paste' menu to see more paste options. You can choose to match the destination formatting or keep the source formatting. Additionally, if you want to maintain a link to the original Word table, select 'Paste Link' in the Paste Special menu.

Google Docs and Microsoft Word's built-in OCR works well for some because it is free. But you may want to temper your expectations. During my testing, I ended up struggling with jumbled paragraphs, skewed tables, and misaligned data. If you go this route, budget some extra time for cleanup — you'll probably need it.

These tools struggle with complex tables, scanned images, and PDFs with intricate layouts. They work better for simpler, text-heavy PDF files.

3. Use Adobe Acrobat Pro to copy PDF tables to Excel

Acrobat Reader Pro offers several built-in features for extracting tables from PDF to Excel. Firstly, convert PDF table to Excel using its 'Export PDF to' feature.

The steps involved in converting PDF to XLSX using Adobe Acrobat Reader:

1. Open the PDF file in Adobe Acrobat Reader Pro
2. Click on 'Convert' from the top menu bar
3. Select 'Microsoft Excel (XLSX)' as the output format
4. Set your document language
5. Adjust the 'Save As XLSX Settings' based on your preference — choose to have the entire document in one worksheet or have new worksheets for each table/page and decide how numeric data should be detected
6. Select the destination where you want to save the file, whether it's on your desktop, Adobe Cloud, or other cloud storage services
7. Set a name for the output XLSX file and click 'Save'
8. Open the file, copy the required cells, and paste them into the Excel spreadsheet you're working on

In my tests, this method handled simple, well-structured tables beautifully. But accuracy dropped to significantly with scanned documents and complex multi-page reports. The real dealbreaker? It can only process one file at a time — makes it impractical for large-scale tasks.

Adobe's 'Select text' feature offers another way to grab your data. Just highlight the table content you want, copy it over to Excel, and you're done.

Here's how to extract PDF tables with formatting using Adobe Acrobat Reader:

1. Open the PDF file in Adobe Acrobat Pro
2. Select the 'Select' tool from the top toolbar
3. Drag your mouse to select the table content you want to copy
4. Right-click the selected content and choose 'Copy With Formatting’
5. Open a new Excel spreadsheet and paste the copied content
6. Adjust the formatting as needed

This method works even for scanned PDFs. Acrobat’s OCR technology can recognize and extract text from images. Since the workflow is relatively straightforward, it is an intuitive option for users who need to copy tables from PDF to Excel quickly.

However, it can be time-consuming if you have multiple tables or pages to extract or if the tables span multiple pages. I also found that it may struggle with complex layouts or poor-quality scans.  I ended up manually fixing much of the data before I could use it in my analysis.

Bonus tip: Adobe lets you copy tables as images. Perfect for preserving complicated formatting or if the table contains complex elements that don't copy correctly as text. However, it may not be helpful if you need to edit or manipulate the data in Excel.

4. Directly import table from PDF to Excel

Let's face it, sometimes, you just need to copy a table from a PDF to Excel. No bells and whistles — you just need a straightforward solution. 

Microsoft Excel's Get Data feature is what you need. It is quick and easy. And you don't need any additional software.

Steps to use Excel's built-in PDF import option:

1. Open an Excel spreadsheet
2. Click on the Data tab in the upper menu 
3. Click on the Get Data menu, followed by 'From File' and then 'From PDF'
4. Select the PDF file from which you want to import data into Excel
5. Review the different PDF tables that Excel has identified
6. Select the table(s) you want to import and click 'Load'
7. Copy the required cells and paste them into the Excel spreadsheet you're working on

You have the option to select individual tables or all the tables present on a single page. Moreover, you can also transform the sheet using a Power Query editor. This editor allows you to adjust the data, like removing unnecessary columns or rows, splitting or merging columns, changing data types, filtering or sorting the data, and adding calculated columns.

5. Upload your PDF to an online conversion tool

There are many simple web-based conversion tools out there that can simplify the PDF table to Excel workflow. Whether you want the output in CSV, XLS, or XLSX format, these tools can manage it all. 

All you have to do is upload the PDF. Let the tool process and convert the file. You can then download it in the spreadsheet format of your choice. The reliability, functionality, and accuracy of these tools can vary greatly, but they generally work well for simple tasks.

Some of the most popular PDFs to Excel converters include:

• PDF to Excel
• PDF to CSV
• ilovepdf
• Acrobat's PDF converter tools
• SodaPDF
• Smallpdf
• Pdf2go
• Pdftoexcelonline
• Freepdfconvert
• Freepdftoexcel

Here's how to convert PDF tables to Excel using online converters:

1. Head over to the website of the online tool
2. Click on 'Upload file' or 'Choose file'
3. Select the PDF file you want to convert
4. Choose the output format (usually CSV, XLS, or XLSX)
5. Click 'Convert'
6. Download the converted file
7. Open the file, copy the table and paste it into your Excel spreadsheet

While these tools offer free plans, I'd be careful about using them for sensitive data. Most require upgrading to premium for advanced features, and you may want to think twice before uploading financial documents to any online service. Read those privacy policies carefully — your data security might depend on it.

Despite being easy to use, these tools have their limitations. If you are dealing with complex tables, scanned or image-based PDFs, or multi-page tables, these online converters might not yield the best results. More importantly, these tools won't be adequate if you need to copy a large number of tables regularly or if you require batch-processing capabilities.

Extract PDF table to Excel using dedicated open-source software

Open-source software can provide powerful solutions for extracting tables from PDFs to Excel. These tools are free to use and can often handle more complex tasks than the abovementioned methods.

Plus, since everything runs locally on your machine, you never have to worry about your sensitive data leaving your control.

6. Snip PDF tables and extract data using Tabula

If you are an open-source enthusiast, then Tabula is an excellent choice. This Java-based tool allows you to extract tables from PDF files and convert them into CSV or Microsoft Excel format. 

Since it is a desktop application, you must download and install it on your computer. Then follow these steps to extract your PDF table into Excel:

1. Import your PDF file
2. Snip the rows and columns of the table you want to extract
3. Click on the 'Preview & Export Extracted Data' button
4. Verify the data in the preview; if it looks good, click 'Export'
5. Choose your preferred format (CSV or Excel) and save the file
6. Open the saved file in Excel, copy the required cells, and paste them into your Excel spreadsheet

Tabula works best for PDFs with simple and well-structured tables. It doesn't work on PDFs with scanned images or complex layouts, nor does it support batch processing. It may not be the best choice for copying large volumes of data or dealing with intricate table structures. 

7. Extract tables with Excalibur

Excalibur might suit you if you are a tech-savvy individual who doesn't mind getting your hands dirty. Excalibur is a web interface for extracting tabular data from PDFs, built on top of Camelot, a Python library known for its high accuracy and speed.

Follow these steps to use Excalibur to extract your PDF table into Excel:

1. Set up Excalibur on your machine before using it
2. Open any PDF using Excalibur
3. Enter the page numbers where your tables are located
4. Snip the relevant rows and columns or use its auto-detect feature
5. Extract the data from the tables
6. Download the extracted data as a CSV or Excel file
7. Open the downloaded file in Excel, copy the required cells, and paste the table into your Excel worksheet

Excalibur gave me a lot more control over the extraction process — it can autodetect tables, export in multiple formats, and even fine-tune the extraction settings.

However, it requires technical knowledge and installation, which might not be suitable for everyone. It's also worth noting that, like Tabula, Excalibur might struggle with PDFs containing scanned images or complex tables and doesn't support batch processing.

8. Use AI-powered OCR tools to automate PDF data extraction

The manual and semi-automated methods fall short when dealing with large-scale data extraction. If you have to extract tables from hundreds or thousands of PDFs, manual methods simply won't cut it.

You'll need an automated solution that offers OCR and AI capabilities. It can accurately identify and extract tables from PDFs, regardless of the language, complexity, or layout – even scanned or image PDFs. Nanonets is a leader in this space, offering a powerful AI-based OCR tool that can handle all sorts of PDF processing with ease.

Full disclosure: I work for Nanonets. But there are several other options out there, like ABBYY FineReader, Tungsten, Docparser, and more. The right choice depends on your volume, complexity, and budget.

Convert PDF table to Excel from PDFs with Nanonets

What makes Nanonets a great fit? For starters, it offers a free PDF-to-Excel converter tool that allows you to convert your documents in a few simple steps:

1. Upload your PDF file or drag and drop it into the upload box
2. Click 'Convert to Excel' and let the tool work its magic
3. Download your fully formatted Excel file within seconds

For more advanced features, use Nanonets' Table OCR solution. The model has been pre-trained on millions of documents and tested to ensure high accuracy and reliability out of the box. It allows you to use advanced AI-powered OCR on PDFs and automate even the most complex PDF to Excel workflows, from invoice processing to financial data extraction and beyond.

Here are the steps involved:

1. Create a free account at app.nanonets.com.
2. Choose the 'Table OCR' model from the main dashboard.
3. Upload your PDFs or images containing tables via manual upload, cloud storage import, email, or API.
4. Nanonets will automatically extract the table data.
5. Review the extracted data and make any necessary corrections or adjustments.
6. Export the data to your preferred format or integrate it with other tools.
7. To automate the entire process, use Nanonets' Workflows feature to set up auto-import, data validations, approval flows, and auto-exports.

With Nanonets, you can:

• Automate the ingestion of digital and scanned PDFs directly from email inboxes, cloud storage like Google Drive and Dropbox, and other business tools via APIs or Zapier integration.
• Train the models to extract the specific table fields you need. Nanonets can handle standard fields like names, dates, and totals, as well as line item details like product codes, quantities, and descriptions.
• Connect Nanonets with the tools you already use, like your ERP, accounting software, online forms, or database. Automatically sync extracted data to keep all your systems up to date.
• Fully automate your data extraction pipeline. Set up import sources, add data validations and formatting rules, configure review flows and approval hierarchies, and automate exports to your other business systems.

You can streamline data extraction for a variety of document types and industries, including:

• Financial statements and reports
• Bank statements, receipts, and transaction records
• Invoices and purchase orders
• Medical records and lab results
• Insurance claim submissions
• Shipping manifests and bills of lading
• Legal contracts and agreements

No matter what type of document you're working with, Nanonets can automate the extraction process and eliminate the manual entry of any tabular data. You don't need to be a tech whiz to use it, the interface is intuitive and requires no coding or special training. The platform supports API integration for custom workflows.

Let's look at a simple example. If you work in the accounts department and need to process invoices for the organization's tech tools, you may encounter invoices with varied layouts, structures, and formats. Manually checking each, copying data from tables, and inputting it into an Excel table for analysis can be a nightmare.

With the Nanonets, you just have to upload invoices. It does the rest: identifies the layout, Key-Value Pairs, and extracts data fields like invoice number, date, vendor name, amount, etc. The information is compiled into a spreadsheet and exported to accounting software like QuickBooks. No more tedious data entry or inaccurate records.

The tool learns from your edits. The AI processing gets smarter with each interaction, making future extractions more accurate. It can handle unstructured data or complex tables in PDFs.

Nanonets takes data security and privacy seriously. It uses advanced encryption to protect data during upload, processing, and storage. The platform is GDPR and CCPA-compliant, ensuring that sensitive information remains secure.

Wrapping up

Here's hoping you won't have to look up how to transfer a table from a PDF file to Excel ever again. There is more than one way to handle this task. However, automation is undoubtedly the most efficient way to handle the task when dealing with large volumes of data.

The perfect method depends on what suits your specific scenario. Assess your tables' complexity and consider the volume and the time you're prepared to invest. After all, figuring out how to copy a table from PDF to Excel shouldn't be an arduous task.

FAQs