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