Forum Discussion

Prate3ksharma's avatar
Prate3ksharma
Copper Contributor
Nov 25, 2024

Converting PDF to Excel 2024 on Mac (Not O365)

Hello Guys,

Looking for advice on converting a PDF to Excel on my Mac. I'm using Excel 2024 and not Office 365. Most of the solutions I've come across online seem to cater to Office 365 users.

I need to convert PDF content into Excel format so that I can work with the content. Does anyone have suggestions with a step by step approach how to do so. If there is any macro available or any step which doesn't involve the use of third party tool I'm fine.

Appreciate your help!

BI & Data Analysis
excel
Excel on Mac
Formulas and Functions
Macros and VBA
office 365

1 Reply

Sort By
  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    Nov 27, 2024

    Converting a PDF to Excel on a Mac without relying on third-party tools is somewhat limited in functionality. Excel 2024 doesn't include a built-in feature for importing or converting PDFs directly. However, you can explore the following built-in and workaround solutions, or if you're open to using third-party tools, some reliable options exist. I'll try outline both approaches:

     

    Built-In Approach Using Preview and Excel (No Third-Party Tools)

    Step 1: Open the PDF in Preview

    1. Right-click the PDF file and select Open With > Preview.
    2. Highlight the text you want to extract using the mouse.

    Step 2: Copy and Paste to a Plain Text Editor

    1. Copy the selected text (Command + C).
    2. Paste the text into a plain text editor, such as TextEdit (set it to plain text format: Format > Make Plain Text).
    3. Save the file as a .txt file.

    Step 3: Import the Text File into Excel

    1. Open Excel 2024.
    2. Go to File > Open and select the .txt file.
    3. Excel will launch the Text Import Wizard:
      • Choose Delimited if the data is separated by tabs or commas.
      • Define the delimiters (e.g., Tab, Comma) based on how the data is structured.
    4. Finish the wizard, and the data will appear in an Excel sheet.

    Step 4: Clean Up the Data

    Organize and format the data to match your needs.

     

    Using Free Online PDF-to-Excel Tools

    If you're open to using an online service for one-time conversions, these tools are effective:

    1. Small PDF (www.small pdf. com/pdf-to-excel)
    2. i Love PDF (www.i love pdf. com/pdf_to_excel) 

      Remove spaces

    Steps:

    1. Upload the PDF.
    2. Convert it to Excel format.
    3. Download and open it in Excel 2024.
    • For more complex tables, third-party tools like Adobe Acrobat Pro DC or online converters are recommended as they handle tabular data much more effectively.

    The text was created with the help of AI.

     

    My answers are voluntary and without guarantee!

     

    Hope this will help you.

     

    Was the answer useful? Mark as best response and like it!

    This will help all forum participants.

Resources