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
SergeiBaklanHey, where is this option in MS excel ? which tab ?
- Hi, this is in Data Tab.
