+ Reply to Thread
Results 1 to 13 of 13

Simple PDF won't convert in Excel

  1. #1
    Forum Contributor
    Join Date
    10-05-2021
    Location
    Bronx, NY USA
    MS-Off Ver
    2021/365
    Posts
    126

    Simple PDF won't convert in Excel

    Why is the attached PDF, a payment history from a utility company, not converting into Excel?

    I've gone through the steps of get data, from file, and selected PDF, but when it goes through the process no information is brought in there.

    This seems like a typical PDF that any Excel user would want to work with to get and analyze the payment history.
    Last edited by Waverly; 07-12-2023 at 05:48 AM.

  2. #2
    Registered User
    Join Date
    07-09-2022
    Location
    Liberia
    MS-Off Ver
    2016
    Posts
    4

    Re: Simple PDF won?t convert in Excel

    Hi Waverly,

    Hope you are doing good.

    Did you try to tag it? May be it will work.

    Regards.

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,895

    Re: Simple PDF won?t convert in Excel

    I am guessing that the original format in the PDF was never set up as a table. When I attempt to upload the PDF with Power Query, I get the response that the file is empty.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  4. #4
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    Australia
    MS-Off Ver
    365 V2403 and WPS V2022
    Posts
    3,439

    Re: Simple PDF won?t convert in Excel

    Nothing is 100% the same

  5. #5
    Forum Contributor
    Join Date
    10-05-2021
    Location
    Bronx, NY USA
    MS-Off Ver
    2021/365
    Posts
    126

    Re: Simple PDF won't convert in Excel

    So...I guess this is an example of how Excel's ability to convert and read PDF's is not 100%!!

  6. #6
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    Australia
    MS-Off Ver
    365 V2403 and WPS V2022
    Posts
    3,439

    Re: Simple PDF won't convert in Excel

    Hi Waverly Attachment looks like a PDF of a photo archive

    Even if the read data is empty, Convert to EXCEL file with 3rd party software
    Last edited by wk9128; 07-13-2023 at 06:41 PM.

  7. #7
    Forum Contributor
    Join Date
    10-05-2021
    Location
    Bronx, NY USA
    MS-Off Ver
    2021/365
    Posts
    126

    Re: Simple PDF won't convert in Excel

    It was a printout from the utility company's website of the user's history.

    It was saved or printed to a PDF and then sent to me.

    I thought so long as it was in a PDF, then Excel could read and convert it, but I guess that ain't the case.

  8. #8
    Forum Contributor
    Join Date
    10-05-2021
    Location
    Bronx, NY USA
    MS-Off Ver
    2021/365
    Posts
    126

    Re: Simple PDF won't convert in Excel

    And, not wanting to beat a "dead horse", but it seems inexplicable that this new feature of Excel: converting PDF to Excel ain't working all that great!

    Again, I'm faced with the situation of a simple PDF of 14 transaction lines (of a scan from adding machine tape) that need further analysis, and so it would make sense to take the PDF as a starting point and converted into Excel, let me add a date column and do more analysis.

    But, as in this previous situation the PDF is not reading into Excel.

    Can anybody from the Group shed some light as to why the simple PDFs are not easily converting into Excel?

    There is nothing complicated about the PDFs that would prevent them from being properly interpreted by Excel.

  9. #9
    Valued Forum Contributor Haluk's Avatar
    Join Date
    02-14-2019
    Location
    Turkiye
    MS-Off Ver
    2010 - 64 Bit on Windows-11 (22 H2) 64 Bit
    Posts
    1,150

    Re: Simple PDF won't convert in Excel

    My Excel version does not have this feature so, i used Google Docs to transform your "scanned" image to a human readable format.

    But, it seems that the OCR process is not good as expected for your PDF files.

    Both of the transformed files are attached....

  10. #10
    Forum Contributor
    Join Date
    10-05-2021
    Location
    Bronx, NY USA
    MS-Off Ver
    2021/365
    Posts
    126

    Re: Simple PDF won't convert in Excel

    I appreciate you chiming in on this topic.

    Question still stands why Excel's built-in feature doesn't work; why should we have to consider a 3rd party app?!

  11. #11
    Valued Forum Contributor Haluk's Avatar
    Join Date
    02-14-2019
    Location
    Turkiye
    MS-Off Ver
    2010 - 64 Bit on Windows-11 (22 H2) 64 Bit
    Posts
    1,150

    Re: Simple PDF won't convert in Excel

    According to my opinion, this feature requires the PDF file to have "real text", not "images of characters".

    .

  12. #12
    Forum Contributor
    Join Date
    10-05-2021
    Location
    Bronx, NY USA
    MS-Off Ver
    2021/365
    Posts
    126

    Re: Simple PDF won't convert in Excel

    And whilst that might be true, Adobe Acrobat has the ability to OCR a PDF so that the text is readable.

    i believe I OCR'd the PDF that was originally uploaded with this post.

    If one wanted to copy & past each line from the PDF, then that's doable.

  13. #13
    Forum Contributor
    Join Date
    10-05-2021
    Location
    Bronx, NY USA
    MS-Off Ver
    2021/365
    Posts
    126

    Re: Simple PDF won't convert in Excel

    And yet another example of a PDF not converting to Excel.

    Nothing complicated, just wanted to analyze the receipt to find how much 3 cases of bottled water cost.

    Why is the converting from PDF to Excel just not working!!??
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Simple Excel formula to convert number to words in Indian style.
    By HMVYAS in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 01-03-2022, 03:14 AM
  2. Convert Excel formulas containing functions to a simple form
    By syedalisajjad in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-11-2014, 11:39 AM
  3. Replies: 0
    Last Post: 12-15-2011, 12:51 AM
  4. How to convert XXh XXm XXs into simple number?
    By jenli17 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-15-2009, 08:36 AM
  5. Replies: 1
    Last Post: 01-04-2005, 02:57 PM
  6. Replies: 1
    Last Post: 01-03-2005, 11:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1