1) The lastest version Numbers I am aware of is 3.1
2) I cannot confirm your finding. Here is what I did:
I created a text file:
then saved as "CVSTest.cvs"
Then opened in Numebrs 3.1
Can you post a snippet of the offending file and how it looks in Numbers?
Since my problem is also related to csv, I post it here. I have Numbers 3.1. WIth Numbers 2.x, I could drag and drop a csv file on a soreadsheet and get a good result. Now, not only drag and drop is impossible, but when I try to open it, the all the columns are gathered into only one :
Here is a sample of the csv file :
Group: aLaFolie,UUID: dc0e4843-8d06-487a-cef7-27d885bc8b85,Ttl members: 1287,
Trilby Minotaur,e3bedd95-3962-4de2-a19c-f09cb0105df3,Alafolie VIP,02/02/2014
Shammuramat Resident,f44e702f-7e49-4a93-aa6f-5fefa80faff6,Alafolie VIP,13/01/2014
Bailey001 Resident,b57cb820-cf44-4fb2-a40f-e16b54c32663,Alafolie VIP,02/02/2014
Alba Faith,f512186b-968f-4a20-9bc5-d72614590e65,Alafolie VIP,28/03/2013
Pinky Melnik,e2f23291-2678-4cf1-9539-7a65f6b39f2e,Alafolie VIP,03/02/2014
Karma Farella,5f2a7a1b-0935-4c5f-9eb3-35adf247678a,Alafolie VIP,14/12/2013
Should it be reported as a bug ?
The Drag/Drop feature was removed in 3.0. Not a bug, just a removed feature. Ask them to bring it back.
From your description of what happens when you open a CSV file, I have two ideas of what might be the problem:
- Your CSV file has a TXT extension, not CSV. What you showed is how Numbers imports text files.
- Your localization uses semicolons, not comma, in "CSV" files
To get around Numbers 3 CSV import problems, I import CSVs into Numbers 2.3 then copy/paste the result to Numbers 3.0. Pitiful, yes, but that's what I have to do.
Indeed it is a pity: to avoid the detour (suggested by Badunit) I continue to use Numbers 2.3 instead of the new Numbers 3.1, which is also much more slowly in my hands. It is very strange that drag-and-drop CSV-files is no longer possible in Numbers 3.1. Another possibility is returning to "good old Excel"...
There is a convenient solution in the thread with the links below.
For the problem where you end up with text in one column:
For the situation where you want to bring a csv file into Numbers:
As a script you can put in your menu:
As a service:
(so you can select csv file in Finder, right-click, and choose from the contextual menu.)
All of these just require a click to run a script, click once in a cell in an existing Numbers table, and command-v paste. That's it.