pdf to excel7 min read

How to Convert PDF to Excel on Mac for Free (2026 Guide)

On a Mac, the fastest free way to convert a PDF to Excel is to use PurePDF's PDF to Excel tool in Safari or Chrome, download the .xlsx file, then open it in Excel for Mac or Numbers. Check the table layout first, fix merged cells and number formats, and only use OCR for scanned PDFs.

SM
Sarah Mitchell

If you have a PDF table on your Mac and need it as a spreadsheet, you do not need to retype it or buy new software. The fastest free route is to convert the PDF to an Excel file in your browser, then open the result in Excel for Mac or Apple Numbers and clean up the formatting. This guide shows you exactly how to do that, what to check before you trust the numbers, and how to fix the problems that most often make a converted sheet look messy.

Use the PDF to Excel tool at https://www.purepdf.net/pdf-to-excel to turn your PDF table into a downloadable .xlsx file.

Before you convert: check what kind of PDF you have

Not every PDF converts the same way. A PDF created from Excel, Word, or a reporting system usually contains real text and a clear table structure, and it converts cleanly. A scanned PDF, a photo of a receipt, or a screenshot is really an image. In that case, the converter first needs to recognise the text, which is called OCR, and the result will need more checking.

Open the PDF in Preview first. Try selecting a row of numbers with your mouse. If you can select and copy the text, it is a text-based PDF and you are in good shape. If you cannot select anything, it is probably scanned. Also look for these warning signs: rotated pages, faint or skewed scans, handwriting, tiny print, and tables with no visible lines. Those do not make conversion impossible, but they do mean you should budget extra time for checking.

If your file has several tables, or a mix of tables and long paragraphs, convert one table at a time when you can. Splitting a long report into the pages that contain the table you need usually gives a cleaner spreadsheet than converting a 40-page document in one go and then hunting for the right rows.

Step by step: convert a PDF to Excel on a Mac

  1. Open Safari or Chrome on your Mac and go to the PurePDF PDF to Excel tool.
  2. Upload your PDF. Choose the file from Finder, or drag it into the upload area if your browser supports it.
  3. Start the conversion and wait for it to finish. Do not close the tab while the file is processing.
  4. Download the .xlsx file when it is ready. Save it in a clear location, such as Downloads, and give it a useful name right away, for example sales-report-2026.xlsx.
  5. Double-click the file to open it. On most Macs it will open in Excel for Mac if Excel is installed. If you do not have Excel, right-click the file, choose Open With, and select Numbers.
  6. Before you edit anything, save a copy of the converted file. That way you can always go back to the original conversion if a cleanup step goes wrong.

That is the whole conversion. The real work, and the part that saves you from errors later, is the ten-minute check that follows.

Open it in Excel for Mac or Numbers: what changes?

An .xlsx file works in both apps, but they are not identical. Excel for Mac is the safest choice if you plan to share the file with Windows users, use complex formulas, or rely on pivot tables and charts. Numbers is excellent for a quick review, simple totals, and sharing with other Apple users, but it can change some Excel-specific formatting when you export again.

If the file will be used for accounting, tax, or a shared workbook, open it in Excel, check it, and keep it as .xlsx. If you only need the numbers for yourself and prefer Numbers, you can open the .xlsx in Numbers and then save it as a Numbers file, but keep the original .xlsx as a backup. Either way, do not assume the first screen you see is final. Zoom in, scroll to the bottom of each table, and check the last row and column. Converted tables often hide a stray footer, a page number, or a totals row in an unexpected place.

Fix the five most common problems

1. Columns are merged or split in the wrong places

This is the most common issue. A column that looked like one column in the PDF may arrive as two columns, or two narrow columns may arrive as one. Select the problem area, use Format Cells to check alignment, and use Text to Columns in Excel, or the equivalent split option in Numbers, only after you have inspected a few rows by hand. If dates, amounts, and descriptions are mixed in one cell, split them carefully and check that no values move to the wrong row.

2. Numbers are stored as text

You will spot this when a total formula returns zero, or when numbers align to the left instead of the right. Select the range, change the format to Number or Currency, and use the error indicator in Excel to convert text to numbers where appropriate. Watch out for thousand separators and decimal points, especially in PDFs from other countries. A value like 1.234 can mean one thousand two hundred thirty-four in one locale and one point two three four in another.

3. Dates are in the wrong format

PDF dates often arrive as text such as 28 Oct 2026, 10/28/2026, or 2026-10-28. Select the date column, apply a consistent date format, and sort a copy of the data to check that the earliest and latest dates make sense. If Excel treats some dates as text and others as dates, convert the whole column in one step rather than fixing cells one by one.

4. Headers repeat, or the header row is missing

Converted sheets sometimes repeat the header on every page, or lose it entirely. Delete duplicate header rows, keep one clear header row at the top, and freeze the top row in Excel or Numbers so it stays visible while you scroll. Give each column a short, plain name, such as Date, Description, Amount, and Balance, rather than leaving a long PDF title in the first row.

5. Blank rows, footers, and stray characters

Remove blank rows that were page breaks, and delete footer text such as page numbers, confidentiality notes, and repeated company names. Check for currency symbols that landed in their own column, and for minus signs that became dashes. After cleanup, add a simple check: sum the amount column and compare it with the total shown in the original PDF. If they do not match, a row is missing, duplicated, or stored as text.

What about scanned PDFs?

For a scanned PDF, run OCR first or use a converter that includes it, then convert the recognised text to Excel. Expect more errors, especially with faint print, tables without borders, and handwritten notes. After conversion, compare a sample of at least ten rows against the original scan, line by line. Pay special attention to 1 and 7, 0 and O, 5 and S, and decimal points. If the table is small, it is often faster and safer to retype it than to clean up a poor OCR result. If the table is long, OCR plus a careful check is still much faster than retyping everything.

A quick checklist before you share the spreadsheet

  • The header row is clear, and there are no duplicate headers.
  • Every amount column sums to the total in the PDF.
  • Dates are in one format and sort correctly.
  • Numbers are stored as numbers, not text.
  • Blank rows, footers, and page numbers are removed.
  • You have saved the original converted file as a backup.

Follow that checklist, and a PDF table becomes a spreadsheet you can actually sort, filter, total, and share, without the usual surprise of a total that does not add up.

Frequently asked questions

Can I convert PDF to Excel on a Mac without installing software? Yes. Use a browser-based converter in Safari or Chrome, download the .xlsx file, and open it in Excel for Mac or Numbers. You do not need to install a separate PDF app for a standard table PDF.

Why are my columns messy after conversion? Usually because the PDF had merged cells, narrow columns, or no clear table borders. Fix the header row first, then split or merge columns in small sections, and always re-check the totals.

Ready to pdf to excel?

Use our free online tool to process your files securely in high quality. No sign-up required.

Open pdf to excel Tool

Continue Reading