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?
Best Answer
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.