Notepad to Excel Conversion: Steps and Common Fixes

How-to basics · Updated November 20, 2026

To convert a Notepad file to Excel, save the text file, then in Excel for Microsoft 365 on Windows choose Data > From Text/CSV, select the file, set the delimiter and data types in the preview, and choose Load. The key is that Notepad stores plain text: Excel can separate the contents into columns only when the text has a consistent separator, such as commas or tabs.

What Notepad-to-Excel conversion means

Notepad is a text editor, not a spreadsheet. It does not store worksheet cells, formulas, formatting, or column definitions. A file ending in .txt may contain a list, a table-like set of lines, or an unstructured block of text. Excel conversion means bringing that text into a worksheet and deciding how lines and separators map to rows and columns.

For example, this text has three comma-separated fields on each line:

Product,Quantity,Price
Notebook,4,2.50
Pen,10,0.75

Excel can interpret each line as a row and each comma as a column boundary. If the same information is written as “Notebook 4 2.50” with spaces between values, Excel cannot reliably tell whether a space is a delimiter or part of a product name. Clean, consistent structure makes conversion more accurate.

Choose a suitable text format

Before importing, identify how the fields are separated. Common choices include commas, tabs, semicolons, and fixed-width columns. A tab-separated text file is often called TSV; it usually works well when values contain commas, such as addresses or prices written with thousands separators. Comma-separated values are common when the fields do not contain unprotected commas.

  • Comma-delimited: Fields are separated by commas. A value that itself contains a comma is commonly enclosed in double quotes, as in "Seattle, WA".
  • Tab-delimited: Fields are separated by tab characters. This is useful for copying tables from many applications or for text containing ordinary commas.
  • Semicolon-delimited: Sometimes used when commas are used as decimal marks or when a system expects semicolons.
  • Fixed-width: Fields occupy set character positions rather than being separated by a character. Names and codes may line up visually, but the spacing must be consistent.

Do not choose a delimiter just because it appears somewhere in the file. Check several lines, including lines with the longest text, and make sure the same separator divides the same fields throughout. If rows have different numbers of fields, investigate whether values contain unquoted separators or whether the source data is irregular.

Import a Notepad file through Excel

The import workflow gives you more control than simply opening a text file. In Excel for Microsoft 365 on Windows, use these steps:

  1. In Notepad, choose File > Save As. Give the file a clear name and save it with a .txt extension. If the Save As dialog offers an encoding choice, UTF-8 is a sensible option for text that may include accented characters or symbols.
  2. Open the destination workbook in Excel. Select Data > From Text/CSV, browse to the .txt file, and select Import.
  3. In the preview, check the file origin or encoding and choose the delimiter that matches the text. Confirm that the preview shows the intended fields in separate columns and each record on its own row.
  4. Choose Load to bring the data into a worksheet. If you need to inspect or adjust the import steps first, choose Transform Data; in the Power Query Editor, make the changes and select Home > Close & Load.

The preview is important: it is an opportunity to catch a wrong delimiter, garbled characters, or a column that Excel has interpreted as a date or number. Depending on the Excel build and import settings, Excel may attempt to detect column types. If the preview offers a data-type detection choice, disable automatic detection when you need to preserve the original text exactly, or set sensitive columns to Text in the query before loading.

On Excel for Mac, the Data tab also provides text and CSV import options, but labels and available import controls can vary by version. If the Windows path is not present, use the import command shown on the Mac Data tab or open the text file from Excel and follow the available text-import prompts. Review the preview rather than assuming the defaults match your file.

Paste text or split it after pasting

For a short, simple list, you can copy text in Notepad and paste it into Excel. Lines generally paste into separate rows, while tabs in the copied text can divide values into columns. Commas in a pasted line may remain in one cell; pasting is not the same as importing a comma-delimited file.

If the entire pasted line lands in one column but has a consistent separator, select that column and choose Data > Text to Columns. Choose Delimited, select the correct delimiter, review the preview, and finish the wizard. If the columns are aligned by character position instead, choose Fixed width and set the breaks at the appropriate positions. Check the cells to the right before splitting: Text to Columns can overwrite existing content in its output area.

Copy-and-paste is convenient for a quick, one-time conversion, but importing is usually better for a large file or one that must be refreshed. A saved import or query also makes it easier to repeat the same cleanup when a new text file arrives.

Preserve IDs, dates, and other sensitive values

Excel tries to be helpful by recognizing numbers, dates, and other patterns. That can change data that should remain text. A customer code such as 00127 may become 127 if treated as a number; a long account identifier may lose precision; and a value such as 3-4 may be interpreted as a date in some settings. Once information has been altered, formatting the cell as Text afterward does not necessarily restore the original characters.

