Forum Discussion

g_avinash's avatar
g_avinash
Copper Contributor
Jun 03, 2023
Solved

PDF to Excel

My client emailed me his bank statements in PDF format, and I've been trying to use Power Query to convert them to Excel format without success. Please help me in this matter. A Sample file is includ...
excel
office 365
  • SergeiBaklan's avatar
    SergeiBaklan
    Jul 20, 2023

    g_avinash 

    Afraid that's nothing to do with the file created such way.

rprieto55's avatar
rprieto55
Copper Contributor
Jul 10, 2024

apparently data query with pdf file does not work on a Mac, there is any third party software works on a mac? NikolinoDE 

NikolinoDE's avatar
NikolinoDE
Gold Contributor
Jul 10, 2024

rprieto55 

If you are using a Mac and the "From PDF" option in Power Query is not available, you can use third-party software specifically designed for macOS to convert PDF files to Excel. Here are some reliable third-party solutions that work on a Mac:

Third-Party Software for PDF to Excel Conversion on Mac

  1. Adobe Acrobat Pro DC
    • Features: Adobe Acrobat Pro DC is a powerful tool that allows you to convert PDF files to various formats, including Excel.
    • Steps:
      1. Open the PDF file in Adobe Acrobat Pro DC.
      2. Go to File > Export To > Spreadsheet > Microsoft Excel Workbook.
      3. Save the converted file.
  2. Able2Extract Professional
    • Features: Able2Extract is a versatile PDF conversion tool that supports converting PDFs to Excel on a Mac.
    • Steps:
      1. Download and install Able2Extract Professional for Mac.
      2. Open the PDF file in Able2Extract.
      3. Select the content you want to convert.
      4. Click on Excel to convert the selected PDF content to an Excel file.
  3. PDF2XL
    • Features: PDF2XL is another dedicated tool for converting PDF files to Excel, offering a user-friendly interface and accurate conversions.
    • Steps:
      1. Download and install PDF2XL on your Mac.
      2. Open the PDF file in PDF2XL.
      3. Configure the conversion settings as needed.
      4. Export the PDF to an Excel file.
  4. Online PDF to Excel Converters
    • Table2XL:
      • Features: A straightforward online tool for converting PDF tables to Excel.
      • Steps:
        1. Visit the Table2XL website.
        2. Upload your PDF file.
        3. Download the converted Excel file.
    • ReceiptsAI:
      • Features: Specifically designed for converting bank statements and similar documents.
      • Steps:
        1. Visit the ReceiptsAI website.
        2. Upload your PDF file.
        3. Download the converted Excel file.
    • Adobe Acrobat Online Tools:
      • Features: Adobe’s online tool for converting PDFs to Excel.
      • Steps:
        1. Visit Adobe Acrobat Online Tools.
        2. Upload your PDF file.
        3. Download the converted Excel file.

Steps to Import the Converted Excel File into Power Query on Mac

  1. Open Excel:
    • Launch Excel on your Mac.
  2. Import the Excel File:
    • Go to the Data tab.
    • Select Get Data.
    • Choose From Workbook and locate the Excel file you converted.
  3. Transform Data Using Power Query:
    • Once the file is imported, you can use Power Query to further process and transform the data as needed.

Summary

While macOS does not support the "From PDF" option in Power Query, you can use third-party software like Adobe Acrobat Pro DC, Able2Extract Professional, PDF2XL, or online converters to convert your PDF files to Excel. Once converted, you can easily import and manipulate the data in Excel using Power Query. These tools provide reliable alternatives to achieve the desired results on a Mac. The text and steps were edited with the help of AI.

Resources