Data format needed for power bi - data clean up

[JSH720]

Newbie here

What format does my excel spreadsheet need to be in to use BI? I think it needs to be in a table with one row being a record? No multi data cells?
I have a as set up as a report. Trying to make it more useful and ultimately append it to spreadsheets from other sources. Fist step first though

Thank you

 

[ExcelToDAX]

It doesn't have to be a table nor does it need one row being a record. By multi data cells, do you mean multiple columns split by a delimiter? You can have any format in your Excel file.

 

[JSH720]

by multi data I mean for example multiple names in one cell in a row. I think I need to split out each name in a different row so I can do queries and such. Making each row unique dataset. Correct?
This is composed of text. A summery of properties etc. quite large. Any numbers were calculated separately and manually inputted ( I have no idea why).

Thanks!