excel 导出工作表名称_如何将联系人从Excel工作表导出到Outlook

excel 导出工作表名称

Contact details stored in an Excel Worksheet can be easily exported and then imported into Outlook. Once the Excel file is saved to a CSV format, you can import it into your Outlook contacts list.

可以轻松导出存储在Excel工作表中的详细联系信息，然后将其导入Outlook。 将Excel文件保存为CSV格式后，您可以将其导入到Outlook联系人列表中。

将联系人另存为CSV文件 (Save Your Contacts as a CSV File)

The contacts list below is stored in an Excel worksheet. Ensure your Excel spreadsheet is labeled in a similar fashion.

下面的联系人列表存储在Excel工作表中。 确保以类似的方式标记Excel电子表格。

To export the document as a CSV, first click “File” to open the menu. Next, select Save As > Browse.

要将文档导出为CSV，请首先单击“文件”以打开菜单。 接下来，选择另存为>浏览。

Specify the location for the saved file on your computer and then select “CSV (Comma Delimited)” from the Save as Type list. Click the “Save” button.

指定计算机上已保存文件的位置，然后从“另存为类型”列表中选择“ CSV(逗号分隔)”。 点击“保存”按钮。

Close the Excel workbook. The contacts are ready to be imported into Outlook.

关闭Excel工作簿。 联系人已准备好导入Outlook。

将联系人从CSV文件导入Outlook (Import Contacts from a CSV File into Outlook)

Open Outlook and then click on “File” to open the menu. From there, select Open & Export > Import/Export.

打开Outlook，然后单击“文件”以打开菜单。 在此处，选择打开和导出>导入/导出。

Select “Import from Another Program or File” and then click the “Next” button.

选择“从另一个程序或文件导入”，然后单击“下一步”按钮。

Highlight the “Comma Separated Values” option and then click the “Next” button.

突出显示“逗号分隔值”选项，然后单击“下一步”按钮。

Select the “Browse” button to find the CSV file you want to import.

选择“浏览”按钮以找到要导入的CSV文件。

Choose an option for how you would like Outlook to handle duplicate contact details and click the “Next” button.

选择一个选项，使您希望Outlook处理重复的联系人详细信息，然后单击“下一步”按钮。

In this example, “Replace Duplicates with Items Imported” is selected. This will update the existing contacts in Outlook with the latest contact details.

在此示例中，选择了“用导入的项目替换重复项”。 这将使用最新的联系人详细信息更新Outlook中的现有联系人。

Select the destination folder for the imported contacts and then click the “Next” button. The destination folder will probably be the Contacts folder, but it could be a different folder that can store contact details.

选择导入的联系人的目标文件夹，然后单击“下一步”按钮。 目标文件夹可能是“联系人”文件夹，但可能是可以存储联系人详细信息的其他文件夹。

Ensure that the action to import your contacts list into Outlook is selected.

确保已选择将联系人列表导入Outlook的操作。

Click the “Map Custom Fields” button. This will enable us to correctly match up the column headers from the Excel spreadsheet to the corresponding fields in Outlook.

点击“地图自定义字段”按钮。 这将使我们能够正确地将Excel电子表格中的列标题与Outlook中的相应字段进行匹配。

In the Map Custom Fields Window, the fields from the CSV file appear in the “From” pane on the left. In the “To” pane on the right, the fields from the Contacts folder in Outlook are shown.

在“地图自定义字段”窗口中，来自CSV文件的字段显示在左侧的“从”窗格中。 在右侧的“收件人”窗格中，显示了Outlook中“联系人”文件夹中的字段。

Any fields that have already been successfully matched are listed under the “Mapped From” column on the right.

右侧“映射自”列下方列出了已成功匹配的所有字段。

The Email Address field was not matched. To fix this, click and drag the Email Address field from the left to the right. Doing so will map the field. Click the “OK” button to proceed.

电子邮件地址字段不匹配。 要解决此问题，请单击并将电子邮件地址字段从左向右拖动。 这样做将映射该字段。 单击“确定”按钮继续。

A window might appear to show the import progress.

可能会出现一个窗口，显示导入进度。

The contacts should now have been successfully imported into Outlook.

联系人现在应该已经成功导入到Outlook中。

翻译自: https://www.howtogeek.com/442861/how-to-export-contacts-from-an-excel-worksheet-to-outlook/

excel 导出工作表名称