How to gracefully import CSV files into Numbers.app v3?

I have a process, which has worked faithfully for years in Numbers '09, whereby I download my Bank account data in CSV format, then drag that data directly into my Numbers sheet (after creating an appropriate number of blank rows).

This no longer works, and I can't find an option to import csv! A help search within numbers for 'csv' returns a single result which describes exporting.

I've tried the old method, no dice. Also, the menu option: Insert > Choose… doesn't permit .csv to be selected.

At the moment, my workaround is:

• drag the CSV onto the Numbers dock or task-switcher icon to create a temp sheet
• select and copy the content
• paste-and-match-format into my desired location
• close don't save the temp file

Doe anyone know a better way? A hack or hidden flag I can toggle to get the old functionality back?

Solution 1:

So the Apple thread recommended changing the txt to csv. This didn't work, my file was already csv, properly formated etc. No, changing to txt did the trick.
I'm finding it harder and harder to recommend switching from Microsoft to Apple. This sort thing just shouldn't be happening.

Solution 2:

I have faced a similar problem: after exporting a csv file from MySQL I tried to open directly into Numbers but it did not open correctly so I tried to drag the file onto an open sheet and it also and did not work.

Then I read lot of things on Internet about how Numbers deals with comma, so I exported the data once again switching comma (,) for semicolon (;) and voilà!

Solution 3:

Simple solution for getting a csv file to open correctly on a Mac. Change the csv file extension to txt. Then right click on it and open with Numbers.

Solution 4:

Dragging and dropping a CSV onto a table works again since v3.2!

Currently in v6, I find that I can drag data onto an existing table, but it will overwrite the table's contents.

To preserve existing rows:

• select the file in Finder and Copy
• select the target cell in your target table (usually the last row in column A)
• Paste

When selecting the target cell, you may want to hit Escape to ensure you're not in edit mode.