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