Excel for Mac - How to Import a PDF (Including BONUS Tip: Translating a PDF!) - all for FREE!

Поділитися
Вставка
  • Опубліковано 29 жов 2024

КОМЕНТАРІ • 25

  • @AnyiG_
    @AnyiG_ Місяць тому +1

    I was ready to cry and you saved my night

  • @jacquelynloyd
    @jacquelynloyd 4 місяці тому +2

    Thank you SO MUCH for this video! You saved me hours and hours of time. For anyone else finding this and reading the comments, if you have a large/dense table you're importing, make sure you make the PDF you're taking a screenshot from large on your screen before you take the screenshot. My first attempt resulted in MANY errors, but when I made the viewer bigger before taking the screenshot, Excel was able to read the image accurately. Thank you Mike!

  • @DrGaryMBrownstein
    @DrGaryMBrownstein 3 місяці тому

    Thank you! I spent a long time trying to get the "cure". This video is superb

  • @AshwinMisra
    @AshwinMisra 18 днів тому +1

    Hi. Thanks for this video. Though I dont see the option to add data from picture in my Excel on Macbook.

    • @MikeThomas67
      @MikeThomas67  17 днів тому

      @AshwinMisra what version of Excel do you have? This feature is available to Office 365 subscribers on version 16.38 or greater

  • @TangiwaiKoopu
    @TangiwaiKoopu 11 місяців тому

    Thank you! You have the one video that actually helped me!

    • @MikeThomas67
      @MikeThomas67  10 місяців тому

      @user-ob8us4pe4i Glad I could help!

  • @samsun007
    @samsun007 Рік тому

    Thanks, Mike - this is a great video. Really simple and helpful - well done!

  • @ignatiusliebenberg3808
    @ignatiusliebenberg3808 Рік тому

    Thanks Mike, the best clip I watched on this topic.

  • @buaykeetan2605
    @buaykeetan2605 Рік тому +1

    thank you Mike for this useful video

  • @pandamonium9834
    @pandamonium9834 2 роки тому +1

    Hi mike didn’t know this could be done so thanks for that!

  • @HnnBz
    @HnnBz 4 місяці тому

    This has limitations (e.g., with multipage docs), so an easier way - depending on how original doc is formatted - is to open pdf in Acrobat Pro (or whatever naming convention Adobe is using today - the expensive version), and use the Save as... to Excel. That generates the xlsx file, which can be opened in Apple's Numbers. Alternatively, if you are doing bulk conversions, you can use Ruby or Python scripting with a util like PDF::Reader to convert to text, treat that as a tsv file, and use regex to extract the data. But generally Acrobat works just fine.

    • @MikeThomas67
      @MikeThomas67  4 місяці тому

      @HnnBz You are right with the limitations but 1) I don't think an average non-technical Excel user would want to get involved with a Ruby/Python/Regex based solution and 2) have you seen the price of Acrobat Pro!! Nonetheless, thanks for the feedback :-)

  • @maribelbarcelona3074
    @maribelbarcelona3074 11 місяців тому +1

    Thank you so much 😊

  • @rajshah7170
    @rajshah7170 Рік тому +2

    Hi Mike - Great video - Thank you. Its a shame Office 365 for Mac does not have import from PDF option. If my pdf is longer than a screen full, how do I select all the area of the pdf to import to excel ? Any advice gratefully received.CMND+Shift+4 would not extend below the visible screen area.

    • @Peterlusg
      @Peterlusg Рік тому

      Does it mean that it is impossible to embed PDF into excel on MacBook?

    • @MikeThomas67
      @MikeThomas67  Рік тому

      @@Peterlusg You can only insert a PDF into Excel for Mac as an image. Either drag the PDF and drop it into a workbook Excel or use Insert>Pictures to import PDF as image to your Excel file. Whichever method you use, it will only import the first page of the PDF 😞

  • @peterpayne2219
    @peterpayne2219 Місяць тому +1

    The 2019 version of Excel for Mac does not have the Import Data From Picture option. So we have to find some other way...

    • @MikeThomas67
      @MikeThomas67  Місяць тому

      Yep it's not supported I'm afraid

  • @steveblack8410
    @steveblack8410 Рік тому

    Hi Mike I tried to do this but my three columns of data keeps importing into one cell. I cant get it to go into individual cells. Im using office home and business 2021. Do you know how to stop this. TIA

    • @MikeThomas67
      @MikeThomas67  Рік тому

      Hi @steveblack8410 I have no idea off the top of my head. If you drop me a mail via theexceltrainer.co.uk/contact I'm happy to open a dialog with you

  • @sirseacow4462
    @sirseacow4462 Рік тому

    I don't have the data from picture option in Excel

    • @MikeThomas67
      @MikeThomas67  Рік тому

      @sir seacow This feature is available to Office 365 subscribers on version 16.38 or greater.