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, sometime 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.
Click the blue Associate a file type or protocol with a program link at the center of the window.
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.
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.