3

After my laptop got formatted, .csv files are opening only through Notepad. I want .csv files to open with Excel always.

For this, I tried changing its default app to Excel, but unfortunately got no option like Excel as an app to open .csv files.

Here is a screenshot of the same:

enter image description here

I would also like to share that I have Excel installed on my laptop, here are the screenshots:

enter image description here

enter image description here

And here is the screen shot of Microsoft office:

enter image description here

As suggested in comments below, I right clicked on the .csv file, but got no options to open them with Excel. Here are the screen shots of the same:

enter image description here

enter image description here

I even clicked on more apps, but got no option like Excel.

Can anybody kindly help me to set Excel as my default app to open .csv files?

7
  • 2
    Maybe a silly question, but is Excel installed? And are you sure it's not the web-only version?
    – gronostaj
    Jul 10 at 19:03
  • @gronostaj Thanks for helping me. I have updated my question in order to show that I have Microsoft Excel installed. Jul 11 at 5:31
  • Is MS Excel 2010 the most recent version you have installed?
    – shoover
    Jul 12 at 1:49
  • @shoover Yes, this is the most recent version of Excel on my laptop Jul 12 at 2:02
  • Actually, another person from HP came to format my laptop. So, he had installed this version of Excel. I doubt whether it is the latest version available in the market. Jul 12 at 2:05
29

Right click the file, choose open with. If Excel is not showing, select more apps, then chose option to browse. Browse for Excel and choose it. You can also check to always use this type of app for the file type within the same options.

4
  • 1
    just adding another option, use Import data from CSV from Excel might be an option too , from Data Tab , then look for menu "From Text/CSV" , this way there's gonna be a menu to show options (delimiters, data type) during importing the csv data to the table layout of excel. Jul 12 at 2:31
  • Yes, I implemented this method also in order to open CSV files, but it becomes difficult when we have too many CSV files to open and we always have to import CSV, select delimiter, and only then read them in excel. Jul 12 at 4:09
  • If Your computer really does not like Excel for some reason you may need to use the "find another app on this PC" option and hunt down the .exe manually. Do this beforehand by right clicking any link to excel itself and use the "open file location" option, then copy the path. This works 100% as long as you have excel installed
    – Hobbamok
    Jul 13 at 11:03
  • 1
    @Hobbamok Actually, some versions of Excel don't work like this; they give themselves magic CLSID links, so you can't open file location. (The executables are still there, though, if you manually navigate to them in (probably) Program Files.)
    – wizzwizz4
    Jul 13 at 22:20
9

Emily's answer is what I'd suggest if it wasn't already posted, as it covers actually locating Excel on the PC.

But, as more of a side note that seems a little too useful to leave in a comment: if you want to quickly open a file in Excel without needing to associate it with Excel, you can open Excel first, then open File Explorer and navigate to where your .csv file is, then drag the .csv file into the blank Excel window. (This works for most programs and file types too, not just Excel and .csv files - if you ever need to open something in something it doesn't want to open with by itself, it's worth giving it a try.)

1
  • Thanks for suggesting one more useful answer. Jul 12 at 7:06
7

Which Office do you have? Could other formats of Office files (.xls, .xlsx and etc) be opened successfully via Excel?

As you said your laptop got formatted, please ensure your Office is installed on your laptop now.

You may go to Control Panel to have a check.

If the Office exists on you laptop, I suggest you right-click the .csv file > Properties > Change Open with > If there is no Excel app, click More apps > Look for another app on this PC > Locate to Office installation directory (Such as 64-bit Microsoft 365 apps, its path is C:\Program Files\Microsoft Office\root\Office16. For 32-bit version, the path is C:\Program Files (x86)\Microsoft Office\root\Office16) > Find and choose Excel.exe to open .csv file.

If the Office suit is not shown on Control Panel, please log the account you associated with this version of Office into www.office.com, download and the installation content.

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.