Forum Discussion
CSV not parsed into columns despite Get Data delimiter set
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.
Filip, good to know you found the way. However, in general it could be interesting to understand why Get Data doesn't work. Perhaps some special non-printable symbols at the beginning of the file which Text to Columns definitely ignores, perhaps something else.
SergeiBaklan i have my regional setting set to comma but when i open a cvs file it wont sparce into columns...i can do the text to columns to solve this but then when i save as csv comma delimited it saves with semicolon delimeter..what sould be wrong? thanks
I had a similar problem ans solved it with the text to columns command in the data tab. then I notices that some rows ha less columns other had more than others even though they are supposed to be the same length. I traced back the problem to when i first imported the data, apparently when importing the data the lines of my file were cut short in excel, like that there is some king of cap for how long the line can be when importing data. Do you know any fixes for this?
- Hi, thanks. Yes this solved the problem. Thanks for your anwser.
hi, I have a very similar problem. We run Office 365 in our office on Win10.
When I import the file using Get Data TXT/CSV on my computer the data is immediately parsed in columns.
When my colleague does it ! No chance, doesn't matter which separator we use, the data definitely stays in only one column!
This can not be a problem linked to the file as I can import it properly.
Do you have an idea Sergei?
I had a similar problem but as Scott said earlier you can import it all in one column, then use the text to columns command in the data tab in excel. It's in the data tab on a little to the right of the middle. try that
