Yes. You can bring a Notepad text file into Excel for Microsoft 365 on Windows with Data > From Text/CSV, or paste its contents into a worksheet and split them into columns. The right method depends on whether the text has clear separators, such as tabs or commas, and whether values such as dates or codes must be preserved exactly.
What converting Notepad to Excel actually means
Notepad stores plain text: characters arranged in a file, usually with a .txt extension. It does not store spreadsheet features such as rows with typed values, formulas, formatting, or multiple worksheets. Excel can nevertheless read the text and organize it into cells. Conversion is therefore an import or rearrangement of text, not a special Notepad export process.
A text file can represent a table in several ways. A tab-delimited file uses a tab between fields, while a comma-separated file uses commas. Some files use semicolons, pipes, or another character. A file may also put each record on a separate line but have no separator between its fields. In that case, there may be no reliable way for Excel to know where one column ends and another begins without additional rules.
For example, these two lines are easy to split at the tabs:
Item Quantity Price
Notebook 3 2.50
By contrast, a sentence such as Notebook 3 2.50 does not unambiguously identify its columns. Spaces can appear inside names, and a number might be part of a name or a value. Before importing, check what separates each field and whether each record starts on a new line.
Import a text file with Data > From Text/CSV
For a saved file, importing is usually the clearest option because Excel shows a preview and lets you inspect how it will divide the text. These steps are for Excel for Microsoft 365 on Windows:
- Save the file in Notepad. Choose File > Save As, select a folder you can find, and check the file name and encoding. Keep a copy of the original.
- In Excel, open a blank workbook or the workbook where you want the data. Select Data > From Text/CSV. Depending on the ribbon layout, the same connector may appear under Data > Get Data > From File > From Text/CSV.
- Browse to the
.txtfile and select Import. In the preview, check the character encoding and delimiter. Choose the delimiter that actually separates the fields, such as Tab, Comma, Semicolon, or a custom character. - Inspect the preview before loading. Confirm that headings and values appear in the intended columns. If the preview is correct, choose Load to put the data in a worksheet. Choose Transform Data if you need to adjust column types or clean the data before loading.
Excel’s import uses Power Query, which can be useful when you expect to repeat the process with an updated file. The query can retain the import steps so you can refresh the result rather than redoing every choice. Check the preview and output after a refresh, especially if the source file’s layout or name changes.
On Mac, current Microsoft 365 versions also offer text-file import on the Data tab, though the exact label and available options can vary by release. If the Windows path is not visible, look on Data for From Text/CSV or the text-import command. Excel for the web has fewer desktop import and transformation options; if the connector is unavailable, import the file in the desktop app and then open the workbook online.
Choose the right way to separate the data
The delimiter is the character or boundary between fields. A wrong delimiter can put an entire record in one cell, or split values into too many columns. Use the preview rather than guessing from the file extension: a .txt file can be tab-delimited, comma-delimited, fixed-width, or unstructured.
- Tabs: Common when data has been copied from a table or exported from a program. Select Tab when the preview shows fields lining up at tab stops.
- Commas: Common in CSV-style text. Commas can also occur inside a field, such as a company name or address. Properly quoted CSV keeps those commas inside the field; check the preview to ensure Excel interprets the quotes correctly.
- Semicolons or pipes: Some applications use these instead of commas, often because of regional settings or the source program’s export choices. Select the actual character shown between values.
- Fixed width: Some older reports align fields by character position rather than using a separator. Use fixed-width parsing where available, or import the text and use Data > Text to Columns to set column breaks.
When a field itself contains the delimiter, the source should use a consistent quoting convention. For example, a comma inside a quoted address should not create a new column. If the file has inconsistent quotes or separators, Excel may not be able to infer the intended structure automatically; correcting the source or cleaning it in Power Query may be necessary.
Use Text to Columns for text already in Excel
If you have already opened or pasted the text and each complete line is in one worksheet column, Excel’s Text to Columns tool can divide it in place. Select the cells containing the lines, then choose Data > Text to Columns. In the wizard, choose Delimited for separators such as tabs or commas, or Fixed width when fields line up by position. Specify the delimiter or breaks, review the preview, and finish.
Make sure the cells to the right of the selected data are empty, because splitting can overwrite existing values. If the original column must remain intact, copy it to another column or worksheet first. Text to Columns is convenient for a one-time split, but it is not as suitable as a saved import query when you regularly receive replacement text files.
You can also paste tab-separated text directly into Excel: copy the lines in Notepad, select a starting cell, and paste. Excel generally places tab-separated fields into separate columns and line breaks into separate rows. This is quick for a small, clean snippet, but importing a saved file gives you more control over encoding, data types, and parsing.
Preserve codes, dates, and other sensitive values
One of the most important import decisions is whether a value should be treated as text or as a number or date. Excel may interpret text automatically. That is helpful when 2026-11-03 is intended to be a date, but harmful when a value is an identifier that must remain exactly as written.
For example, an account code such as 001274 can lose its leading zeros if Excel treats it as a number. Long numeric identifiers may also be rounded because Excel only maintains 15 significant digits of numeric precision. Telephone numbers, postal codes, product IDs, and tracking codes are usually identifiers, not quantities to calculate with, so importing them as text is often appropriate.
In the import preview or Power Query editor, inspect the detected types. Where the tool allows it, set identifier columns to Text before loading. In Text to Columns, select the relevant column in the final wizard step and set its column data format to Text. Applying a text number format after Excel has already removed leading zeros does not restore the original characters; return to the source and re-import if that has happened.
Dates can be ambiguous. A value like 04/05/2026 could mean April 5 or May 4 depending on the date convention. Check the source’s locale and the import settings rather than assuming Excel interpreted it correctly. Also review decimal and thousands separators if the file came from software with different regional settings.
Encoding, file types, and saving the result
Encoding determines how text characters are represented in the file. If names or symbols appear as question marks or odd characters, Excel may be reading the file with the wrong encoding. UTF-8 is common for modern text files; inspect the import preview’s file origin or encoding setting and choose the one that makes the characters display correctly. If saving from Notepad, select an encoding appropriate for the source data and retain the original file until you have verified the import.
After the data is in Excel, save the workbook as an Excel workbook if you want to keep worksheets, formatting, formulas, and other Excel features. Use File > Save As and choose Excel Workbook (*.xlsx). A CSV or text file can store a single flat table, but it does not preserve a workbook’s multiple sheets, formulas as formulas, or most formatting. If you save a workbook back to text or CSV, Excel may warn that some features will be lost.
Do not assume changing the file extension converts its contents. Renaming report.txt to report.xlsx does not create a valid Excel workbook. Import the data in Excel, check it, and then save it in the desired workbook format.
Common problems and practical checks
If the import does not look right, diagnose the structure before editing individual cells. A few checks can prevent a small parsing issue from spreading through a large sheet:
- Everything appears in one column: Reopen the import preview or use Text to Columns and select the delimiter actually used. A file separated by tabs will not split correctly if Comma is selected.
- Values split in the wrong places: Check for delimiters inside quoted fields, inconsistent separators, or spaces that are part of names. A preview with a few representative rows can reveal the problem.
- Leading zeros disappear or long IDs change: Import those columns as Text and start again from the untouched source file.
- Accented characters look wrong: Try the correct encoding in the import settings. Do not repair mojibake by replacing characters unless you have checked the original data.
- Dates or decimals are misread: Confirm the source’s regional convention and inspect the imported values before sorting or calculating.
- The file is too large: An Excel worksheet supports up to 1,048,576 rows and 16,384 columns. A file exceeding a worksheet limit needs filtering, splitting, or a database or other data tool rather than a single worksheet.
Before relying on the result, compare the number of source records with the number of imported rows, inspect the first and last records, and check a few values containing punctuation, zeros, or non-English characters. If the text came from an unknown sender, treat it as untrusted data. Spreadsheet files can contain formulas and links, and certain CSV-like inputs may be interpreted as formulas by spreadsheet software. Avoid enabling unexpected content, and do not treat a text extension as a guarantee that every value is harmless.
Which method should you choose?
For a saved file that you want to import carefully, use Data > From Text/CSV. It provides a preview, lets you choose the delimiter, and offers a repeatable workflow. For a few lines copied from a clean tab-separated list, pasting is faster. For text already inside a worksheet, use Data > Text to Columns. For irregular reports, use Power Query’s transformation options or clean the source first rather than expecting a single automatic split to understand every exception.
There is no separate conversion fee in Excel if you already have access to the application. Notepad and plain-text files do not require a special paid conversion utility. Avoid uploading confidential records to an online converter unless you understand its privacy terms and are permitted to share the data. For sensitive material, use Excel locally or an organization-approved service.
Frequently Asked Questions
Can I convert a Notepad file to Excel without losing data?
Usually, yes, if the text is structured and you choose the right delimiter, encoding, and column types. Keep the original file, preview the import, and check identifiers and dates before saving the workbook. Unstructured prose will not automatically become a meaningful table.
Can Excel open a .txt file directly?
Excel can import text files, but using Data > From Text/CSV makes the parsing choices visible. Opening a text file directly may show an import interface whose appearance varies by Excel version; either way, inspect the delimiter and preview rather than assuming the defaults are correct.
How do I turn a Notepad list into separate Excel columns?
If fields are separated by tabs, commas, or another consistent character, import the file with that delimiter selected. If the list is already in one worksheet column, select it and use Data > Text to Columns. If there is no consistent separator or fixed layout, you may need to edit or restructure the text first.
Will Excel keep leading zeros from a text file?
It can, but a column interpreted as numeric may lose them. Set codes and other identifiers to Text during import, and re-import from the original if zeros have already disappeared. Formatting a changed number as Text afterward cannot recover missing digits.
Should I save the converted file as XLSX or CSV?
Choose XLSX when you want an Excel workbook with formatting, multiple sheets, or formulas. CSV is suitable for exchanging a simple table as plain text, but it represents only one sheet and does not preserve most workbook features. Keep the original text file as a source copy if you may need to repeat the import.
Related
- Accounting Year-End Checklist Template for Excel Users
- 3-Way Forecast Excel Template: 3 Models to Compare
- Excel Borders: How to Add, Change, and Remove Them
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Mail Merge in Word and Outlook: A Step-by-Step GuideTo mail merge in Word and Outlook, prepare a contact list in Excel, create an email in Word,…
- How to Go From Double to Single Space in Microsoft WordTo change double-spaced text to single spacing in Microsoft Word, select the text—or press Ctrl+A on Windows or…
- How to Build a Project Schedule in Excel That WorksTo build a project schedule in Excel, list each task with an owner, start date, working-day duration, and…
- IFERROR Formula in Google Sheets: Syntax and ExamplesIn Google Sheets, use IFERROR to show a chosen fallback instead of an error: if the calculation is…
- Record Audio in PowerPoint: A Practical GuideYes. In Microsoft PowerPoint for Microsoft 365 on Windows, record narration for slides from the Record tab using…
- Excel Jigsaw Solver: What Works and How to Build OneExcel does not include a one-click solver for picture jigsaws or jigsaw Sudoku. For a jigsaw Sudoku, you…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.