本指南介绍如何在Windows 10中将记事本文件(.txt)转换为Microsoft Excel文档(.xlsx)。
步骤
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/7\/79\/Convert-Notepad-to-Excel-Step-1.jpg\/v4-460px-Convert-Notepad-to-Excel-Step-1.jpg","bigUrl":"https:\/\/www.zenmeban.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>"}
1
打开Microsoft Excel。要快速打开Excel,可以在Windows搜索栏中输入excel,然后点击Microsoft Excel。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/3\/3c\/Convert-Notepad-to-Excel-Step-2.jpg\/v4-460px-Convert-Notepad-to-Excel-Step-2.jpg","bigUrl":"https:\/\/www.zenmeban.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>"}
2
点击文件菜单。它位于Excel的左上角。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/2\/2c\/Convert-Notepad-to-Excel-Step-3.jpg\/v4-460px-Convert-Notepad-to-Excel-Step-3.jpg","bigUrl":"https:\/\/www.zenmeban.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>"}
3
点击打开。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/1\/1b\/Convert-Notepad-to-Excel-Step-4.jpg\/v4-460px-Convert-Notepad-to-Excel-Step-4.jpg","bigUrl":"https:\/\/www.zenmeban.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>"}
4
在文件类型下拉菜单中选择文本文件。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/9\/9f\/Convert-Notepad-to-Excel-Step-5.jpg\/v4-460px-Convert-Notepad-to-Excel-Step-5.jpg","bigUrl":"https:\/\/www.zenmeban.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>"}
5
选择要转换的文本文件,然后点击打开。随后会打开“文本导入向导”。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/f\/f5\/Convert-Notepad-to-Excel-Step-6.jpg\/v4-460px-Convert-Notepad-to-Excel-Step-6.jpg","bigUrl":"https:\/\/www.zenmeban.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>"}
6
选择收据类型,然后点击下一步。如果文本文件中的数据通过逗号、制表符或其他符号分隔,在“原始数据类型”中选择分隔符号。如果数据按列对齐,每个字段间都有空格,选择“固定宽度”。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/1\/1d\/Convert-Notepad-to-Excel-Step-7.jpg\/v4-460px-Convert-Notepad-to-Excel-Step-7.jpg","bigUrl":"https:\/\/www.zenmeban.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>"}
7
选择分隔符号或字段宽度,然后点击下一步。
- 如果在上一步中选择的是“分隔符号”,勾选用于分隔数据字段的符号。如果用空格分隔,选择“空格”。
- 如果选择的是固定宽度,按屏幕上的说明整理数据。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/b\/ba\/Convert-Notepad-to-Excel-Step-8.jpg\/v4-460px-Convert-Notepad-to-Excel-Step-8.jpg","bigUrl":"https:\/\/www.zenmeban.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>"}
8
选择列数据格式。在“列数据格式”下选择最相符的数据格式,比如文本或日期。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/a\/a9\/Convert-Notepad-to-Excel-Step-9.jpg\/v4-460px-Convert-Notepad-to-Excel-Step-9.jpg","bigUrl":"https:\/\/www.zenmeban.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>"}
9
点击完成。随后会打开“另存为”窗口。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/7\/76\/Convert-Notepad-to-Excel-Step-10.jpg\/v4-460px-Convert-Notepad-to-Excel-Step-10.jpg","bigUrl":"https:\/\/www.zenmeban.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>"}
10
在“保存类型”中选择Excel工作簿(*.xlsx)。它位于窗口的底部。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/c\/cd\/Convert-Notepad-to-Excel-Step-11.jpg\/v4-460px-Convert-Notepad-to-Excel-Step-11.jpg","bigUrl":"https:\/\/www.zenmeban.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>"}
11
输入文件名并点击保存。这样就能将记事本文件保存为Excel工作簿了。