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)

Screenshot_2023-03-25_at_10.07.23_AM.png

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

Screenshot_2023-03-25_at_10.14.54_AM.png 

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

Screenshot_2023-03-25_at_10.20.26_AM.png

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

Screenshot_2023-03-25_at_10.20.47_AM.png

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

Screenshot_2023-03-25_at_10.21.07_AM.png

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

Screenshot_2023-03-25_at_10.23.26_AM.png 

7.  All done!

Screenshot_2023-03-25_at_3.06.33_PM.png 

CONTACTMe

Assoc. Prof. Ts. Dr. Aidi Ahmi
Tunku Puteri Intan Safinaz School of Accountancy
Universiti Utara Malaysia
06010 UUM Sintok
Kedah, MALAYSIA
P: +604 928-7222
[email protected]

QUOTEof the Day

"Be faithful to that which exists within yourself."
Andre Gide