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 He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly