Share via

CSV Files Not Opening up Separated / Mac Sonoma

Anonymous
2023-11-15T07:08:12+00:00

Hello, I recently upgraded to an M2 Mac on Sonoma 14.1.1 (23B81).
I heavily depend on using CSVs for my work, and since the upgrade my CSV files are not opening up the same way they did on the i7 MacBook Pro 2019

On my previous MacBook after Ventura update I was able to use the terminal command workaround and it fixed the files.

On this M2 I can't seem to do that. I am in desperate need for a fix.

What is strange is using Text To Columns with the non-separated CSV file I can't even convert the decimal points such as .48 into % or numbers such as 123456 into comma separated after the file is converted into columns.

Microsoft 365 and Office | Excel | For business | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-11-20T09:34:14+00:00

    Have you tried change region setting?

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Bob Jones AKA CyberTaz MVP 435.3K Reputation points
    2023-11-15T16:40:12+00:00

    You won't find what Snow Lu described in point #1. That may be true in Excel for Windows but not in the Mac version. Instead go to File> Import or on the Data tab click the Get Data (Power Query) tool & select From Text (Legacy).

    There should be no need to use Text to Columns once the data is imported & you should be able to apply formatting to the fields.

    If not familiar with it you may want to investigate the Power Query feature for future use.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2023-11-16T05:58:34+00:00

    Thank you for the reply.
    I work heavily with CSVs importing is cutting into my efficiency drastically. I don't know why on my i7 mac with the same OS It works as it should and on the M2 it can't seem to work. Still looking for an answer and thank you for your reply.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2023-11-16T05:54:47+00:00

    Firstly thank you for the reply.

    1. Does not work, and is not convenient for me either my i7 Mac is on the same operating system and it opens up downloaded CSVs already separated and in the correct format.
    2. This method actually messes up the values for certain rows and is also not convenient for me.
    3. I tried this as well and nothing changed.

    Was this answer helpful?

    0 comments
  5. Anonymous
    2023-11-15T11:23:18+00:00

    Could you share a screenshot of your issue?

    1. You may try importing the CSV file instead of opening it directly. To do this, open Excel and go to the Data tab. From there, select "From Text/CSV" and navigate to the location of your CSV file. Follow the prompts to import the data into Excel.
    2. Using the "Text to Columns" feature to separate the data into columns.

    3.Change system separator to match the csv file.

    In Excel> Preferences> Edit you can opt to use the System separators or specify custom Decimal & Thousands separators. Restart the program after making any changes.

    Was this answer helpful?

    0 comments