Open Notepad with Excel: Use Both or Import Text Files

How-to basics · Updated November 20, 2026

Yes—you can open Notepad while Excel is running and use the two programs side by side. If you mean opening a text file in Excel, you can import a .txt or .csv file as spreadsheet data; an Excel workbook such as .xlsx is not something Notepad can display or edit usefully.

What “Open Notepad with Excel” Can Mean

The wording can describe two different tasks. You might want to launch Notepad while working in Excel, perhaps to take notes or inspect a data file. Or you might want to open a file in one program that is normally associated with the other. The first is straightforward: Notepad and Excel are separate Windows applications and can run at the same time. The second depends on the file type.

Notepad is a plain-text editor. It displays characters, line breaks, and tabs, but it does not arrange values into a spreadsheet grid or calculate formulas. Excel is designed to organize data into cells, interpret numbers and dates, and work with formulas. A plain-text table can be useful in either program, but the programs do not make the same assumptions about its contents.

Open Notepad While Excel Is Running

On Windows 10 or Windows 11, open Notepad without closing your workbook. You can search for Notepad from the Start menu, or press Windows key+R, type notepad, and press Enter. Excel remains open, and you can switch between the windows using Alt+Tab or by selecting a window from the taskbar.

To see both applications at once, drag one window to the left edge of the screen and the other to the right, or use Windows Snap. The exact snap options depend on your Windows settings and version. This arrangement is useful when comparing a source text file with imported spreadsheet data, copying notes, or checking whether a file contains tabs or commas. It does not make Notepad a panel or feature inside Excel; it is simply a second app running alongside it.

If you are using Excel for the web, it runs in a browser and does not provide a command to launch Windows Notepad from the workbook. Start Notepad separately in Windows. On a Mac, there is no Windows Notepad app; TextEdit is the built-in plain-text alternative, and you can open it separately from Excel for Mac.

Import a Text or CSV File into Excel

When the goal is to turn a text file into rows and columns, use Excel’s import tools rather than trying to make Notepad behave like a spreadsheet. In Excel for Microsoft 365 on Windows, select Data > From Text/CSV, choose the .txt or .csv file, and review the preview. Choose the correct delimiter—often a comma, tab, or semicolon—then select Load to put the data into a worksheet. The available controls can vary slightly with updates and the type of file.

The preview matters. If the source uses commas between fields, choosing a tab delimiter may put an entire line into one column. Conversely, a comma inside a quoted text value should not necessarily split that value into two columns; the import preview helps reveal how Excel is interpreting the file before you load it. If the text file has a particular character encoding, check the file-origin or encoding option when the preview shows garbled characters.

For example, a comma-separated file might contain rows like Item,Quantity,Price and Notebook,3,2.50. Excel can split those fields into columns, making it possible to sort, filter, format, and calculate with the data. A tab-delimited file works similarly, with tabs separating fields instead of commas. When you only need to inspect a small, uncomplicated file, opening it directly in Excel may also work, but importing through the Data tab gives you a chance to check how the columns are parsed.

On Excel for Mac, use its text-import or text/CSV import option if available in your version; the exact ribbon layout can differ from Windows. Excel for the web has fewer desktop import options, so for a complex text file it may be easier to import it using the Excel desktop app and then save the workbook to OneDrive.

Read or Edit a Text File in Notepad

To inspect a text file as plain text, right-click it in File Explorer and choose Open with > Notepad. You can also open Notepad first and use File > Open. In the Open dialog, change the file-type filter if necessary so that the file appears. This is useful for checking the raw separators in a CSV file, reading a log, or making a small change to a text-based file.

Notepad does not preserve spreadsheet features. If you open a CSV in Notepad, you see its literal characters, such as commas and quotation marks. If you edit and save it, you are changing the text representation, not editing cells in an Excel workbook. Take care not to delete delimiters or line breaks accidentally, since those characters determine where Excel will later divide the data into columns and rows.

Do not use Notepad to edit an .xlsx workbook. An .xlsx file is a packaged spreadsheet format containing structured data and other workbook parts, not a plain-text document. Opening it in Notepad typically produces unreadable symbols or long fragments of internal text. Saving changes from Notepad can corrupt the file. If you need to change values or formulas, edit the workbook in Excel or another compatible spreadsheet application.

Copy Data Between Notepad and Excel

You can copy plain text from Notepad and paste it into Excel. If the text contains line breaks between records and tabs between fields, Excel will often place the records into rows and the fields into separate columns. For instance, copying two lines with a tab between a product name and its quantity can create a two-column, two-row range. Review the result before using it, especially if the text includes uneven spacing or mixed separators.

