如何将XML转换成Excel文件

下载PDF文件
共同创作者是 Luigi Oppido

下载PDF文件

本指南介绍如何在Windows或macOS上将XML文件导入Microsoft Excel工作簿。

方法 1
方法 1 的 2:

Windows

下载PDF文件
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/4d\/Convert-XML-to-Excel-Step-1.jpg\/v4-460px-Convert-XML-to-Excel-Step-1.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/4d\/Convert-XML-to-Excel-Step-1.jpg\/v4-728px-Convert-XML-to-Excel-Step-1.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Excel位于Windows菜单的 所有应用 区域中的“Microsoft Office”分组下。
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/7\/75\/Convert-XML-to-Excel-Step-2.jpg\/v4-460px-Convert-XML-to-Excel-Step-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/75\/Convert-XML-to-Excel-Step-2.jpg\/v4-728px-Convert-XML-to-Excel-Step-2.jpg","smallWidth":460,"smallHeight":348,"bigWidth":728,"bigHeight":551,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    它位于Excel的左上角。
    • 如果使用的是Excel 2007，单击带有Microsoft Office徽标的圆形按钮。 [1]
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/a\/af\/Convert-XML-to-Excel-Step-3.jpg\/v4-460px-Convert-XML-to-Excel-Step-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/af\/Convert-XML-to-Excel-Step-3.jpg\/v4-728px-Convert-XML-to-Excel-Step-3.jpg","smallWidth":460,"smallHeight":348,"bigWidth":728,"bigHeight":551,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    随后会打开文件浏览器。
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/2\/20\/Convert-XML-to-Excel-Step-4.jpg\/v4-460px-Convert-XML-to-Excel-Step-4.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/20\/Convert-XML-to-Excel-Step-4.jpg\/v4-728px-Convert-XML-to-Excel-Step-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    根据文件的格式，可能需要更多步骤才能打开文件：
    • 如果看到“导入XML”对话框，就表示此文件至少引用了一个XSLT样式表。选择 打开该文件，不应用样式表 以使用标准格式，或选择 打开该文件，应用以下样式表 以根据样式表编排数据格式。
    • 如果看到“打开XML”对话框，选择 作为只读Excel工作簿 。
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/5\/59\/Convert-XML-to-Excel-Step-5.jpg\/v4-460px-Convert-XML-to-Excel-Step-5.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/59\/Convert-XML-to-Excel-Step-5.jpg\/v4-728px-Convert-XML-to-Excel-Step-5.jpg","smallWidth":460,"smallHeight":348,"bigWidth":728,"bigHeight":551,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/b\/bd\/Convert-XML-to-Excel-Step-6.jpg\/v4-460px-Convert-XML-to-Excel-Step-6.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/bd\/Convert-XML-to-Excel-Step-6.jpg\/v4-728px-Convert-XML-to-Excel-Step-6.jpg","smallWidth":460,"smallHeight":348,"bigWidth":728,"bigHeight":551,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  7. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/d\/da\/Convert-XML-to-Excel-Step-7.jpg\/v4-460px-Convert-XML-to-Excel-Step-7.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/da\/Convert-XML-to-Excel-Step-7.jpg\/v4-728px-Convert-XML-to-Excel-Step-7.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  8. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/a\/a8\/Convert-XML-to-Excel-Step-8.jpg\/v4-460px-Convert-XML-to-Excel-Step-8.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a8\/Convert-XML-to-Excel-Step-8.jpg\/v4-728px-Convert-XML-to-Excel-Step-8.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  9. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/8e\/Convert-XML-to-Excel-Step-9.jpg\/v4-460px-Convert-XML-to-Excel-Step-9.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/8e\/Convert-XML-to-Excel-Step-9.jpg\/v4-728px-Convert-XML-to-Excel-Step-9.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    这样就能将XML数据保存为Excel文件。
    广告
方法 2
方法 2 的 2:

macOS

