Importing notepad data to excel difficult split

Question

I want to transfer this data from notepad to excel and split it into columns but the problem is that the data (i didn't make this) doesnt split on a delimiter. All the data looks like variations of the following this

Header: "a" "b" "c" "d" "e" ... "n"
rows:   "1" "sgvgs-dvfds" "" "0.0" "d'/.d" ... "m"

Everything is contained within quotations. Does anyone know in excel on how to make it happen or even through powershell?

Answer 1

Excel: How to Use It

On the Data tab, go to "From Text/CSV."
Open the file by selecting it and double-clicking it.
Set the delimiter to Space in the resulting window, then click Load Bingo to load the OP's Excel data (and it handles empty columns properly)