{"id":16756,"date":"2025-07-03T04:26:17","date_gmt":"2025-07-03T04:26:17","guid":{"rendered":"http:\/\/www.withdata.com\/blog\/?p=16756"},"modified":"2026-07-24T05:58:35","modified_gmt":"2026-07-24T05:58:35","slug":"excel-sheets-to-separate-xml","status":"publish","type":"post","link":"https:\/\/www.withdata.com\/blog\/datafileconverter\/excel-sheets-to-separate-xml.html","title":{"rendered":"Convert each sheet in an Excel file to a separate XML file"},"content":{"rendered":"<p>Want to convert each sheet data in an Excel file to a separate XML file at one time?<\/p>\n<p>Try Withdata <a href=\"https:\/\/www.withdata.com\/data-file-converter\/\">Data File Converter<\/a>, an Excel to XML converter for Windows, MacOS, and Linux, Batch convert Excel sheets to XML, Easy and Fast.<\/p>\n<ul>\n<li>Can run in GUI mode, <a href=\"#convert\">Step by Step<\/a>, just a few mouse clicks.<\/li>\n<li>Can run in <a href=\"#cmd\">Command line<\/a>, for <a href=\"#task\">Scheduled Tasks<\/a> and Streams.<\/li>\n<li>Convert files locally and <b>privately<\/b>, avoid uploading large Excel file(s) to online services.<\/li>\n<\/ul>\n<p><a href=\"#download-top\" onclick=\"dtv.style.display = 'block';\">Download Withdata DataFileConverter<\/a>  <a href=\"#download-top\" onclick=\"dtv.style.display = 'block';\"><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/download_3.jpg\" alt=\"Download DataFileConverter\" width=\"80\" height=\"22\" style=\"max-width:100%;height:auto;\" \/><\/a> <span id=\"dtv\" style=\"display: none;\"><br \/>\n<a href=\"\/download.php?app=DataFileConverter&#038;ver=win64\">Windows 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=DataFileConverter&#038;ver=win32\">Windows 32 bit<\/a><br \/>\n<a href=\"\/download.php?app=DataFileConverter&#038;ver=deb\">Linux .deb (For Debian, Ubuntu) 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=DataFileConverter&#038;ver=rpm\">Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=DataFileConverter&#038;ver=pkg\">MacOS 64 bit<\/a><br \/>\n<\/span><\/p>\n<h2 id=\"convert\">Convert each sheet data in an Excel file to a separate XML file<\/h2>\n<p><a href=\"#source\">Select source Excel file<\/a> -> <a href=\"#target\">Set target XML file<\/a> -> <a href=\"#do\">Convert Excel sheet to XML file<\/a><\/p>\n<p>Click &#8220;Start a New Convert&#8221; at task dialog.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/datafileconverter\/wizard_task.png\" alt=\"batch convert each sheet data in an Excel file to a separate XML file - task window\" width=\"468\" height=\"220\" style=\"max-width:100%;height:auto;display:block;\" \/><\/p>\n<p>then show the wizard.<\/p>\n<p>Select From &#8220;File&#8221; &#8220;Excel&#8221; To &#8220;Files&#8221; &#8220;XML&#8221;.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/datafileconverter\/type-sheets-to-xml.png\" alt=\"extract each sheet data in an Excel file to a separate XML file - select type\" width=\"615\" height=\"415\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<h3 id=\"source\">1. Open a source Excel file, select sheets to convert to XML files.<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/datafileconverter\/source-excel-sheets.png\" alt=\"bulk convert each sheet data in an Excel file to a separate XML file - select Excel file\" width=\"722\" height=\"572\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<h3 id=\"target\">2. Config target XML files.<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/datafileconverter\/target-folder-xml.png\" alt=\"bulk extract each sheet data in an Excel file to a separate XML file - config XML files\" width=\"722\" height=\"572\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<h3>3. Summary.<\/h3>\n<p>List selected sheets.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/datafileconverter\/list-source-sheets.png\" alt=\"transform each sheet data in an Excel file to a separate XML file - list sheets\" width=\"722\" height=\"572\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<p><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/datafileconverter\/summary-source-sheets.png\" alt=\"convert each sheet data in an Excel file to a separate XML file - summary\" width=\"722\" height=\"572\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<h3 id=\"do\">4. Convert each Excel sheet to a separate XML file.<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/datafileconverter\/convert-excel-sheets-to-xml-files.png\" alt=\"convert each sheet data in an Excel file to a separate XML file - convert\" width=\"722\" height=\"572\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<p>After converting, you can view output XML files.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/datafileconverter\/wizard_view_xml.png\" alt=\"convert each sheet data in an Excel file to a separate XML file - view XML file\" width=\"722\" height=\"572\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<h2 id=\"cmd\">Convert each Excel sheet to a separate XML file in command line<\/h2>\n<p><a href=\"https:\/\/www.withdata.com\/data-file-converter\/cmd.html\" target=\"_blank\">Save &#8220;SQL table to XML&#8221; session<\/a>, then you can: <\/p>\n<ul>\n<li><a href=\"https:\/\/www.withdata.com\/data-file-converter\/cmd.html#windows\" target=\"_blank\">Convert each Excel sheet to a separate XML file in Windows command line.<\/a><\/li>\n<li><a href=\"https:\/\/www.withdata.com\/data-file-converter\/cmd.html#linux\" target=\"_blank\">Convert each Excel sheet to a separate XML file in Linux command line.<\/a><\/li>\n<li><a href=\"https:\/\/www.withdata.com\/data-file-converter\/cmd.html#macos\" target=\"_blank\">Convert each Excel sheet to a separate XML file in macOS command line.<\/a><\/li>\n<\/ul>\n<h2 id=\"task\">Set scheduled tasks for converting each Excel sheet data to a separate XML file<\/h2>\n<p>You can schedule and automate this Excel sheet to XML converting task by: <\/p>\n<ol>\n<li><a href=\"https:\/\/withdata.com\/data-file-converter\/cmd.html\" target=\"_blank\">Save session and create .bat (Windows) or .sh (Linux\/macOS) file for &#8220;Excel sheet to XML&#8221; conversion.<\/a><\/li>\n<li><a href=\"https:\/\/withdata.com\/dbtodb\/schedule-task.html\" target=\"_blank\">Set scheduled task for &#8220;Excel sheet to XML&#8221; conversion.<\/a><\/li>\n<\/ol>\n<h2 id=\"faq\">FAQ<\/h2>\n<div><a href=\"#faq\" onclick=\"a0.style.display = 'block';\">What is Withdata DataFileConverter?<\/a><\/div>\n<div id=\"a0\" style=\"display: none;\">Withdata DataFileConverter is a data file converter, it can convert each Excel sheet to a separate XML file. <a href=\"https:\/\/www.withdata.com\/data-file-converter\/download.html\">Download Withdata DataFileConverter<\/a><\/div>\n<div><a href=\"#faq\" onclick=\"a1.style.display = 'block';\">How long does it take to convert each Excel sheet to a separate XML file?<\/a><\/div>\n<div id=\"a1\" style=\"display: none;\">DataFileConverter works fast. It convert millions of rows within a minute.<\/div>\n<div><a href=\"#faq\" onclick=\"a2.style.display = 'block';\">Is it safe to convert each Excel sheet to a separate XML file using DataFileConverter?<\/a><\/div>\n<div id=\"a2\" style=\"display: none;\">Of course! DataFileConverter convert each Excel sheet to a separate XML file locally, absolutely safe.<\/div>\n<div><a href=\"#faq\" onclick=\"a3.style.display = 'block';\">Can I convert each Excel sheet to a separate XML file on Linux, Mac OS?<\/a><\/div>\n<div id=\"a3\" style=\"display: none;\">Yes, you can. DataFileConverter has Linux, Mac OS, and Windows version.<\/div>\n<div><a href=\"#faq\" onclick=\"a4.style.display = 'block';\">Can I convert each Excel sheet to a separate XML file in command line?<\/a><\/div>\n<div id=\"a4\" style=\"display: none;\">Yes, you can. DataFileConverter can running in command line, on Linux, Mac OS, and Windows.<\/div>\n<hr style=\"clear: both;\" \/>\n<p><a href=\"https:\/\/www.withdata.com\/data-file-converter\/\">More about Withdata DataFileConverter<\/a> &#8211; <a href=\"https:\/\/www.withdata.com\/blog\/tag\/each-excel-sheets-to-xml\">Excel sheets to XML converter<\/a><\/p>\n<div id=\"download-bottom\" style=\"clear: both;\">\n<p>Download Withdata DataFileConverter<a href=\"#download-bottom\" onclick=\"dbv.style.display = 'block';\"><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/btn_download_green.png\" alt=\"Download DataFileConverter\" width=\"165\" height=\"50\" style=\"max-width:100%;height:auto;\" loading=\"lazy\" decoding=\"async\" \/><\/a> <span id=\"dbv\" style=\"display: none;\"><br \/>\n<a href=\"\/download.php?app=DataFileConverter&#038;ver=win64\">Windows 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=DataFileConverter&#038;ver=win32\">Windows 32 bit<\/a><br \/>\n<a href=\"\/download.php?app=DataFileConverter&#038;ver=deb\">Linux .deb (For Debian, Ubuntu) 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=DataFileConverter&#038;ver=rpm\">Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=DataFileConverter&#038;ver=pkg\">MacOS 64 bit<\/a><br \/>\n<\/span><\/p>\n<\/div>\n<p>See <a href=\"https:\/\/www.withdata.com\/videos\/data-file-converter\/sheets-to-xml-files\">Video: Convert each worksheet in an Excel file to a separate XML file at one time<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Want to convert each sheet data in an Excel file to a separate XML file at one time? Try Withdata Data File Converter, an Excel to XML converter for Windows, MacOS, and Linux, Batch convert Excel sheets to XML, Easy and Fast. Can run in GUI mode, Step by Step, just a few mouse clicks. [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1477],"tags":[13308,15,68],"class_list":["post-16756","post","type-post","status-publish","format-standard","hentry","category-datafileconverter","tag-convert-file-format","tag-excel","tag-xml"],"_links":{"self":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/16756","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/comments?post=16756"}],"version-history":[{"count":8,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/16756\/revisions"}],"predecessor-version":[{"id":45035,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/16756\/revisions\/45035"}],"wp:attachment":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/media?parent=16756"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/categories?post=16756"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/tags?post=16756"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}