How to Fix CSV Files Opening in the Wrong Application
Question details
Users are unable to open CSV files automatically in their spreadsheet software because double-clicking the file launches an incorrect program like a web browser or the Microsoft Store.
- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Attempting to open a saved or downloaded CSV file by double-clicking it directly from the Windows file explorer.
- Observed behavior
- The CSV file opens in Internet Explorer, the Microsoft Store, or another unexpected application instead of Microsoft Excel, prompting users to incorrectly believe they lack the right software.
Ensure that Microsoft Excel, WPS Office, or another compatible spreadsheet application is currently installed on your computer before attempting to change your default file associations.
Set Excel as the Default Application for CSV Files
Modify your Windows file properties to permanently associate CSV files with your spreadsheet software, fixing the double-click behavior.
This is the most common and effective fix. It tells the Windows operating system exactly which program to use every time you open a comma-separated values (CSV) file.
Open Windows File Explorer and navigate to the folder where your CSV file is saved.
Right-click on the CSV file and select "Properties" from the context menu.
In the General tab, look for the "Opens with:" section and click the "Change" button.
Choose "Excel" (or your preferred application) from the list provided, click "OK", and then click "Apply" to save your settings.
Open the CSV File Directly from Excel
Bypass Windows default app settings entirely by launching your spreadsheet application first.
Perform a Quick Repair of Microsoft 365
Run the built-in Windows repair tool to restore missing Microsoft Office file associations.
Seamlessly Open CSV Files with WPS Office
If Microsoft Excel file associations continue to break or you are tired of dealing with repair tools, WPS Office provides a lightweight, highly compatible alternative. Enjoy seamless spreadsheet management without the frustration of constant Windows app resets.
- 1. Download the software: Click the download button to get the free WPS Office installer from the official website.
- 2. Install and configure: Run the installer and easily set WPS Spreadsheets as your default application for all CSV and Excel files during setup.
- 3. Open instantly: Double-click any CSV file to have it open instantly and correctly in WPS Spreadsheets.
Frequently Asked Questions
Why do my CSV files suddenly open in the web browser?
Windows updates, installing new software, or clearing system caches can sometimes reset your file associations. When this happens, Windows falls back to default applications like Microsoft Edge or Internet Explorer to read the text-based CSV file.
Do I need to buy an app from the Microsoft Store to open CSV files?
No. A CSV (Comma Separated Values) file is a standard text format. If you already have Microsoft Excel, WPS Office, or even standard Notepad installed on your computer, you can open it without purchasing any additional applications.
How do I save a CSV file as a standard Excel file once I open it?
Open the CSV file in your spreadsheet program, click on 'File' in the top menu, and select 'Save As'. In the save dialog window, change the 'Save as type' dropdown menu to 'Excel Workbook (*.xlsx)' and click Save.
