The fastest way to move data from Notepad to Excel

Open your Notepad file, select all the text (Ctrl+A), and copy it (Ctrl+C). Then open Excel, click on cell A1, and paste (Ctrl+V). If your data is separated by tabs or commas, Excel will automatically split it into columns. If it does not split automatically, use the Text to Columns feature under the Data menu to tell Excel how to divide the information.

This method works best when your Notepad file contains structured data — rows and columns separated by consistent spacing, tabs, or commas. If your text is just paragraphs or mixed formatting, it will paste as one long entry in a single cell, and you will need to manually organize it afterward.

Key Takeaways

  • Copy all text from Notepad and paste it directly into Excel; the program will often recognize column breaks automatically if your data uses tabs or commas.
  • Use Data > Text to Columns if Excel does not split your data into separate columns on its own.
  • Tab-separated and comma-separated data converts most cleanly; plain text paragraphs will land in a single cell and require manual reorganization.
  • Save your Excel file as .xlsx (the standard Excel format) rather than leaving it as a pasted text block.

When to use copy and paste versus Text to Columns

Copy and paste works when ready if your Notepad file already has clear separators between columns. Open Notepad, select all (Ctrl+A), copy (Ctrl+C), switch to Excel, click cell A1, and paste (Ctrl+V). If the data splits into columns right away, you are done — just save the file as an Excel workbook (.xlsx).

If the data lands in one column instead of spreading across multiple columns, use Text to Columns. Click the column that holds all your data, go to the Data menu at the top, and select Text to Columns. A dialog box will appear asking how your data is separated — choose Delimited if it uses tabs, commas, or spaces, or Fixed Width if the columns are aligned by character position. Click through the preview to confirm the split looks correct, then finish.

Preparing your Notepad file before converting

Before you copy anything, open your Notepad file and check how the data is organized. Look for patterns: Are entries separated by commas? By tabs? By line breaks? Consistent separation makes the conversion much cleaner. If your file is messy — with irregular spacing or mixed separators — spend a few minutes cleaning it up in Notepad first.

If your Notepad file uses spaces to separate columns, make sure the spacing is consistent. Uneven spacing can confuse Text to Columns. Tabs and commas are more reliable because they are actual characters that Excel recognizes as dividers. If you have spaces, consider replacing them with tabs or commas using Find and Replace (Ctrl+H in Notepad) before you convert.

Saving your file as an Excel workbook

After you paste your data into Excel and organize it into columns, save the file in Excel format. Click File > Save As, choose a location, give the file a name, and select Excel Workbook (.xlsx) from the file type dropdown. Do not save it as a text file (.txt) or it will lose the Excel formatting and column structure.

If you want to keep the original Notepad file unchanged, save the Excel version with a different name. This way you have both the raw text file and the organized spreadsheet.

Handling data that does not split cleanly

Sometimes Notepad data does not convert smoothly because the separators are inconsistent or missing. If Text to Columns does not work the way you need, you can manually move data into the right cells. Click a cell, type the information you want there, and press Enter to move to the next row. This is slower but gives you complete control.

Another option is to go back to Notepad and add separators before you convert. If your data is separated by spaces but you need it separated by commas, use Find and Replace to swap spaces for commas. This takes a few minutes but makes the Excel conversion automatic and error-free.

Using Excel's import features for larger files

If your Notepad file is very large or contains complex data, you can use Excel's import function instead of copy and paste. Open Excel, go to File > Open, and navigate to your Notepad file. Excel will open the Text Import Wizard, which walks you through the same steps as Text to Columns — you choose your delimiter, preview the result, and finish. This method is more reliable for big files because it handles the conversion in one step rather than pasting and then splitting.

The Text Import Wizard also lets you set the data type for each column — you can tell Excel whether a column contains numbers, dates, or text. This prevents Excel from reformatting your data in unexpected ways, like turning a number into scientific notation or a date into a different format.

Common mistakes to avoid

Do not paste your Notepad data into a cell that already contains a formula or other information — it will overwrite what is there. Always paste into an empty area, usually starting at cell A1 in a new sheet. If you make a mistake, press Ctrl+Z to undo and try again.

Do not forget to save your file as .xlsx after you finish organizing the data. If you close Excel without saving, all your work will be lost. Excel will prompt you to save when you close, but it is safer to save manually (Ctrl+S) as you work.

Frequently Asked Questions

What if my Notepad file uses spaces instead of tabs or commas?

Spaces work, but they are less reliable because Excel cannot always tell where one column ends and another begins. Open your Notepad file, use Find and Replace (Ctrl+H) to swap spaces for commas or tabs, then save and convert. Commas and tabs are clearer dividers and will split into columns more accurately.

Can I convert a Notepad file that has multiple sheets worth of data?

A single Notepad file becomes a single Excel sheet. If your Notepad file contains data that should be split across multiple sheets, you will need to organize it manually in Excel after you paste it. Copy the data for the first sheet, paste it, then create a new sheet (right-click the sheet tab at the bottom) and paste the next section there.

Why did my numbers turn into scientific notation after I pasted them?

Excel sometimes reformats large numbers automatically. Select the column with the numbers, right-click, choose Format Cells, and select Number from the Category list. Set the decimal places to 0 if you do not need decimals, then click OK. Your numbers will display normally.

What is the difference between .xlsx and .xls format?

.xlsx is the current Excel format and works on all modern versions of Excel. .xls is an older format that some very old versions of Excel use. Save as .xlsx unless you know the person receiving the file needs .xls. Most people use .xlsx today.

Can I undo the Text to Columns split if I change my mind?

Yes. Press Ctrl+Z when ready after using Text to Columns and your data will go back to a single column. If you have already done other work in the spreadsheet, undo may not work. In that case, close the file without saving and reopen it to start over.