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)

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 

Aidi Ahmi

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