下载PDF文件
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/3c\/Update-Excel-Step-8.jpg\/v4-460px-Update-Excel-Step-8.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/3c\/Update-Excel-Step-8.jpg\/v4-728px-Update-Excel-Step-8.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":544,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    它位于“应用程序”文件夹中。
    • macOS版Excel不能从其他来源导入XML数据，但可以打开XML电子表格文件。 [2]
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/3b\/Be-Politically-Correct-Step-2-Version-2.jpg\/v4-460px-Be-Politically-Correct-Step-2-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/3b\/Be-Politically-Correct-Step-2-Version-2.jpg\/v4-728px-Be-Politically-Correct-Step-2-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    它位于屏幕的顶部。 [3]
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/e\/ef\/Add-Grid-Lines-to-Your-Excel-Spreadsheet-Step-2.jpg\/v4-460px-Add-Grid-Lines-to-Your-Excel-Spreadsheet-Step-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/ef\/Add-Grid-Lines-to-Your-Excel-Spreadsheet-Step-2.jpg\/v4-728px-Add-Grid-Lines-to-Your-Excel-Spreadsheet-Step-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    随后会打开“访达”窗口。
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/c\/c5\/Convert-CSV-to-XLS-Step-5.jpg\/v4-460px-Convert-CSV-to-XLS-Step-5.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c5\/Convert-CSV-to-XLS-Step-5.jpg\/v4-728px-Convert-CSV-to-XLS-Step-5.jpg","smallWidth":460,"smallHeight":342,"bigWidth":728,"bigHeight":541,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    浏览到文件所在的文件夹，然后单击文件名。
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/81\/Pick-a-Good-Gaming-Mouse-Step-1-Version-2.jpg\/v4-460px-Pick-a-Good-Gaming-Mouse-Step-1-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/81\/Pick-a-Good-Gaming-Mouse-Step-1-Version-2.jpg\/v4-728px-Pick-a-Good-Gaming-Mouse-Step-1-Version-2.jpg","smallWidth":460,"smallHeight":334,"bigWidth":728,"bigHeight":529,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    随后会出现XML文件中的内容。
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/7\/7e\/Use-a-Computer-Mouse-Step-4-Version-2.jpg\/v4-460px-Use-a-Computer-Mouse-Step-4-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/7e\/Use-a-Computer-Mouse-Step-4-Version-2.jpg\/v4-728px-Use-a-Computer-Mouse-Step-4-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  7. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/c\/cf\/Convert-Excel-to-CSV-on-PC-or-Mac-Step-3.jpg\/v4-460px-Convert-Excel-to-CSV-on-PC-or-Mac-Step-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/cf\/Convert-Excel-to-CSV-on-PC-or-Mac-Step-3.jpg\/v4-728px-Convert-Excel-to-CSV-on-PC-or-Mac-Step-3.jpg","smallWidth":460,"smallHeight":343,"bigWidth":728,"bigHeight":543,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  8. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/a\/a8\/Use-Excel-Step-34.jpg\/v4-460px-Use-Excel-Step-34.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a8\/Use-Excel-Step-34.jpg\/v4-728px-Use-Excel-Step-34.jpg","smallWidth":460,"smallHeight":258,"bigWidth":728,"bigHeight":408,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  9. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/7\/78\/Convert-Excel-to-CSV-on-PC-or-Mac-Step-5.jpg\/v4-460px-Convert-Excel-to-CSV-on-PC-or-Mac-Step-5.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/78\/Convert-Excel-to-CSV-on-PC-or-Mac-Step-5.jpg\/v4-728px-Convert-Excel-to-CSV-on-PC-or-Mac-Step-5.jpg","smallWidth":460,"smallHeight":341,"bigWidth":728,"bigHeight":540,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  10. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/2\/2f\/Convert-Excel-to-CSV-on-PC-or-Mac-Step-7.jpg\/v4-460px-Convert-Excel-to-CSV-on-PC-or-Mac-Step-7.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/2f\/Convert-Excel-to-CSV-on-PC-or-Mac-Step-7.jpg\/v4-728px-Convert-Excel-to-CSV-on-PC-or-Mac-Step-7.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    这样就能在Mac上将XML文件保存为CSV。
    广告

你可能还喜欢

如何
取消保护Excel工作表
如何
对比两个Excel文件
如何
在EXCEL中取消隐藏行
如何
在Word中插入页码
如何
压缩PPT文件的大小
如何
在Excel中复制公式
如何
在Microsoft Excel中插入超链接
如何
在微软Word里插入超链接
如何
word文件转换为pdf文件
如何
在Word里重新排列页面
如何
在Excel中自动填充数字
如何
在Excel中创建日历
如何
将Word文档转换为PowerPoint
如何
用EXCEL创建货币转换器
广告

参考

  1. ↑ https://support.office.com/en-us/article/Import-XML-data-6eca3906-d6c9-4f0d-b911-c736da817fa4#_showdevelopertab
  2. ↑ https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_mac-mso_mac2016/import-xml/805f11b3-fead-4217-80fb-244e52c389e7
  3. ↑ https://www.techwalla.com/articles/how-to-convert-xml-to-csv-on-a-mac

关于本wikiHow

其他语言
本页面已经被访问过22,008次。

这篇文章对你有帮助吗？

广告