Share via

TRANSFORM PDF TO EXCEL USING POWER QUERY

Anonymous
2024-04-21T05:00:48+00:00

I have a PDF file which is unevenly arranged. Now I am trying to convert the file to a clean excel data. As the heading are not evenly arranged, I am getting confused to change the file.

I want heading only hatt ticket number, student name, father name and mother name

PLEASE CLICK HERE FOR THE PDF FILE

Microsoft 365 and Office | Excel | For education | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-04-21T13:23:16+00:00

    I send the result to you via private message.

    Private Messages - Microsoft Community

    1. Get data from PDF.
    2. Load each page to Excel.
    3. Combine all the data in to one table
    4. remove unnecessary data.

    Was this answer helpful?

    0 comments