You are viewing the article How to Convert Notepad to Excel at Tnhelearning.edu.vn you can quickly access the necessary information in the table of contents of the article below.
X
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 31,694 times.
This wikiHow page will show you how to convert a Notepad(.txt) file to a Microsoft Excel (.xlsx) document in Windows 10.
Steps
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/7/79/Convert-Notepad-to-Excel-Step-1.jpg/v4-728px-Convert-Notepad-to-Excel- Step-1.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/7/79/Convert-Notepad-to-Excel-Step-1.jpg/v4-728px-Convert- Notepad-to-Excel-Step-1.jpg”,”smallWidth”:460,”smallHeight”:346,”bigWidth”:728,”bigHeight”:547,”licensing”:”<div class=”mw-parser -output”></div>”}
Open Microsoft Excel. A quick way to open Microsoft Excel is to type excel in the Windows search bar and click Microsoft Excel.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/3/3c/Convert-Notepad-to-Excel-Step-2.jpg/v4-728px-Convert-Notepad-to-Excel- Step-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/3/3c/Convert-Notepad-to-Excel-Step-2.jpg/v4-728px-Convert- Notepad-to-Excel-Step-2.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight”:551,”licensing”:”<div class=”mw-parser -output”></div>”}
Click the File menu. This is in the upper left corner of Excel.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/2/2c/Convert-Notepad-to-Excel-Step-3.jpg/v4-728px-Convert-Notepad-to-Excel- Step-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/2/2c/Convert-Notepad-to-Excel-Step-3.jpg/v4-728px-Convert- Notepad-to-Excel-Step-3.jpg”,”smallWidth”:460,”smallHeight”:344,”bigWidth”:728,”bigHeight”:545,”licensing”:”<div class=”mw-parser -output”></div>”}
Click Open .
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/1/1b/Convert-Notepad-to-Excel-Step-4.jpg/v4-728px-Convert-Notepad-to-Excel- Step-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/1/1b/Convert-Notepad-to-Excel-Step-4.jpg/v4-728px-Convert- Notepad-to-Excel-Step-4.jpg”,”smallWidth”:460,”smallHeight”:347,”bigWidth”:728,”bigHeight”:549,”licensing”:”<div class=”mw-parser -output”></div>”}
Select Text files from the drop-down menu.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/9f/Convert-Notepad-to-Excel-Step-5.jpg/v4-728px-Convert-Notepad-to-Excel- Step-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/9/9f/Convert-Notepad-to-Excel-Step-5.jpg/v4-728px-Convert- Notepad-to-Excel-Step-5.jpg”,”smallWidth”:460,”smallHeight”:347,”bigWidth”:728,”bigHeight”:549,”licensing”:”<div class=”mw-parser -output”></div>”}
Select the text file you want to convert and press Open . This will open the Text Import Wizard.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/f/f5/Convert-Notepad-to-Excel-Step-6.jpg/v4-728px-Convert-Notepad-to-Excel- Step-6.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/f/f5/Convert-Notepad-to-Excel-Step-6.jpg/v4-728px-Convert- Notepad-to-Excel-Step-6.jpg”,”smallWidth”:460,”smallHeight”:346,”bigWidth”:728,”bigHeight”:547,”licensing”:”<div class=”mw-parser -output”></div>”}
Select the data type and click Next . In the Original data type″ section, select Delimited (if the text file contains data separated by commas, tabs, or some other method) or Fixed width. specified) (if data is aligned in columns with a space between each field).
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/1/1d/Convert-Notepad-to-Excel-Step-7.jpg/v4-728px-Convert-Notepad-to-Excel- Step-7.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/1/1d/Convert-Notepad-to-Excel-Step-7.jpg/v4-728px-Convert- Notepad-to-Excel-Step-7.jpg”,”smallWidth”:460,”smallHeight”:346,”bigWidth”:728,”bigHeight”:548,”licensing”:”<div class=”mw-parser -output”></div>”}
Select the separator or field width and click Next .
- If Delimited was selected on the previous screen, check the box next to the icon (or Space″ if it’s separated by a space) used to separate data fields .
- If Fixed width was selected on the previous screen, follow the onscreen instructions to arrange the data properly.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/b/ba/Convert-Notepad-to-Excel-Step-8.jpg/v4-728px-Convert-Notepad-to-Excel- Step-8.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/b/ba/Convert-Notepad-to-Excel-Step-8.jpg/v4-728px-Convert- Notepad-to-Excel-Step-8.jpg”,”smallWidth”:460,”smallHeight”:343,”bigWidth”:728,”bigHeight”:543,”licensing”:”<div class=”mw-parser -output”></div>”}
Select column data format. Select the option in ″Cpumn data format″ that best describes the data in the columns (e.g. Text , Date ).
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/a/a9/Convert-Notepad-to-Excel-Step-9.jpg/v4-728px-Convert-Notepad-to-Excel- Step-9.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/a/a9/Convert-Notepad-to-Excel-Step-9.jpg/v4-728px-Convert- Notepad-to-Excel-Step-9.jpg”,”smallWidth”:460,”smallHeight”:344,”bigWidth”:728,”bigHeight”:545,”licensing”:”<div class=”mw-parser -output”></div>”}
Click Finish . The ″Save As″ window is displayed.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/7/76/Convert-Notepad-to-Excel-Step-10.jpg/v4-728px-Convert-Notepad-to-Excel- Step-10.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/7/76/Convert-Notepad-to-Excel-Step-10.jpg/v4-728px-Convert- Notepad-to-Excel-Step-10.jpg”,”smallWidth”:460,”smallHeight”:347,”bigWidth”:728,”bigHeight”:549,”licensing”:”<div class=”mw-parser -output”></div>”}
Select Excel Workbook (*.xlsx) (Excel workbook) from the ″Save As″ menu. This item is located at the bottom of the window.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/cd/Convert-Notepad-to-Excel-Step-11.jpg/v4-728px-Convert-Notepad-to-Excel- Step-11.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/cd/Convert-Notepad-to-Excel-Step-11.jpg/v4-728px-Convert- Notepad-to-Excel-Step-11.jpg”,”smallWidth”:460,”smallHeight”:347,”bigWidth”:728,”bigHeight”:549,”licensing”:”<div class=”mw-parser -output”></div>”}
Name the file and press Save . The Notepad text file is now saved as an Excel workbook.
X
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 31,694 times.
This wikiHow page will show you how to convert a Notepad(.txt) file to a Microsoft Excel (.xlsx) document in Windows 10.
Thank you for reading this post How to Convert Notepad to Excel at Tnhelearning.edu.vn You can comment, see more related articles below and hope to help you with interesting information.
Related Search: