Open CSV File

How to Open a CSV file in Excel for Mac.

How to Open a CSV file in Excel for Mac 

Tested in Microsoft Excel for Mac version 16.71

1. Create a new Excel file and click Data ➔ From Text (Legacy)


2.  Find the CSV file on your PC and click Get Data.


3.  The Text Import Wizard - Step 1 of 3 will appear. Choose Delimited and Click Next.


4.  The Text Import Wizard - Step 2 of 3 will appear. Tick Comma Box and Click Next.


5.  The Text Import Wizard - Step 3 of 3 will appear. Tick General Radio Button and Click Finish.


6.  The Import Data windows will appear. Choose Existing sheet and pick A1 cell and then Click Import.


7.  All done!


Aidi Ahmi

Tunku Puteri Intan Safinaz School of Accountancy
Universiti Utara Malaysia
06010 UUM Sintok
Kedah, Malaysia
Tel: +6049287222
E-mail: aidi[at]