csv文件转word_如何将Microsoft Word文档更改为CSV文件

csv文件转word

A Comma Separated Value (CSV) contains data separated by commas (and sometimes other characters) and is generally used to exchange data from one application to another. If you have a list of data in a Word document, converting it to a CSV file can help you get it into other apps.

逗号分隔值(CSV)包含用逗号(有时还有其他字符)分隔的数据，通常用于将数据从一个应用程序交换到另一个应用程序。 如果您在Word文档中有数据列表，则将其转换为CSV文件可以帮助您将其导入其他应用程序。

Let’s say you’ve been keeping all of your email contacts organized in a Word file and you’d like to let an online application clean it up for you. You’re likely going to need a CSV file to achieve this. In fact, several of these applications you’d find online may only support CSV files because the file works across the Mac, Windows, and Linux platforms. Pretty efficient.

假设您一直将所有电子邮件联系人组织在一个Word文件中，并且希望让在线应用程序为您进行清理。 您可能需要一个CSV文件才能实现此目的。 实际上，您在网上找到的其中一些应用程序可能仅支持CSV文件，因为该文件可在Mac，Windows和Linux平台上运行。 非常有效。

Go ahead and open the Word file that contains the data to be imported. In this example, we’re going to be showing a very small email list.

继续并打开包含要导入的数据的Word文件。 在此示例中，我们将显示一个非常小的电子邮件列表。

As you can see, all of our data is separated by commas and are on separate lines, similar to the row/column structure you’d find in Excel. The structure of a CSV file can get a bit complicated, but this is a very basic example.

如您所见，我们所有的数据都以逗号分隔并且位于单独的行上，类似于您在Excel中可以找到的行/列结构。 CSV文件的结构可能会有些复杂，但这是一个非常基本的示例。

Once you’re ready, click the “File” tab located at the top-left of the window.

准备就绪后，单击窗口左上方的“文件”选项卡。

In the pane on the left-hand side, select “Save As.”

在左侧窗格中，选择“另存为”。

Select the “Plain Text” file type from the list of options. This will save your file as a TXT file. Click “Save.”

从选项列表中选择“纯文本”文件类型。 这会将您的文件另存为TXT文件。 点击“保存”。

Once you save, you will receive a warning message stating that saving as a text file will cause formatting, pictures, and objects in your file to be lost. With a simple file such as this, we have nothing to worry about. Leave everything as is and click “OK.”

保存后，您将收到一条警告消息，指出另存为文本文件将导致文件中的格式，图片和对象丢失。 使用这样的简单文件，我们无需担心。 保留所有内容，然后单击“确定”。

Now, let’s open up Microsoft Excel. When you open Excel, select “Open” in the left-hand pane.

现在，让我们打开Microsoft Excel。 打开Excel时，在左侧窗格中选择“打开”。

Locate the recent file that we saved as a TXT file. Note that you might have to select “Text File” from the file option type drop-down when browsing or else the file will not appear. By default, Excel will only show Excel files.

找到我们另存为TXT文件的最新文件。 请注意，浏览时可能必须从文件选项类型下拉菜单中选择“文本文件”，否则该文件将不会显示。 默认情况下，Excel仅显示Excel文件。

Once you’ve selected the file and clicked “Open,” the Text Import Wizard window will appear. Here, make sure that the “Delimited” option is selected. You can also choose the row at which your data begins. We will keep ours on the first row. When you’re ready, click “Next.”

选择文件并单击“打开”后，将出现“文本导入向导”窗口。 在此，请确保已选择“分隔”选项。 您也可以选择数据开始的行。 我们将保持第一行。 准备就绪后，单击“下一步”。

In the next window, make sure you select “Comma” in the Delimiters section. You’ll notice a change in the preview window. When you’re ready, click “Next.”

在下一个窗口中，确保在“定界符”部分中选择“逗号”。 您会在预览窗口中看到一个变化。 准备就绪后，单击“下一步”。

In the final window, you’ll need to specify the column data format. We’ll leave ours at “General,” but depending on what type of data you’re importing, you might want to choose a different option. When you’re ready, click “Finish.”

在最后一个窗口中，您需要指定列数据格式。 我们将其保留为“常规”，但是根据您要导入的数据类型，您可能需要选择其他选项。 准备好后，点击“完成”。

Our data should now be successfully imported and neatly organized in Excel!

现在，我们的数据应该已成功导入，并在Excel中整齐地组织了！

Now all that’s left is to save the file as a CSV file. Head over to the “File” tab.

现在剩下的就是将文件另存为CSV文件。 转到“文件”标签。

Select “Save As” in the left-hand pane.

在左侧窗格中选择“另存为”。

In the file type box, you’ve probably noticed there are three different types of CSV files. They are as follows:

在“文件类型”框中，您可能已经注意到了三种不同类型的CSV文件。 它们如下：

• CSV UTF-8
  CSV UTF-8
• CSV (Macintosh)
  CSV(Macintosh)
• CSV (MS-DOS)
  CSV(MS-DOS)

There is very little difference between the first and third option. You’ll want to select the second option if you’re a Mac user. In this example, though, we’ll be selecting the “CSV (MS-DOS)” option.

第一种和第三种选择之间几乎没有什么区别。 如果您是Mac用户，则需要选择第二个选项。 但是，在此示例中，我们将选择“ CSV(MS-DOS)”选项。

Now all that’s left to do is click “Save.” You’ve now successfully converted your Word file to a CSV file.

现在剩下要做的就是单击“保存”。 现在，您已成功将Word文件转换为CSV文件。

翻译自: https://www.howtogeek.com/407243/how-to-change-a-word-file-to-a-comma-delimited-file/

csv文件转word