Forum Discussion
How Can I convert this PDF File into Excel?
Hi evonneflood1 ,
According to your description, converting pdf files to excel format the method you mentioned is indeed a viable path. But because the data in your pdf file is not displayed in a uniform format, you'd better clean the data after importing it into excel. You can use m code to go through this process. Of course you can also go through the power query in some of the buttons to achieve. In short, excel provides a conversion button, but still need you to complete the process of data cleaning.
You can refer to the following documents to get more steps.How to Convert PDF to Excel using Excel Power Query - Data Cycle Analytics
How to Import PDF Files into Excel with Power Query - Excel Campus
Best regards,
Albert HeIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly
With pdfs, the key is to make sure that you have the table column sorted descending by the number of columns. This is the only way that you will keep all columns, and their order, when you combine the tables.
When you have your tables in a column, add a column using Table.ColumnCount([TableColumn]), and then sort that column descending. This will solve a lot of you issues with transforming pdfs.
--Nate