How to Move Data from PDF to Excel

Getting valuable data stuck inside a PDF feels a lot like finding it locked in a digital safe. You can see the numbers, but you can't sort, filter, or analyze them. This article will show you several practical methods for moving data from a PDF file into a usable Excel spreadsheet, from a simple copy-and-paste to more powerful, built-in Excel tools.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Is Getting Data Out of a PDF So Hard?

Before we jump into the solutions, it helps to understand the problem. PDFs (Portable Document Format) were designed to be digital equivalents of paper. Their primary goal is to preserve a document's layout and formatting, ensuring it looks the same no matter what device or software you use to view it. They are great for sharing reports, invoices, and forms, but they were never intended for data editing or analysis.

When you try to copy a table from a PDF, you might run into common frustrations:

• All the data gets pasted into a single column in Excel.
• Numbers are incorrectly formatted as text.
• Columns get merged together or split in the wrong places.
• Rows with multiple lines of text break into separate rows.

This is because the PDF doesn't store data in a structured way like a spreadsheet. It just stores text and lines in specific positions on a page. The good news is, there are several ways to work around these challenges.

Method 1: The Simple Copy and Paste (The "Let's See If This Works" Approach)

For clean, simple, text-based PDFs, a direct copy-and-paste might be all you need. It's the quickest method and should always be your first attempt before moving on to more complex solutions.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step-by-Step Instructions:

1. Open your PDF in Adobe Reader, your web browser, or another PDF-viewing application.
2. Select the data you want to move. Click and drag your cursor over the entire table. Some PDF readers have a "select table" feature that can make this easier.
3. Right-click on the selected area and choose Copy (or use the shortcut Ctrl+C or Command+C).
4. Open a new or existing worksheet in Microsoft Excel.
5. Click on a single cell where you want the data to start.
6. Right-click and Paste the data (or use the shortcut Ctrl+V or Command+V).

In a best-case scenario, Excel will recognize the tabular structure and paste the data neatly into rows and columns. More often, however, you'll need to do some cleanup.

Troubleshooting the Copy-Paste Method

Did all your data end up in Column A? This is a common issue. You can often fix it using Excel’s Text to Columns feature.

Step-by-step:

1. Select the column containing your pasted data.
2. Go to the Data tab on the Excel ribbon.
3. Click on Text to Columns.
4. In the wizard that pops up, choose Delimited and click Next.
5. Check the box next to the delimiter that separates your data. Usually, this will be Tab and/or Space. You'll see a preview of how the data will be split.
6. Click Finish. Your data should now be separated into proper columns.

Method 2: Using Power Query in Excel (The Most Powerful Built-In Method)

If the copy-paste method fails or your table is more complex, Excel's own data tool, Power Query, is your best bet. It’s built into modern versions of Excel (Excel 2016 and later) and is designed specifically to import and transform data from various sources, including PDFs.

This is often the most reliable method for getting properly formatted tables from a PDF directly into your workbook.

Step-by-Step Instructions:

1. In Excel, click on the Data tab.
2. In the "Get & Transform Data" group, click Get Data > From File > From PDF.
3. A file browser window will open. Navigate to your PDF file, select it, and click Import.
4. Excel will analyze the PDF and a new window called the Navigator will appear. This window shows you all the tables and pages that Power Query has detected in the document.
5. Click on each table name in the list on the left to see a preview on the right. Find the one you need.
6. Once you've selected the correct table, you have two options:

Using Power Query is the recommended method for regular, repeatable tasks. Once you set up the connection, you can simply go to Data > Refresh All to pull the data again if the PDF file gets updated.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Method 3: Using Microsoft Word as a Go-Between

Sometimes, the structure of a PDF is just too messy for a direct import into Excel. In these cases, you can use Microsoft Word as a surprisingly effective intermediary tool. Word has a solid PDF conversion feature that can often preserve table structures better than a simple copy-paste.

Step-by-Step Instructions:

1. Open Microsoft Word.
2. Go to File > Open.
3. Browse to and select your PDF file. Word will display a message telling you it will convert your PDF into an editable Word document. Click OK.
4. The conversion may take a moment. Once it's done, your PDF will appear as a Word document. The formatting might not be perfect, but the table structure is often intact.
5. Navigate to the table within the Word document.
6. Select the entire table. You can do this by hovering your mouse over it and clicking the small crosshairs icon that appears in the top-left corner.
7. Copy the table (Ctrl+C).
8. Switch over to Excel and Paste it (Ctrl+V).

This method often yields much cleaner results than a direct copy from PDF to Excel because Word’s conversion engine is designed to recognize and rebuild elements like tables.

Method 4: Dealing with Scanned or Image-Based PDFs (Using OCR)

What if your PDF is just an image? This often happens with scanned documents. You can't select the text because, to your computer, it's just a picture. The solution here is a technology called Optical Character Recognition (OCR), which converts text within an image into editable machine-readable text.

Here are a few ways to use OCR to get your data into Excel:

Option 1: Adobe Acrobat Pro

If you have the paid version of Adobe Acrobat, it has a built-in OCR feature. You can open your scanned PDF, let Acrobat recognize the text, and then use its "Export to..." feature to save the file as an Excel workbook. It's often the most accurate professional-grade tool for this job.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Option 2: Excel's "Data from Picture" Feature

Yes, Excel can perform OCR too! This is a fantastic and often overlooked feature available in newer versions of Excel and the Microsoft 365 app.

Steps:

1. Take a screenshot of the table in your image-based PDF and save it as a picture file (PNG or JPG). Alternatively, keep the PDF open.
2. In Excel, go to the Data tab.
3. Click From Picture > Picture From File (if you saved it) or Picture From Clipboard (if you copied it).
4. Excel will analyze the image and display the data it recognized in a side pane. It will highlight any values it's unsure about.
5. You can click on each highlighted cell to review and accept the suggestions.
6. Once you are satisfied, click Insert Data.

The accuracy depends on the quality of the image, but it can be a huge time-saver for scanned reports.

Option 3: Online PDF Converter Tools

There are many free online tools (like Smallpdf, iLovePDF, etc.) that can convert PDFs to Excel. Most of these also have OCR capabilities for scanned documents. While they are convenient for quick, one-off tasks, be cautious about uploading sensitive or confidential information to a third-party website.

Final Thoughts

Dealing with data stuck in PDFs is a common but solvable problem. What starts simple with a copy and paste can escalate to using powerful built-in tools like Power Query or OCR technology. Once your data is unlocked and in Excel, you can finally filter, analyze, chart, and get the insights you need to make better decisions.

The frustration of manual data wrangling isn't just limited to PDFs, it's a daily grind for anyone who relies on data from platforms like Google Analytics, Shopify, Salesforce, or Facebook Ads. Manually exporting CSVs and stitching them together is just as tedious. At Graphed, we automate all that reporting drudgery. Simply connect your sources, and you can build live, auto-updating dashboards with simple natural language - no more manual reports, ever. This lets you get back to acting on insights instead of just spending all your time trying to find them.