PDFPro Logo

How to Convert PDF to Excel (2024): Windows, Mac, Mobile, Online

thumbnailA
May 11, 2023
Last Updated
March 15, 2024
9 min read

PDFs are great for preserving and sharing documents, but what if you need to make changes to your spreadsheet? Convert you PDF to Excel, first!

hero

Are you looking for a step-by-step guide to convert PDF to Excel for free? Read on!

Jump To The section

While PDF and Excel are two of the most popular and widely-used file formats, they have different uses.

PDFs are best used to store, preserve, and share documents. While Excel files are spreadsheets used to format, organize, and calculate data.

So, if you need to rearrange data or perform further analysis, you'll want to work on the original Excel file. If you don't have access to it, then you'll need to convert the PDF to Excel.

But how do you convert a PDF to Excel?

From our experience, PDF to Excel conversions are seldom perfect. Expect to have to edit or redo data or formatting in your new Excel workbook.

However, some methods are better than others, and it's probably easier than you think.

That's why we've created this guide: to compile the best and easiest methods for converting PDFs to Excel in 2024 for Window, Mac, and Mobile!

What to Know Before You Start

Here are some important tips to keep in mind when converting a PDF to Excel:

  1. Converting PDF to Excel isn't perfect; expect to have to redo data, formatting, etc.
  2. A low-tech solution is to Copy the data from the PDF, and Paste it into Excel. (Doesn't work on all PDFs).
  3. To convert PDF to Excel for free, on any device, use our online PDF to Excel Converter.
  4. If you're a Windows user: use a PDF editor like PDF Pro.
  5. If you're a Mac user: Preview and Automator can copy and paste text from PDFs to Excel, but a PDF editor is your best bet.

Why Convert PDF to Excel?

There main benefit of converting PDF to Excel is that data-entry, calculations, and formatting tables is much easier on Excel than PDF.

While PDF editors make it easy to edit PDFs, PDFs are often the used to preserve and share the content in documents. If you're using or changing the data in the spreadsheet, you'll want to work on it in Excel format.

There are a few different formats when it comes to Excel workbooks, but we'll refer to the most common one (.xlsx) in this guide.

How to Convert PDF to Excel for Free

There's more than one way to convert PDFs to Excel, ranging from using Microsoft Office products, to using online converters.

Online PDF to Excel Converter

The best way to convert a PDF to Excel for free, online is with an online PDF to Excel converter.

A good online converter can instantly convert a PDF to Excel in your browser, from almost any device. Without needing to install or buy additional software.

We recommend PDF Pro's PDF to Excel Converter. No sign-up or email is required, and there's no limit on how many times you can use this free tool.

1. Visit PDF Pro's PDF to Excel Converter.

PDF Pro's online PDF to Excel converter.

2. Upload your PDF.

PDF Pro's online PDF to Excel converter. There is a red arrow pointing to the Upload File button.

3. Follow the on-screen prompts.

PDF Pro's online PDF to Excel converter during use. Two buttons are shown, allowing you to convert to .csv or .xlsx.

4. Download your file.

PDF Pro's online PDF to Excel converter after the conversion. A message says "Your PFD file has been converted to Excel"

Copy & Paste

If you are able to select the text within your PDF, then copy and pasting the data to Excel may be a sufficient solution for you.

Note: If you're unable to select the text within the PDF, you'll need to try a different method in this guide.

1. Open the PDF that you want the data from.

2. Select and copy the data: right-click > Copy, or press [ctrl] + [c] on your keyboard.

Text within a PDF is selected. The context menu is open, the Copy option is highlighted.

3. Launch Microsoft Excel.

4. Open a blank workbook, or an existing one.

Microsoft Excel. The Blank workbook button is highlighted.

5. Select where you want to Paste the data, then right-click > Paste, or press [ctrl] + [v] on your keyboard.
Tip: you may want to consider using different Paste options with your data. You can access Paste Special options from the Home tab > Paste button > Paste Special...

Microsoft Excel. The Right-click context menu is showing. The Paste text button is highlighted.

Microsoft Word

If you have access to Microsoft Word (or Office), you can use it open a PDF in Word, copy the data, then paste the data from the PDF to an Excel spreadsheet.

This is especially helpful if you can't copy the text from the PDF, itself.

1. Launch Microsoft Word.

2. Press Open > Browse.

The File menu in Microsoft Word. The Browse button is highlighted.

3. Find and Open the PDF you want to convert.

The Open dialog box in Microsoft Word. A PDF is selected. The Open button is highlighted.

4. Click Ok.

Microsoft Word pop up saying that "word will now convert your PDF to an editable Word document". 
The OK button is highlighted.

5. Turn off Protect View: Click Enable Editing of the Word document (if necessary).

6. Select the text and information you need: right-click > Copy, or press [ctrl] + [c] on your keyboard.

The right-click context menu in Microsoft Word.  The Copy selection is highlighted.

7. Launch Microsoft Excel.

8. Open a blank workbook, or an existing one.

Microsoft Excel. The Blank workbook button is highlighted.

9. Select where you want to Paste the data, then right-click > Paste, or press [ctrl] + [v] on your keyboard.
Tip: you may want to consider using different Paste options with your data. You can access Paste Special options from the Home tab > Paste button > Paste Special...

Microsoft Excel. The Right-click context menu is showing. The Paste text button is highlighted.

How to Convert PDF to Excel in Windows

If you work with PDF and Excel files on a regular basis, then you'll want to invest in a PDF editor.

A good PDF editor can instantly convert PDF to Excel (and vice versa), instantly. And can even batch convert multiple PDFs to Excel files.

PDF Pro

When it comes to PDF editors, we recommend PDF Pro: our all-in-one PDF editor, converter, OCR tool, and more. It's powerful, affordable, and easy to use. Try PDF Pro for Free.

  1. In PDF Pro, Open the PDF that you want to convert.
  2. Press the Create tab > To Excel.
  3. Adjust settings as needed, then press Start.

Adobe Acrobat

If you pay for Adobe Acrobat DC, you can use it to convert PDFs to Excel. Please note: this method isn't available in free versions of Acrobat DC or Adobe Reader.

  1. Open your PDF in Adobe Acrobat.
  2. Press Export PDF, on the right-hand side.
  3. Select spreadsheet as the export format.
  4. Select Microsoft Excel Workbook.
  5. Press Export.
  6. Name your new Excel file, then press Save.

How to Convert PDF to Excel in Mac

Mac users have more than one option when it comes to converting PDF to Excel.

They can use Preview or Automator, that come built-in Mac OS, to copy and paste the data from a PDF to an Excel workbook for free.

For more reliable methods, Mac users will want to invest in a good PDF editor.

Preview

Preview is the built-in image and PDF viewer for Mac. You can use it to copy and paste text, data, and tables from PDF to a new Excel workbook, for free.

  1. Open the PDF in Preview.
  2. Select the data that you want to include in the Excel file, then right-click and Copy (or press [command] + [c] on your keyboard.
  3. Launch Microsoft Excel.
  4. Open a blank workbook, or an existing one.
  5. Right-click and Paste the data into Excel, or press [command] + [v] on your keyboard.
  6. Press Save to save your new Excel file, or [command] + [s] on your keyboard.

Automator

Automator is a built-in app that's used to automate repetitive tasks on Mac.

Like the Preview method, you can set up Automator to extract the data from a PDF and paste it into an Excel file.

  1. Launch Automator (Finder > Applications > Automator).
  2. In Automator, select Workflow > Choose.
  3. Select Files & Folders, on the left-hand side.
  4. Drag-and-drop Ask for Finder Items to the right-hand side.
  5. In the left-hand column, select PDFs.
  6. Then select Extract PDF Text, on the right-hand column.
  7. Press [command] + [s] on your keyboard, selecting Application as the format.
  8. Open your new Automator file, then press Run to convert the PDF to text format.
  9. Open the text file that was created, then select and Copy ([command] + [c] on your keyboard) the data you want to include in your Excel file.
  10. Launch Microsoft Excel.
  11. Open a blank workbook, or an existing one.
  12. Paste the data into Excel ([command] + [v] on your keyboard)

PDF Expert

The best way to convert PDF to Excel on Mac is by using a PDF editor.

A good PDF editor can instantly convert PDF to Excel.

For this example, we'll use PDF Expert, a PDF editor designed specifically for Mac OS. But the methods will be similar on the PDF editor of your choice.

  1. In PDF Expert, open the PDF that you want to convert to Excel.
  2. Press Export.
  3. Press to Excel.
  4. Name your new Excel document, and select a location to save it.
  5. Press Save.

How to Convert PDF to Excel on iPhone or Android

The easiest ways to convert PDF to Excel on mobile devices are by using an online converter or trusted app from the app store.

There are many apps and online converters, so it's important to choose a reputable one.

In this example we'll be using PDF Pro's PDF to Excel Converter, since it's easy to use, safe, 100% free. But the steps will be similar on the PDF tool of your choice.

1. In the browser of your choice, visit PDF Pro's PDF to Excel Converter.

PDF Pro's online PDF to Excel converter.

2. Upload the PDF that you want to convert.

PDF Pro's online PDF to Excel converter. There is a red arrow pointing to the Upload File button.

3. Follow the on-screen prompts.

PDF Pro's online PDF to Excel converter during use. Two buttons are shown, allowing you to convert to .csv or .xlsx.

4. Download your file.

PDF Pro's online PDF to Excel converter after the conversion. A message says "Your PFD file has been converted to Excel"

How to Convert Multiple PDFs to Excel (Batch Processing)

If you have a lot of PDFs that need to be converted to separate Excel files, then you'll want take advantage a PDF editor that's capable of batch processing.

For this, we recommend PDF Pro: it can convert multiple PDFs to Excel (or other formats), at the same time, in just a few clicks.

1. In PDF Pro, press File.

PDF Pro ribbon; the File button is highlighted.

2. Batch processing > Convert to Excel.

PDF Pro's batch processing menu. The Convert to Excel button is selected.

3. Press Continue.

PDF Pro's Batch Processing, Convert to Excel menu. The Continue button has a red arrow pointing at it.

4. Click Add files.

PDF Pro's batch convert to Excel dialog box. The add files button is highlighted.

5. Select and Open the PDF files that you want to convert to Excel.

6. Once you've added all the PDFs you want to convert, press Convert.

PDF Pro's batch convert to Excel dialog box. The convert button is highlighted.

Converting to Excel Just Got Easier

If you need to enter data, calculate figures, or perform further analysis, then you'll want to use convert your PDF to Excel, first.

Keep in mind, that no method is perfect, so you may have to redo some of the data, formatting, etc.

We've listed the easiest and best solutions to convert PDF to Excel, from almost any device!

If you need an online converter, check out PDF Pro's PDF to Excel converter. It's safe, easy to use, and 100% free.

If you work on convert files to and from PDF on a regular basis, then you'll want to invest in a good PDF editor.

We recommend PDF Pro: our all-in-one PDF editor, converter, OCR and security tool, made specifically for Windows.

PDF Pro is lightweight, works on most Windows computers, is powerful, and affordable.

Other things that make PDF Pro awesome:

Buy Now Try PDF Pro Free

FAQ

Here are some commonly asked questions about converting PDF to Excel that we've answered for your benefit.

How can I convert a PDF to Excel for free?

Use a free, online PDF to Excel converter like ours. Steps: Visit PDF Pro's PDF to Excel Converter > Upload PDF > Follow on-screen prompts > Press Convert to Excel > Download.

Can I open a PDF in Excel?

You can't open a PDF directly in Excel. However, you can attach it as a hyperlink in Excel, so that it will be opened when someone clicks the link.

How do I convert a PDF to Excel without losing formatting?

Convert PDF to Excel isn't perfect, so some formatting issues may occur regardless of the method you choose. For the most accurate conversion, use a PDF editor like PDF Pro that specializes in converting files to-and-from PDF.

Does Microsoft have a PDF to Excel Converter?

No, but there are PDF to Excel converters on their app store. You can also use Microsoft Office/Word to help you copy and paste data from a PDF to an Excel file.

How can I convert a PDF to Excel using Microsoft Excel?

One method is to Copy the data from the PDF, then Paste it into a blank Excel workbook.

Another method is by using Excel's data-extraction function: Click Data > Data from Picture > select the PDF you want to convert.

Both methods will most likely require you to redo the formatting and organization of the data.

How to convert PDF to Excel without software?

You can try copy-and-pasting the data from the PDF to an Excel workbook. You can also use Excel's data-extraction function: Click Data > Data from Picture > select the PDF you want to convert.

Both methods aren't perfect, so you'll likely have to redo some formatting and organization in Excel.

How to convert PDF to excel on Mac?

You can use Preview or Automator to try and copy-and-paste data from the PDF to Excel, but this only works on PDFs where you can select the text.

A more reliable method is by using a PDF editor for Mac, like PDF Expert. Steps: Open PDF Expert > open the PDF > Export > to Excel > Name your new Excel file > Save.

How to convert PDF to Excel in Mobile?

To convert a PDF to Excel on Mobile, you can either use a reputable app from the app store, or use an online PDF to Excel converter. For this example, we'll use our free, online PDF to Excel Converter.

Steps: Visit PDF Pro's PDF to Excel Converter > Upload PDF > Follow on-screen prompts > Press Convert to Excel > Download.

How to Convert PDF to Excel with Adobe Acrobat?

You'll need to pay for Adobe Acrobat, this won't work on free versions or with Adobe Reader.

Steps: Open the PDF in Adobe Acrobat > Press Export PDF > Select spreadsheet as the export format > Select Microsoft Excel Workbook > Export > Name your new Excel file > Save.

thumbnailA
Digital Marketing SpecialistArron Staradub
Arron was a Digital Marketer at PDF Pro, where he wrote helpful and engaging articles for those that that used PDFs in their daily life.

Discover PDF PRO

Working with PDF documents has never been easier

PDF Pro is a desktop software for Windows distributed by PDF Pro Software Inc. The software "PDF Pro" and the company "PDF Pro Software Inc." are in no way affiliated with Adobe. The PDF file format is an open file format published under ISO 32000-1:2008

pswrt
Enter password below to unlock PDF
Enter