{"id":16752,"date":"2025-07-03T04:26:13","date_gmt":"2025-07-03T04:26:13","guid":{"rendered":"http:\/\/www.withdata.com\/blog\/?p=16752"},"modified":"2026-07-24T05:37:02","modified_gmt":"2026-07-24T05:37:02","slug":"excel-sheets-to-separate-csv","status":"publish","type":"post","link":"https:\/\/www.withdata.com\/blog\/datafileconverter\/excel-sheets-to-separate-csv.html","title":{"rendered":"Convert each sheet in an Excel file to a separate CSV file"},"content":{"rendered":"<p>Want to convert each sheet data in an Excel file to a separate CSV 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 CSV converter for Windows, MacOS, and Linux, Batch convert Excel sheets to CSV, 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 CSV file<\/h2>\n<p><a href=\"#source\">Select source Excel file<\/a> -> <a href=\"#target\">Set target CSV file<\/a> -> <a href=\"#do\">Convert Excel sheet to CSV 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 CSV 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;CSV&#8221;.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/datafileconverter\/type-sheets-to-csv.png\" alt=\"extract each sheet data in an Excel file to a separate CSV 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 CSV 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 CSV 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 CSV files.<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/datafileconverter\/target-folder-csv.png\" alt=\"bulk extract each sheet data in an Excel file to a separate CSV file - config CSV 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 CSV 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 CSV 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 CSV file.<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/datafileconverter\/convert-excel-sheets-to-csv-files.png\" alt=\"convert each sheet data in an Excel file to a separate CSV 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 CSV files.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/datafileconverter\/wizard_view_csv.png\" alt=\"convert each sheet data in an Excel file to a separate CSV file - view CSV 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 CSV 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 CSV&#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 CSV 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 CSV 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 CSV 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 CSV file<\/h2>\n<p>You can schedule and automate this Excel sheet to CSV 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 CSV&#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 CSV&#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 CSV 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 CSV 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 CSV file using DataFileConverter?<\/a><\/div>\n<div id=\"a2\" style=\"display: none;\">Of course! DataFileConverter convert each Excel sheet to a separate CSV file locally, absolutely safe.<\/div>\n<div><a href=\"#faq\" onclick=\"a3.style.display = 'block';\">Can I convert each Excel sheet to a separate CSV 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 CSV 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-csv\">Excel sheets to CSV 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-csv-files\">Video: Convert each worksheet in an Excel file to a separate CSV 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 CSV file at one time? Try Withdata Data File Converter, an Excel to CSV converter for Windows, MacOS, and Linux, Batch convert Excel sheets to CSV, 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,34,15],"class_list":["post-16752","post","type-post","status-publish","format-standard","hentry","category-datafileconverter","tag-convert-file-format","tag-csv","tag-excel"],"_links":{"self":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/16752","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=16752"}],"version-history":[{"count":8,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/16752\/revisions"}],"predecessor-version":[{"id":45033,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/16752\/revisions\/45033"}],"wp:attachment":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/media?parent=16752"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/categories?post=16752"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/tags?post=16752"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}