How to Open CSV Files With Excel by Default

To make CSV files open in Excel when you double-click them, open Settings > Apps > Default apps in Windows, search for .csv, and choose the installed desktop version of Excel. This changes the app associated with that file extension. It does not convert a CSV into an Excel workbook or change how Excel interprets its values.

Keep an untouched copy of important exports first, because Excel can change leading zeros, long IDs and date-like text when it opens a CSV. This guide covers Windows 11, Windows 10 and Mac.

Before you change the default

You need desktop Excel installed on the computer. Access to Excel in a web browser does not automatically provide a local application for Windows to associate with CSV files. If your organization manages default apps, the setting may also be restricted or restored by its policies.

CSV means comma-separated values. It is a text file containing rows and fields, often exported from another application. Excel can display those fields in cells, but the file itself does not store workbook features such as multiple worksheets, cell colors, or formulas in the same way as an .xlsx file. PowerShell can create one for you, as in this walkthrough on getting a list of file names from a folder into Excel. For a few comma-separated lines copied from an email or web page, you can paste them and split them into columns without saving a file.

Make sure you are changing the association for .csv, not .xlsx, .txt, or another extension. Note the current app so you can switch back later. If you’re not sure what is in the file, you can open a CSV in Notepad to see the raw text without Excel changing it.

Set Excel as the CSV default in Windows 11

Microsoft documents this route in its guide to changing default apps in Windows.

  1. Open Settings. Open Start and select Settings, or press Windows + I. The Windows Settings window appears.
  2. Select Apps, then Default apps. This page controls which installed apps open different file types and links.
  3. Search for .csv in the file-type search field. Include the leading period. Select the matching CSV result rather than a similarly named application.
  4. Select the app shown under .csv. Choose Excel in the list, then select Set default.
  5. Check the .csv result again. Excel should now be listed as its associated app. Close Settings when the selection is correct.
  6. Double-click a spare copy of a CSV. Excel should open it. Check the columns and important values before saving; a file that opens fine can still have values Excel changed on import.
Windows 11 Default apps page with .csv searched and Excel set as the default app
Search for .csv and check that Excel is the app listed under it.

You can also find Excel in the apps list on the Default apps page and see which file types are assigned to it. Change the .csv entry. You don’t need to change every file type Excel can open.

The same Default apps search works for other file types, for example when you change the default PDF viewer in Windows 11.

For other extensions, the article on how to change file associations in Windows 11 covers every method.

Use the older Windows 10 file-type list

On Windows 10, the Default apps page uses a long list of file types instead of a search box.

  1. Open Start > Settings > Apps > Default apps. You should see the default-app categories.
  2. Select Choose default apps by file type. Windows loads an alphabetical list of extensions and their current applications.
  3. Scroll to .csv. Find this exact extension in the left column; do not select the adjacent file type by accident.
  4. Select the app beside .csv, or Choose a default if none is assigned. Choose Excel from the available applications.
  5. Return to the .csv row and test a file copy. The row should show Excel, and double-clicking the copy should launch it.
Windows 10 file-type list with Excel shown beside the .csv extension
Find the .csv row and check that it shows Excel.

Open one CSV without changing every CSV

For a single file, right-click it in File Explorer and use Open with > Excel when Excel is offered. Alternatively, start Excel and use File > Open to browse to the CSV. If the browse dialog filters out text files, change the file-type filter so the CSV is visible.

Opening directly is convenient for uncomplicated data. For identifiers or ambiguous dates, go straight to Data > From Text/CSV instead. Excel can make automatic type decisions when it opens a .csv directly, as explained in Microsoft's text and CSV import guide.

That import route also handles long message bodies well when you export Outlook emails to Excel.

An imported CSV can also be set to refresh automatically each time the workbook opens.

The same import command works for a table saved from Word as plain text. The steps for converting a Word table to Excel walk through that route.

Make CSV files open in Excel on a Mac

On a Mac, change the association in Finder instead of Windows Settings. Apple’s instructions for choosing an app to open a file separate opening one file from changing all files of that type.

  1. Select a CSV in Finder. Use a sample file or a copy of your export.
  2. Choose File > Get Info. The information window for that selected file opens.
  3. Expand Open with and choose Microsoft Excel. Excel must be available on the Mac. Choose it from the application menu.
  4. Click Change All and confirm the choice. This applies the application choice to files of the same type, rather than just the selected file.
  5. Close the information window and open a CSV copy. Make sure Excel opens it, then check the data before saving.

If you only want to open the selected CSV once, use Finder's Open With command instead. The Windows association steps do not apply to macOS.

Import a CSV without losing leading zeros or long IDs

Setting a default app cannot protect the contents of a CSV from Excel's type detection. For example, an ID such as 00123 might become the number 123. A 16-digit identifier can lose precision if Excel treats it as a number. Applying a Text format afterward cannot reliably recover digits or zeros that have already been lost.

The safer approach is to import the original file and set the column types before loading them. These steps apply to desktop Excel versions that have Data > From Text/CSV and Power Query. If your version doesn’t have this option, use the import tools for your edition. Exported names and addresses often come in all caps, and Power Query or PROPER can capitalize each word in Excel after import.

  1. Open a blank workbook and select Data > From Text/CSV. Choose the original CSV, then open it. A preview or Navigator window appears.
  2. Check the delimiter and file origin. Make sure the preview splits fields into the right columns and shows characters correctly. If detection got it wrong, choose the right separator and encoding.
  3. Control type detection before loading. If the preview offers a Data Type Detection choice, selecting no automatic detection leaves columns as Text. This is a useful starting point for files containing IDs that must remain exact.
  4. Choose Transform Data if you need to check column types. In Power Query Editor, select the column and use its data-type control or Home > Data Type > Text. Look for a Changed Type step Excel added on its own; it may already have converted the original values.
  5. Verify the preview, then load the data into the workbook. Look for preserved zeros, full identifiers, correct column boundaries, and correct dates. Save a separate workbook after reviewing the result.

Microsoft’s Text/CSV connector documentation explains the delimiter, file-origin, and type-detection choices. Power Query can detect types from the first 200 rows, the full data set, or leave every column as Text. A 200-row sample can miss unusual values later in the file.

If a Changed Type step removed zeros or changed an ID, delete that step and see whether the original values come back. If they don’t, start again from the original CSV with type detection turned off. Changing the cell format won’t bring back the original data.

Preserve exact CSV values. Keep the untouched export: Work on a copy or new workbook. Import From Text/CSV: Check the delimiter and encoding. Prevent unwanted conversion: Keep IDs as Text before loading. Review and save a workbook: Compare zeros, digits and dates.
Illustration: Preserve exact CSV values.

Fix common CSV opening problems

Excel does not appear in the default-app choices

First make sure the desktop app is installed and opens on its own. A browser shortcut to Excel is different from the installed app. If Excel opens, try File > Open with the CSV copy to tell an association problem from a file problem.

On a managed work computer, ask your administrator about the Excel installation or the default-app policy. Don’t pick an unrelated program from the browse dialog. You can still use Excel’s import command in the meantime.

Everything appears in one column

The file may use a semicolon, tab, or another delimiter that Excel isn't expecting. Import the original through From Text/CSV, select the separator the file uses, and check the preview before loading.

Don’t change the Windows list separator for one file, because it affects other apps and exports. Don’t replace commas in a text editor either, since commas can be part of quoted names and addresses.

Accented letters or symbols look wrong

Check File Origin or the encoding selection in the import preview. The source's actual encoding determines the correct choice. This connector detects UTF-8 automatically when the file begins with a UTF-8 byte-order mark; a file without that marker may need an explicit choice.

Numbers or dates changed after opening

Close the converted copy without overwriting the original, then reimport the untouched export with explicit types. Formatting an already changed identifier as Text does not recreate its missing digits. If the original has been overwritten, retrieve another export or a backup before trying to reconstruct the values.

The file is larger than a worksheet can hold

Excel worksheets have a limit of 1,048,576 rows and 16,384 columns. A larger file won’t fit on one worksheet, and changing the default app doesn’t change that limit. Use a different import method or data tool and check that every record you need came through.

Before you merge several CSV files into one, add up their row counts so the combined file still fits on a single worksheet.

Save your work without confusing CSV and XLSX

Use Save As to create a separate Excel Workbook (.xlsx) if you need workbook formatting, multiple worksheets, or other Excel features. Keep the original CSV when you need to compare the imported data with its source. Mac users who want Excel to offer a different format first can change the default save format in Excel for Mac. A saved .xlsx workbook also makes a dependable mail merge source if you plan to print name tags from the list.

If you send the workbook to someone without Excel, they can still open the XLSX file with a free app.

When you save back to CSV, Excel exports the active worksheet, and the text format cannot preserve every workbook feature. Review any format warning before proceeding. Renaming a file from .csv to .xlsx does not perform a real conversion.

Undo the default-app change

In Windows, return to Settings > Apps > Default apps, find .csv, and choose the application you previously recorded. On a Mac, repeat Get Info > Open with > Change All with the previous app.

This reverses which application opens CSV files. It does not undo data edits or conversions saved inside a file. Restore those from the untouched original or another backup. If you also changed Excel's automatic-conversion preferences, restore those separately.

Default CSV Program Questions

Does this make every spreadsheet open in Excel?

No. A .csv association applies to CSV files. Other extensions, including .xlsx and .txt, have their own associations. Change each only when that is what you intend.

Can Excel in a browser become the Windows CSV default?

No. Windows can only assign .csv files to an installed app, so you need desktop Excel. Excel for the web can still open a CSV you upload to OneDrive, but that doesn’t change the Windows default.

Without desktop Excel, you can also upload a CSV file to Google Drive and open it in Google Sheets in your browser.

Will changing the icon convert the file?

No. An Excel icon indicates the chosen application. The underlying CSV remains a text file until you explicitly save its contents in another format.

Why use import if double-clicking already works?

Import gives you control over separators, encoding, and data types before loading the file. Double-clicking is convenient when automatic interpretation is acceptable. Use import when preserving exact values matters.