• About
  • Contact
  • Cookie
  • Disclaimer
  • Privacy Policy
  • Change the purpose of use

Tnhelearning.edu.vn - Various useful general information portal

  • Photo
  • Bio
  • How To
  • Tech

How to Convert Notepad to Excel

January 15, 2024 by admin Category: How To

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

Image titled Convert Notepad to Excel Step 1

Image titled Convert Notepad to Excel Step 1

{“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.
Image titled Convert Notepad to Excel Step 2

Image titled Convert Notepad to Excel Step 2

{“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.
Image titled Convert Notepad to Excel Step 3

Image titled Convert Notepad to Excel Step 3

{“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 .
Image titled Convert Notepad to Excel Step 4

Image titled Convert Notepad to Excel Step 4

{“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.
Image titled Convert Notepad to Excel Step 5

Image titled Convert Notepad to Excel Step 5

{“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.
Image titled Convert Notepad to Excel Step 6

Image titled Convert Notepad to Excel Step 6

{“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).
Image titled Convert Notepad to Excel Step 7

Image titled Convert Notepad to Excel Step 7

{“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.
READ More:   How to Grow a Mustache
Image titled Convert Notepad to Excel Step 8

Image titled Convert Notepad to Excel Step 8

{“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 ).
Image titled Convert Notepad to Excel Step 9

Image titled Convert Notepad to Excel Step 9

{“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.
Image titled Convert Notepad to Excel Step 10

Image titled Convert Notepad to Excel Step 10

{“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.
  • Image titled Convert Notepad to Excel Step 11

    Image titled Convert Notepad to Excel Step 11

    {“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:

    Related Posts

    How to Create Curved Text in Photoshop
    How to fall asleep faster
    How to Install FBReader to Read eBooks

    Category: How To

    Previous Post: « Top 999+ birds images for kids – Amazing Collection birds images for kids Full 4K
    Next Post: Top 999+ good morning peacock images – Amazing Collection good morning peacock images Full 4K »

    Copyright © 2025 · Tnhelearning.edu.vn - Useful Knowledge