How do I get rid of this formatting and just have excel data like I gyped it in?
Because it is not excel but Power Query. You can format any way you like once you bring it into native excel.