How to Open CSV Files with Excel by Default


Last updated: March 3, 2017

You may have decided that you want to open CSV files in Microsoft Excel by default if you find that double-clicking those files is causing them to open in another program. The typical default setting usually has CSV files opening in Notepad but, as the data layout for many .csv files is well-suited for a spreadsheet, it is often preferable to open your CSV files in Excel by default and make it easier to edit your data.

Windows 7 will make a lot of choices on its own when it comes to opening files on your computer. In most cases its choices will be fine and you will not have to alter them. However, sometimes Windows makes a bad choice, or you install a certain program that changes your default file types and sets a certain file to open with a program that you do not want to use. This can be the case with CSV files, especially if you have ever opened a CSV file with Notepad or have needed to make changes to a CSV file outside of Microsoft Excel. Fortunately it is possible to change your Windows 7 settings to open CSV files with Excel by default. After you make this change, any CSV file that you double-click will open in Excel automatically.

 

Set Excel as the Default Program for CSV Files

Technically speaking, a CSV file is a text document where fields of data are separated by a delimiter, such as a comma. This is a common file type that is exported or created by databases and, as such, is one that you might receive from a client or customer. However, there are slight formatting differences that can exist between CSV files, which could force you to open the file in Notepad or another text-editing program to make certain formatting changes. But once a change of this manner has been made, CSV files are much simpler to work with in Excel because of how easily CSV data is mapped to cells in a spreadsheet.

Begin the process of setting Excel as the default CSV program by clicking the Start button at the bottom-left corner of the window, then clicking Default Programs.

open the default programs window

 

Click the blue Associate a file type or protocol with a program link at the center of the window.

associate a file type or protocol with a program

 

Scroll through the list of file types until you locate the CSV option, then click it once to highlight it in blue.

Click the Change program button at the top of the window.

Click the Microsoft Excel option under Recommended Programs, then click the OK button.

how to open csv files with excel by default

 

Any CSV file you encounter on this computer will now open in Microsoft Excel automatically when you double-click it in the future. If you decide that you want to edit a CSV file in a different program other that Microsoft Excel, but you do not want to remove this default file association, you can right-click the CSV file, click Open with, then click the program you want to use.

Summary – How to open CSV files in Excel by default

  1. Click the Start button.
  2. Click Default programs.
  3. Click the Associate a file type or protocol with a program link.
  4. Select the .csv option.
  5. Click the Change program button.
  6. Click Microsoft Excel.
  7. Click the OK button.

Do you have a lot of CSV files that you need to combine into one file? Learn how to merge CSV files quickly and easily in Windows.

birthday t-shirts for boys
buoy band tee shirt