How to open CSV file with numbers

Hello

I guess your decimal separator is comma, in which case Numbers arbitrarily assumes field separator in CSV is semi-colon.

In order to let Numbers accept comma-separated CSV data, you need to temporarily change your system's number format in System Preferences.app - namely:

1) Quit Numebrs.app;

2) In System Preferenecs.app, set decimal separator to period;

3) Launch Numbers.app, import the CSV data, save the imported file and quit Numbers.app;

4) In System Preferenecs.app, restore decimal separator to comma;

5) Launch Numbers.app and open the file saved in 3).

Good luck,

H

PGiacomo wrote:

the app doesn't recognizes the commas as separators so it visualize all the values in the same cell.

What is the way to do recognize the commas as separators?

If, each time you do this, you don't want to mess with changing System Preferences and then changing them back, and instead want to accomplish the task with a click or two, then you can use this Text to Columns Automator Service (Dropbox download).

One-time installation: doubleclick the downloaded .workflow package and, if necessary, "Open Anyway" in System Preferences > Security & Privacy.

Thereafter to use:

1. Select the cells in the column where the values are located that you need to split across columns.
2. Choose Text to Columns from your Numbers > Services menu.
3. Answer the prompts to choose a delimiter (separator).
4. Click once in the top-left destination cell (I usually choose the top of the column immediately to the right of the selection).
5. Command-v to paste.

That's it. This is similar to the 'Text to Columns' wizard in Excel.

SG