Hi @AllisterB,
I fully agree with Brian, if you’re just starting out with Power BI make going through the Advanced Transformations module a top priority.
The structured format of Excel tables make getting the data in Power Query easier and prevent data loss, so always consider this.
Here’s an article, I think you will find helpful. It addresses your question and shows how to solve a potential issue that might arise…