Use the import preview or Power Query to set columns such as postal codes, product IDs, phone numbers, and account codes to Text before loading. For a date column, confirm the order of day, month, and year. A date written as 04/05/2026 is ambiguous without knowing whether the source uses month/day/year or day/month/year. Where possible, use an unambiguous source format such as year-month-day and verify the result against the original.

  • Check leading zeros in the first and last few records after loading.
  • Compare a sample of dates with the source, especially when regional date conventions may differ.
  • Look for very long numeric-looking values; identifiers are often text even when they contain only digits.
  • Confirm decimal and thousands separators. A value like 1,25 can be read differently depending on the source and regional settings.

Common conversion problems and fixes

Everything appears in one column. The selected delimiter may be wrong, or the file may use fixed-width spacing rather than a delimiter. Reopen the import preview and test the likely separator. If the text is already in Excel, use Data > Text to Columns and inspect the preview before completing the split.

Values split into too many columns. A delimiter may also appear inside values. Properly quoted CSV fields can keep an internal comma together, but malformed or inconsistently quoted lines may not import as intended. Check the source file for missing quotation marks, and consider using tabs or a carefully prepared export if you control the source.

Accented characters show as strange symbols. The file may be read with the wrong encoding. Reimport it and select the appropriate file origin or encoding in the preview. Saving a new copy from Notepad as UTF-8 may help, but preserve the original until you have verified that the new file displays correctly.

Zeros disappear or dates change. Excel has likely converted text to a numeric or date type. Import again and designate that column as Text before loading. Applying a display format after conversion may change how a value looks without recovering characters that were discarded.

Rows do not line up. Look for blank lines, wrapped records, inconsistent separators, or line breaks inside quoted fields. Compare several problem rows in Notepad and determine whether each record truly occupies one line. A messy source may need to be cleaned before it can be split reliably.

Save the converted data in the right format

After checking the worksheet, save the working file as an Excel workbook: choose File > Save As and select Excel Workbook (.xlsx). This format can retain multiple sheets, cell types, formulas, and formatting. Keeping the original .txt file separately gives you an untouched source if you need to repeat the import or check a disputed value.

CSV is useful when another program needs a plain-text table, but it is not a full Excel workbook. A CSV file normally represents one sheet and does not preserve workbook features such as formatting, formulas as formulas, or multiple worksheets. When saving as CSV, Excel may warn that some workbook features are not compatible; choose the option appropriate to the export, and keep an .xlsx copy if you need the full workbook. Reopen an exported CSV in a text editor or import it into a new workbook to verify its separators and characters.

Safety, file size, and repeat imports

Text files can contain untrusted content. Treat files from unknown sources with care, and review imported data before using it in formulas, reports, or automated processes. Text that begins with characters Excel interprets as a formula can be risky in spreadsheet workflows. If a column is meant to be literal text, import it as Text and do not assume that a file is harmless merely because it ends in .txt or .csv.

Excel worksheets have a maximum of 1,048,576 rows and 16,384 columns. A file beyond those worksheet limits cannot fit entirely in one sheet. Very large text files can also take time or memory to parse; importing only the needed fields or using a database or data-processing tool may be more suitable. For recurring work, Data > From Text/CSV and Power Query can make the import steps repeatable: replace the source file and refresh the query, then check that the new file has the same column structure before relying on the output.

When another method is a better fit

If the text is truly unstructured prose rather than a table, importing it will not automatically identify meaningful fields. You may need to clean it in a text editor, establish consistent separators, or use a tool designed to extract information from that particular format. If the source is a log or a large structured export, Power Query can help filter, split, and transform columns before loading. For a tiny list, pasting and using Text to Columns may be quicker. Choose based on the shape of the source and whether you will repeat the conversion—not simply on the file extension.

Frequently Asked Questions

Can I convert a Notepad file to Excel without losing data?
Usually, if you import it with the correct delimiter and encoding and set identifiers or other sensitive fields to Text. Check leading zeros, long numbers, dates, and special characters against the original before saving.

How do I convert a Notepad file with commas into columns?
In Excel, choose Data > From Text/CSV, select the file, and choose comma as the delimiter in the preview. If the fields contain commas, check that those fields are properly quoted and that the preview keeps them together.

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 through Data > From Text/CSV and select the actual delimiter, or use Data > Text to Columns after opening the file.

Can Excel keep leading zeros from a text file?
Yes. Import the relevant column as Text before loading it. If Excel has already removed the zeros by converting the values to numbers, formatting the cells as Text afterward does not reliably recreate the original entries.

Should I save the result as CSV or XLSX?
Use XLSX for a working Excel file that needs multiple sheets, formatting, or workbook features. Use CSV when another system specifically needs a plain-text table, and remember that CSV does not preserve the full workbook.

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.