The fastest way depends on what your PDF looks like
If your PDF is a simple table with rows and columns, you can copy the data directly into Excel. If it's a scanned image or a complex layout, you'll need to convert it first. The method that works fastest for you depends on whether the PDF is text-based (searchable) or image-based, and whether the data is already organized in a table format.
Most PDFs fall into one of three categories: clean tables you can copy straight out, text documents that need some cleanup after pasting, and scanned images that require conversion software. Each has a different path forward, and choosing the right one saves you from hours of manual retyping.
Key Takeaways
- Text-based PDFs with table data can be copied directly into Excel by selecting the content in your PDF reader and pasting it into a spreadsheet.
- If copying doesn't preserve the table structure, use Excel's built-in "Get & Transform" feature (Windows) or "Queries" (Mac) to import the PDF as a data source.
- Scanned PDFs and image-based documents need optical character recognition (OCR) software to convert them to text before Excel can read them.
- Online conversion tools can turn PDFs into CSV or Excel files, but they work best on clean, simple tables and may require you to upload sensitive data to a third-party server.
Copying and pasting from a text-based PDF
Open your PDF in Adobe Reader, Preview (Mac), or your browser's PDF viewer. Click and drag to select the table or text you want to move into Excel. Make sure you're selecting the actual content, not just highlighting the page — you should see the text change color as you drag.
Once selected, press Ctrl+C (Windows) or Command+C (Mac) to copy. Switch to Excel, click the cell where you want the data to start, and press Ctrl+V or Command+V to paste. Excel will attempt to place each column in its own cell. If the columns don't line up correctly, you may need to use the "Text to Columns" feature to split the data properly.
This method works best when the PDF table has clear column separators — spaces, tabs, or lines between each field. If the PDF is poorly formatted or the columns run together, the pasted data will land in a single column and require manual splitting.
Using Excel's Get & Transform feature to import PDFs
On Windows, Excel has a built-in tool called "Get & Transform" (in older versions, it's called "Power Query") that can read PDF files directly. Open Excel, go to the Data tab, and look for Get Data or New Query. Select From File, then From PDF.
Navigate to your PDF file and open it. Excel will show you a preview of the tables it found in the document. Select the table you want and click Load. Excel will import the data into a new sheet, and you can then clean it up or move it where you need it.
On Mac, this feature is less direct. You can use Data > Get External Data, but PDF support is limited. Many Mac users find it faster to copy and paste, or to use an online conversion tool instead. If you work with PDFs regularly on Mac, consider using a dedicated conversion application.
Converting scanned PDFs and images with OCR
If your PDF is a scanned image or photograph of a document, copying won't work because Excel can't read images. You need optical character recognition (OCR) software to convert the image into text first.
Free options include Google Docs (upload the PDF, and Google will OCR it automatically), Microsoft OneNote (paste the image, right-click, and select "Copy Text from Picture"), or online OCR tools like ILovePDF or Smallpdf. Paid options like Adobe Acrobat Pro or ABBYY FineReader offer better accuracy, especially for handwriting or poor-quality scans.
After OCR conversion, you'll have a text-based PDF or document that you can copy into Excel using the methods above. Be aware that OCR is not perfect — numbers and special characters often get misread, so review the data carefully before relying on it for calculations or analysis.
Using online PDF-to-Excel converters
Websites like Zamzar, CloudConvert, and Smallpdf can convert PDFs directly to Excel or CSV format. Upload your PDF, select Excel as the output format, and download the converted file. These tools work quickly on simple, clean tables.
The main drawback is privacy: you're uploading your file to a third-party server, which may not be acceptable if the PDF contains confidential information, financial data, or personal details. Free versions often have file size limits or daily upload caps. Paid versions remove these restrictions but cost money for what you might accomplish with built-in tools.
Online converters are most useful when you have a one-time PDF to convert and don't want to install software. For regular work with PDFs, the built-in Excel or Google Sheets methods are usually faster and more secure.
Cleaning up data after import
No matter which method you use, imported PDF data often needs cleanup. Extra spaces, line breaks, or merged cells can cause problems. Use Excel's Find & Replace feature (Ctrl+H or Command+H) to remove unwanted characters — search for line breaks by entering "^n" in the Find field, or search for extra spaces and replace them with single spaces.
If your data imported into a single column, select that column and use Data > Text to Columns. Choose the delimiter that separates your fields (space, comma, tab, or other), and Excel will split the data across multiple columns automatically.
Check for formatting issues like numbers stored as text, which will left-align in cells instead of right-aligning. Select the column, go to Data > Text to Columns, and click through without changing settings — this often converts text numbers back to actual numbers that Excel can calculate with.
When to use each method
| PDF Type | Best Method | Why |
|---|---|---|
| Clean table, text-based | Copy and paste | Fastest for simple data; no extra steps needed |
| Complex table, text-based | Get & Transform (Windows) or online converter | Handles formatting better than copy-paste |
| Scanned image or handwriting | OCR tool first, then copy-paste | Must convert image to text before Excel can read it |
| One-time conversion, no sensitive data | Online converter | Quick and requires no software installation |
| Regular PDF imports, sensitive data | Get & Transform or local OCR software | Keeps data on your computer; faster for repeated use |
Frequently Asked Questions
Why does my copied PDF data land in one column instead of multiple columns?
The PDF doesn't have clear column separators that Excel recognizes. After pasting, select the column with all your data, go to Data > Text to Columns, and choose the character that separates your fields (space, comma, or tab). Excel will split it across columns automatically.
Can I import a PDF directly into Excel without copying or converting?
On Windows, yes — use Data > Get Data > From File > From PDF. On Mac, this feature is limited, so copy-paste or online conversion is usually faster. Google Sheets also has better native PDF support than Excel on Mac.
What's the difference between a text-based and image-based PDF?
A text-based PDF is searchable — you can use Ctrl+F to find words in it. An image-based PDF is a picture of a document and requires OCR to convert to text. Most modern PDFs are text-based unless they're scanned documents or photographs.
Is it safe to use online PDF converters with confidential data?
Online converters upload your file to their servers, which poses a privacy risk for sensitive information. For confidential data, use Excel's built-in Get & Transform feature or local OCR software instead. If you must use an online tool, check their privacy policy and choose one that deletes files immediately after conversion.
Why does Excel show my numbers as text after I import them?
PDFs sometimes format numbers as text. Select the column, go to Data > Text to Columns, and click Finish without changing any settings. This usually converts text numbers back to actual numbers that Excel can add, subtract, and calculate with.