+ Reply to Thread
Results 1 to 3 of 3

Excel Power Query - Can it do what I need?

  1. #1
    Registered User
    Join Date
    03-28-2011
    Location
    Victoria, Canada
    MS-Off Ver
    Excel 2010
    Posts
    13

    Excel Power Query - Can it do what I need?

    Hi,

    I am tasked with converting 100's of PDF pages from many files to Excel and creating a single database.

    Can anyone tell me if Excel Power Query can help improve this process for me?

    Attached is an example of what I am doing. The process is slow and exposed to error.

    Step No.1 => Sheet No.1 => I first convert each PDF file and this is the result.
    (NB: A converted PDF file will have multiple pages converted to multiple sheets in Excel).

    Step No.2 => Sheet No.2 => I use a combination of formulas and manual operations to normalize the data.
    (I do this to every sheet generated by the PDF to Excel conversion program).

    Step No.3 => Sheet No.3 => I create a Table for each sheet and then use Power Query to remove any empty rows and return a finished table.
    (NB: The attached shows only a single sheet example. Each PDF conversion will normally have many sheets, therefore I also use
    Power Query to "Append" all the sheets (tables) into one. Later I append the table(s) returned from Power Query into one large table.

    Step No.2 is the issue and I am interested to learn (determine) if Power Query can do the work I am doing manually and with formulas.

    This project is my first introduction into Power Query. Everything I have learned so far (from online) does not provide examples similar to my situation.
    Power Query seems very powerful and I am willing to learn how to use it. My concern is that for this task it cannot do what I need and I am thus no
    further ahead.

    Regards,

    Spiros
    Attached Files Attached Files

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,267

    Re: Excel Power Query - Can it do what I need?

    Hi Spiros,

    I don't think Power Query will convert PDF files itself. You will need to use another package to do the first step. I like Foxit products for this. Then I think most of the other stuff is doable.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    03-28-2011
    Location
    Victoria, Canada
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: Excel Power Query - Can it do what I need?

    Quote Originally Posted by MarvinP View Post
    Hi Spiros,

    I don't think Power Query will convert PDF files itself. You will need to use another package to do the first step. I like Foxit products for this. Then I think most of the other stuff is doable.
    Thanks for the reply MarvinP.

    I have not been completely clear... Surprise!

    I have and use "PDF Converter Professional 5" to convert files to PDF (Step No.1) in my explanation above.

    Step No.2 cleaning up and normalizing the data is the real issue.

+ 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. [SOLVED] power query
    By juanda92 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-12-2016, 08:56 AM
  2. [SOLVED] Is there a way to add a normal excel formula to a Power Query Table
    By beaglesBuddy in forum Excel General
    Replies: 1
    Last Post: 07-09-2016, 04:30 PM
  3. Exporting Facebook group comments to Excel using Power Query?
    By trapperjohn22 in forum Excel General
    Replies: 2
    Last Post: 02-27-2016, 04:12 AM
  4. Excel Crash when trying to use Power Query
    By Bikashmittle in forum Office 365
    Replies: 2
    Last Post: 02-03-2016, 11:22 AM
  5. automate power query update from new tab (office excel 2016)
    By ajnuna in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-18-2016, 07:27 AM
  6. Replies: 2
    Last Post: 07-19-2015, 06:04 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