CSV file opens as one cell? Help!

Are you doing File > Open or trying to paste the CSV data into Numbers?

Pasting tab-separated data works in Numbers 3.1, as does opening csv files. But not pasting CSV data.

Assuming the CSV data is well formed you should be able to parse out to different columns by using this script (Dropbox download).

Open the script in AppleScript Editor, select the cells in the column you need to split into columns, hit run, and then single-click the top-left cell of the range where you want to paste the values, and command-v to paste.

If you are doing a lot of importing of CSV into Numbers, post here and I'll find the link to a self-installing Automator Service that will allow you to right-click a csv file in Finder, then paste the results into Numbers.

SG

My first guess is your CSV file has a TXT extension, not CSV. If so, Numbers will treat it like a text file, not a CSV file. Change the file extension to CSV then open it with Numbers.