You can create a new Numbers spreadsheet by importing a document created in _Microsoft Excel_ or AppleWorks 6. Numbers can also import files in comma-separated value (CSV) format, tab-delimited format, and Open Financial Exchange (OFX) format.
May you tell us which is the separator used in your CSV file?
Numbers is able to treats CSV files using really the comma.
Most of the time, in Europe, we use the semi-colon and Numbers is unable to import our files directly.
Try to open one of your CSV into TextEdit or Pages.
You will easily recognize the character used as delimiter.
Assuming that it is the semi-colon,
Use the Find Change tool to replace every semi-colon by a tab.
Then select all
copy to clipboard
paste into Numbers.
Yvan KOENIG (from FRANCE samedi 14 juin 2008 20:07:36)
I fixed the csv import problem by simply correcting the filename I was trying to import. When I downloaded it from my bank, the filename looked like this:
filename.csv.xls
I took off the .xls and made it:
filename.csv
It works just fine for me now. I'm not sure if this is your issue, but you may check to see if this easy fix works for you.