Forum Discussion

Ozkan0075's avatar
Ozkan0075
Copper Contributor
Sep 03, 2022

Transfer tables from PDF to excel.

Hello, I am using Excel on Mac. There is no PDF file option in the Data-Get Data option to export the table from the PDF file to excelI. I will be glad if you can help.

 

Excel on Mac
  • JimGMac's avatar
    JimGMac
    MVP
    Sep 03, 2022
    You should be able to copy tables from your PDF and paste them into an Excel workbook. You might also take a screen shot and then use Excel's Data From Picture feature.
  • Harun24HR's avatar
    Harun24HR
    Bronze Contributor
    Sep 03, 2022

    Ozkan0075 Follow the below screenshot. From Data tab-->Get Data-->From File-->From PDF.

    It depends on version of Excel. You may need adobe license to get data from PDF file.

     

     

Resources