如果您有一个文本文件中的项目列表，并且您希望将数据从文本文件导入 Microsoft Excel^{(import data from a text file into Microsoft Excel)}，您可以在不手动编写它们的情况下执行此操作。Excel中有一个选项允许用户将.txt文件中的所有文本导入电子表格，以便用户快速完成工作。

假设您在记事本^(Notepad)或.txt文件中有一个产品列表，您需要将它们导入Excel电子表格的列中。有两种方法可以做到这一点。首先^(First)，您可以手动复制和粘贴.txt文件中的所有文本并将其粘贴到电子表格中。其次，您可以使用^(Second)Microsoft Excel的内置选项使其更容易。当您有大量需要导入的文本时，第二种方法很方便。

如何将文本^(Text)文件转换为Excel电子表格

让我们看看如何从文本^(Text)文件导入或导出数据，以便轻松地将文本^(Text)（.txt 或 .csv）文件转换为Excel（.xlsx）电子表格要将文本文件中的数据导入Microsoft Excel，请按照此步骤操作指导-

1. 在 Excel 中创建一个空白电子表格
2. 转到数据选项卡
3. 单击来自文本/CSV
4. 在您的计算机中选择文本文件，然后单击导入按钮
5. 选择文件来源并单击传输数据^{(Transfer Data)}按钮
6. 选择^(Select)要导入的列
7. 单击关闭并加载按钮

首先，在^(Furst)Microsoft Excel中创建一个空白电子表格，并确保您的 PC 中有.txt文件。之后，从主页^(Home)选项卡切换到数据^{(Data )}选项卡。

在这里您可以找到一个名为From Text/CSV的选项。如果找不到此选项，请转到Get Data > From File > From Text/CSV。

然后，您必须选择要从中获取数据的文本文件。单击Import按钮后，它会要求您输入File Origin。如果您已创建文件，则可以使用西欧 (Windows)^{(Western European (Windows))}或任何与来源匹配的文件。完成后，单击传输数据^{(Transfer Data )}按钮。

它将打开Power Query 编辑器^{(Power Query Editor)}窗口。从这里，可以选择要保留或删除的列。有两个选项，名为选择列^{(Choose Columns)}和删除列^{(Remove Columns)}。

同样，您也可以获得保存和删除行的选项。使用它们来自定义您的数据，然后单击关闭并加载^{(Close & Load)}按钮以完成导入。

That’s it!

现在，您应该在电子表格中找到您的文本文件数据。

How to convert a Text (TXT/CSV) file into an Excel file

If you have a list of items in a text file and you want to import data from a text file into Microsoft Excel, you can do that without writing them manually. There is an option in Excel that allows users to import all the texts from .txt file into the spreadsheet so that users can do the job quickly.

Let’s assume that you have a product list in a Notepad or.txt file, and you need to import them in a column in an Excel spreadsheet. There are two ways to do that. First, you can manually copy and paste all the texts from the .txt file and paste it in the spreadsheet. Second, you can use the in-built option of Microsoft Excel to make it easier. The second method is convenient when you have a large number of texts that need to be imported.

How to convert a Text file into an Excel spreadsheet

Let us see how to import or export data from a Text file to convert a Text (.txt or .csv) file into an Excel (.xlsx) spreadsheet easily To import data from a text file into Microsoft Excel, follow this step by step guide-

1. Create a blank spreadsheet in Excel
2. Go to the Data tab
3. Click on From Text/CSV
4. Select text file in your computer and click the import button
5. Choose the file origin and click the Transfer Data button
6. Select which columns you want to import
7. Click the Close & Load button

Furst, create a blank spreadsheet in Microsoft Excel and make sure that you have the .txt file in your PC. After that, switch from the Home tab to the Data tab.

Here you can find an option called From Text/CSV. If you cannot find this option, go to Get Data > From File > From Text/CSV.

Then, you have to select the text file from where you want to fetch the data. After clicking the Import button, it asks you to enter the File Origin. If you have created the file, you can go with Western European (Windows) or anything that matches the origin. After doing that, click the Transfer Data button.

It will open the Power Query Editor window. From here, it is possible to choose the column that you want to keep or remove. There are two options named Choose Columns and Remove Columns.

Similarly, you can get options to save and delete rows as well. Use them to customize your data and click the Close & Load button to complete the importation.

That’s it!

Now, you should find your text file data in the spreadsheet.

Related posts

• 如何在Excel中停止或隐藏Text Overflow

• Word，Excel，Excel，Excel，Format Text，Format Text

• 如何在Excel中为您的Text添加Multiple Formatting至Cell

• 如何分割Text给Columns在Excel and Google Sheets

• 在 Excel 中将文本转换为数字的 5 种方法

• 如何修复损坏的Excel Workbook

• 如何在Excel中使用DISC function

• 如何在Excel中使用Duration Financial Function

• 如何在Excel中使用Automatic Data Type feature

• 如何在Excel中创建Organization Chart

• 如何在Microsoft Excel worksheet中添加Trendline

• 如何在Excel中使用DEC2Bin将十进制数转换为二进制数

• 如何在Excel中使用Find and FindB functions

• 如何在Excel formula中锁定单元格以保护它们

• 如何计算在Excel的Yes or No entries数

• 如何在Windows 11/10中创建Tournament Bracket

• Microsoft Excel正试图恢复您的信息

• Microsoft Excel Tutorial，用于初学者

• 如何在Excel spreadsheet中插入Dynamic Chart

• 如何在Excel创建和使用Form Controls