If I download a CSV from a saved search or save an excel as csv and I use it in a CSV import, all columns are in the first row. Use mac. Have tried changing number format in system settings without luck

you were on the right path, it's a setting that's messing it up. "CSV Delimiter" refer: CSV files open with data in a single column in Excel