How to Convert PDF to Excel on a Mac

Portable Document Format (PDF) files are easily created from other file types, such as Word documents and Excel spreadsheets. It’s a bit more difficult to convert the other way, but it can be done either in Microsoft Excel itself or using a free, online converter. Excel on a Mac works similarly to its Windows counterpart, but you need the Excel for Mac software, such as Excel 2008. Begin by saving the PDF file as a text file that can be imported into Excel.

...
Convert a PDF file to Excel on a Mac.

Import Data into Excel

Step

Open a PDF in Adobe Reader, which is available for free download on the Adobe website.

Step

Click “File, Save as Text.” Choose a destination folder for the file and click “Save.” This saves the PDF as a .txt file.

Step

Open Excel on your Mac.

Step

Click the “Import” button.

Step

Select the file type (text file) you want to import. Click “Import.”

Step

Navigate to the text file you just saved and select it. Click “Get Data.” This will open the “Text Import Wizard.”

Step

Follow the pages of the wizard to format your data. Choose the type of delimiter for your data (how values in the text are separated) and the column format you want for the worksheet. Select the required options in each of the three pages of the wizard, clicking “Next” to proceed.

Step

Click “Finish” when you’ve completed the wizard.

Step

Click “Existing Sheet” to import the data into the existing blank document. Click “OK.”

Step

Save the worksheet.

Convert Online

Step

Visit the website of a PDF to Excel converter (see Resources).

Step

Click “Browse” to upload a PDF document.

Step

Select the file and click “Open.”

Step

Select “XLS” as the output file type.

Step

Enter your email address and click the “Convert” button. The converted Excel file will be sent to you via email.