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