Separate multiple comma separated values in Numbers

csvnumbers

One of the CSV files I'm using has lumped the address into one single cell, separated by commas.

For example: 12 Fairy Tale Lane, Wonderland, Oz, Neverland

I need to separate these into Address 1, Address 2, Address 3 and City columns

Best Answer

Here is a suggestion from https://discussions.apple.com/message/26532955#26532955

In order to import comma-separated CSV into Numbers.app properly, you need to set the decimal separator to period in System Preferences. If decimal separator is set to comma, Numbers.app can only import semicolon-separated CSV.

  1. Quit Numbers.app;
  2. Set the decimal separator to period, temporarily, in System Preferences; [/Language & Region/Advanced]
  3. Launch Numbers.app, import the CSV file and save the resultant Numbers file;
  4. Quit Numbers.app;
  5. Reset the decimal separator to the original (presumably, comma) in System Preferences;
Related Question