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?