If pasted data lands in one column, select that column and use Data > Text to Columns in Excel for Windows. Choose Delimited, select the separator actually present in the text, and check the preview before finishing. This is useful for data already in a worksheet that was pasted as one long field. It is not necessary when the paste has already created the intended columns.

Spaces are not always reliable separators. A sentence or a company name may contain spaces that should remain together, while a tab or comma may mark the true boundary between fields. If the source is fixed-width text, where columns are aligned by character position rather than separated by a delimiter, the Fixed width option in Text to Columns may be more suitable. If the result matters, keep an untouched copy of the original text file so you can repeat the import with different settings.

Choose the Right File Format

The extension is a useful clue to what each program can do, but it does not guarantee that a file’s contents are valid. These common formats have different purposes:

  • .txt: Plain text. It may contain a list, a report, or table-like data separated by tabs or other characters.
  • .csv: Text organized as comma-separated values. Excel can import it as rows and columns, while Notepad can show or edit its raw text.
  • .xlsx: A standard modern Excel workbook. Use Excel to work with its cells, formulas, formatting, and sheets.
  • .xls: An older Excel workbook format. It is also intended for a spreadsheet program, not for editing as plain text.

Saving a workbook as CSV is not the same as saving every workbook feature. CSV is meant to store tabular text, generally for one sheet at a time; it does not preserve features such as formulas as working formulas, multiple worksheets, formatting, charts, or macros in the way an Excel workbook does. Excel may warn you about this when saving. Keep an .xlsx copy if you need to retain the workbook structure, and use CSV when a plain-text data exchange format is what you need.

Changing a filename extension manually does not convert the file. Renaming a workbook from .xlsx to .txt will not turn it into a meaningful text document, and renaming a CSV to .xlsx does not create a proper Excel workbook. Use Excel’s Save As or export options to create a different file format.

Common Problems and Safe Fixes

If everything imports into a single column, the delimiter selected may not match the file. Reopen the import or use Text to Columns, then check whether the source uses tabs, commas, semicolons, or fixed-width spacing. Regional settings can affect which separator a program expects, so do not assume that every CSV uses the same delimiter.

If a number such as 00127 loses its leading zeros, Excel may have interpreted it as a number instead of an identifier. Postal codes, account codes, and product IDs often need to be treated as text. Set the relevant column’s data type to text during import when the import dialog allows it, or format the cells as Text before entering or pasting values. If Excel has already removed the zeros, simply changing the display format may not restore them; reimport from the original file as text.

Dates and decimal values can also be interpreted differently depending on their arrangement and regional settings. A date written as 03/04/2026 may be ambiguous, and a decimal comma may be mistaken for a field separator in some circumstances. Check the preview and verify representative values after loading. If the text includes unusual characters, try the appropriate encoding option rather than replacing characters by hand.

Finally, distinguish a file association problem from a file-format problem. If double-clicking a .txt file opens Excel when you want Notepad, use right-click > Open with and select Notepad. If double-clicking a CSV opens Notepad but you want to analyze it, open Excel and import it. Changing the default app affects which program opens a file when you double-click it; it does not change the file itself.

Alternatives to Notepad and Excel

For a quick note, Notepad is appropriate because it avoids spreadsheet formatting and calculations. For structured records, formulas, sorting, and charts, Excel is the better choice. If you need to inspect a large text file or repeatedly transform data, a code editor or a dedicated data tool may offer search, encoding, or preview features that basic Notepad does not. Excel’s Power Query tools can also help with repeatable imports and cleanup, though a simple one-off list may not need them.

Use the program that matches the task: keep raw text in a text editor, analyze tabular values in a spreadsheet, and preserve the original source when importing or converting data. In practice, many people use both: Notepad to examine the source and Excel to work with the resulting table.

Frequently Asked Questions

Can I open Notepad inside Excel?

No. Notepad is a separate Windows application, not an Excel pane or add-in. You can open it while Excel is running and arrange both windows side by side.

Can Notepad open an Excel file?

Notepad can attempt to display a workbook file, but .xlsx content is not readable as an ordinary text document and should not be edited or saved there. Open the workbook in Excel instead.

Can I open a CSV file in Notepad and Excel?

Yes. Notepad shows the raw text, while Excel can split the values into worksheet rows and columns. Use Excel’s import preview to confirm the delimiter and data interpretation.

Why does my text file open in one Excel column?

Excel may not have detected the separator, or the file may use a different delimiter than expected. Import it with Data > From Text/CSV or use Data > Text to Columns to select the correct separator.

Is changing .txt to .xlsx enough to make a spreadsheet?

No. Renaming changes the filename, not the file’s internal format. Import the text into Excel and save it as an Excel workbook if you need an .xlsx file.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.