Troubleshooting CSV Import Issues with Delimiters in Excel

I'm trying to do a simple import CSV to a new workbook/table. Maybe i never noticed before, btu no matter whether i do delimiter chose of comma, colon, pipe or tab its not working right. my headers are off and the info is merging into columns together. its a normal csv file that i exported from google sheet.