This article was co-authored by How.com.vn staff writer, Nicole Levine, MFA. Nicole Levine is a Technology Writer and Editor for How.com.vn. She has more than 20 years of experience creating technical documentation and leading support teams at major web hosting and software companies. Nicole also holds an MFA in Creative Writing from Portland State University and teaches composition, fiction-writing, and zine-making at various institutions.
The How.com.vn Tech Team also followed the article's instructions and verified that they work.
This article has been viewed 383,725 times.
Learn more...
This How.com.vn teaches you how to convert a Notepad (.txt) file to a Microsoft Excel document (.xlsx) in Windows 10.
Steps
- Open Microsoft Excel. A quick way to do this is to type excel into the Windows search bar and click Microsoft Excel.
- Click the File menu. It’s at the top-left corner of Excel.Advertisement
- Click Open.
- Select Text files from the file type drop-down menu.
- Select the text file you want to convert and click Open. This opens the Text Import Wizard.
- Select a 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 (if the data is aligned in columns with spaces between each field).
- Select deliminators or field width and click Next.
- If you chose Delimited on the previous screen, check the box next to the symbol (or ″Space″ if it’s separated by a space) used to separate the data fields.
- If you selected Fixed width on the previous screen, follow the on-screen instructions to arrange your data properly.
- Select the column data format. Choose the option under ″Column data format″ that best describes the data in the columns (e.g. Text, Date).
- Click Finish. The ″Save As″ window will appear.
- Select Excel Workbook (*.xlsx) from the ″Save as type″ menu. It’s at the bottom of the window.
- Name the file and click Save. The Notepad text file is now saved as an Excel workbook.
Expert Q&A
Tips
How.com.vn Video: How to Convert Notepad to Excel
About This Article
1. Open Excel.
2. Open the text file.
3. Select deliminators or field width.
4. Select the column data format.
5. Save the file in the .xlsx format.
Is this article up to date?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.