Forum Discussion
Solved
CSV not parsed into columns despite Get Data delimiter set
My Excel does not parse CSV file correctly. The separator is comma (,). Even if I use the Get Data tool and set the delimiter there to be COMMA I still get everything in one column. Obviously, I want...
I found a solution.
Another function in the same menu - Text to Columns.
This one processed the comma separator correctly. Hurray.
Hi Filip,
In general connector recognizes the delimiter, plus you may change it on first step
If that doesn't work better if you attach sample file - just couple of rows will be enough where you could substitute personal information on something abstract
This exactly does not work
which puzzles me.
Thank you for response though!
which puzzles me.
Thank you for response though!
I don't think I am answering this any different but in Excel 2016 did you go to the Data tab, then select From Text/CSV?
Then just select the CSV file you want.
That's what I did (also Sergei suggested) but did not work :(
