How to open CSV files in Microsoft Excel for a Mac

1143015 pts.
Tags:
CSV file
Mac
Microsoft Excel
I'm currently using Microsoft Excel on a Mac. My issue is that I can't open my CSV files correctly. The files open up but all I'm seeing are commas in the columns. Do I have to set the comma delimiter for this to work?
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

Try opening a new (empty) workbook and then using the import option to open the CSV file.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • ToddN2000
    Do these files have a CSV extension? You should be able to open them in Excel with no problem. You mention all you are seeing are commas. Is there any other data? It may be you file is corrupt. Are the commas in one Excel comma or do they fill multiple columns?
    132,840 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: