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.
I found a solution.
Another function in the same menu - Text to Columns.
This one processed the comma separator correctly. Hurray.
How to translate data from .csv from Ppl and CoinB downloads to columns and rows. Open the .csv file in Excel. Confirm it is not separated into columns. Select only the first commas separated value data and then press Data on the menu bar, then press Text to Columns. Answer questions in the dialog box selecting commas as the separator to translate it to Columns and rows.