How to open .CSV file with Microsoft Excel?

Question

I was told that I could open a .CSV file with Excel. However, my Microsoft Excel refuses to recognize the file.

I have tried my different ways to open it in Excel but the program didn't give me a choice to click the file open.

I am using Mac 10.4 and the Excel version is Microsoft Excel X for Mac.

Since CSV (comma-separated value) files are plain text, it might be worth trying to open it in TextEdit first, to make sure you really are dealing with a CSV file. — calum_b, Aug 26, 2011 at 16:55
Can you choose the file in Finder and then Open it (and what does Open With..) show? — mmmmmm, Sep 13, 2012 at 12:59
They changed the program so that it requires the file to have a '.csv' extension. — Matthew Cornell, Mar 29, 2016 at 13:31

EmmEff · Accepted Answer · 2011-08-26 16:08:24Z

9

Assuming you have a valid/consistent CSV file, create a new workbook and then choose File -> Import. The first option on the list is "CSV file":

enter image description here

answered Aug 26, 2011 at 16:08

EmmEff

1,1315 silver badges6 bronze badges

Thank you for your answer. I appreciate it. However I checked my Excel, there is no Export function anywhere, including the File tab. Please could you advise me again.
– FandW
Aug 29, 2011 at 14:43
Sorry, not familiar with the old version of Office for OS X. Mine is 2008.
– EmmEff
Sep 11, 2011 at 16:01
1

@FandW - the answer was to use Import not export
– mmmmmm
Sep 13, 2012 at 12:58

Add a comment |

PEM8000 · Accepted Answer · 2012-09-13 14:15:24Z

3

Here's a way to force any app to open any document :

Make sure your Dock is visible.
Select your .csv file in the Finder
Grab it with your mouse and move it over the Excel icon in the Dock. Do not release the mouse button.
Hold the Command and the Alt key on your keyboard
Release the mouse button.

answered Sep 13, 2012 at 14:15

PEM8000

3711 silver badge4 bronze badges

This particularly simple. By the way: step 4 is not required. (MacOS 10.11.6, Excel v15.x)
– normanius
Oct 9, 2017 at 23:33

Add a comment |

2 Answers 2