{"id":10378,"date":"2022-05-10T05:19:28","date_gmt":"2022-05-10T05:19:28","guid":{"rendered":"http:\/\/www.withdata.com\/blog\/?p=10378"},"modified":"2022-05-10T05:19:28","modified_gmt":"2022-05-10T05:19:28","slug":"importexport-mongodb-data-fromto-files-without-programming","status":"publish","type":"post","link":"https:\/\/www.withdata.com\/blog\/mongoloader\/importexport-mongodb-data-fromto-files-without-programming.html","title":{"rendered":"Import\/Export MongoDB data from\/to files without programming"},"content":{"rendered":"<p>Want to load\/unload <a href=\"https:\/\/www.mongodb.com\/\">MongoDB<\/a> data from\/to files?<\/p>\n<p>Using <a href=\"https:\/\/www.withdata.com\/mongo-loader\/\">MongoLoader<\/a>, you can load\/unload MongoDB data from\/to files easily and fast, just a few mouse clicks!<\/p>\n<p>You can import data from multiple types of file, such as TXT, CSV, TSV, Excel, JSON, XML, RDF,  etc.<\/p>\n<p>You can export data to multiple types of file, such as SQL, TXT, CSV, TSV, Excel, JSON, XML, HTML, etc.<\/p>\n<p>Support all MongoDB deployment types: standalone, replica set, sharded cluster, and <a href=\"https:\/\/www.mongodb.com\/atlas\">MongoDB Atlas<\/a>.<\/p>\n<p>Support Windows, Linux, macOS<\/p>\n<p>Here you can <a href=\"https:\/\/www.withdata.com\/mongo-loader\/download.html\">download<\/a> and install <a href=\"https:\/\/www.withdata.com\/mongo-loader\/\">MongoLoader<\/a>.<\/p>\n<h2>Import\/Export MongoDB data from\/to files<\/h2>\n<p><b>Import<\/b>, you can import<\/p>\n<ul>\n<li>1 File To 1 Collection<\/li>\n<li>N Files To 1 Collection<\/li>\n<li>N Files To N Collections<\/li>\n<\/ul>\n<p>For example, import N TXT Files To N Collections<\/p>\n<p><p> Click &#8220;N File To N Collection&#8221; at task dialog.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/mongo-loader\/wizard-task.png\" ALT=\"load\/unload MongoDB data - task window\" width=\"819\" height=\"542\" style=\"max-width:100%;height:auto;display:block;\"><\/p>\n<p>then show the wizard.<\/p>\n<p>1. Select import file type.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/filetomongo\/wizard_type_txt.png\" alt=\"Batch Import TXT files data To MongoDB collections - select file type\" width=\"547\" height=\"236\" style=\"max-width:100%;height:auto;display:block;\" \/><\/p>\n<p>2. Set a folder contains TXT files.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/filetomongo\/wizard-import-nton-txt.png\" ALT=\"Batch Import Data From TXT Files To MongoDB collections - set TXT folder\" width=\"722\" height=\"572\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\"><\/p>\n<p>3. Config TXT file.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/filetomongo\/wizard-import-nton-config-txt.png\" ALT=\"Batch Import Data From TXT Files To MongoDB collections - config TXT file\" width=\"722\" height=\"572\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\"><\/p>\n<p>4. List collesions.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/filetomongo\/wizard-import-list-collections.png\" ALT=\"Batch Load Data From TXT File To MongoDB collections - select table\" width=\"722\" height=\"572\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\"><\/p>\n<p>5. Map files to collections.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/filetomongo\/wizard-import-map-txt.png\" ALT=\"Batch Load Data From TXT File To MongoDB collections - select table\" width=\"722\" height=\"572\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\"><\/p>\n<p>6. Summary.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/filetomongo\/wizard-import-preview-nton.png\" ALT=\"Batch Transfer Data From TXT Files To MongoDB collections - preview\" width=\"722\" height=\"572\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\"><\/p>\n<p>7. Import.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/filetomongo\/wizard-import-convert-nton-txt.png\" ALT=\"Batch Copy Data From TXT Files To MongoDB collections - import data\" width=\"722\" height=\"572\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\"><\/p>\n<p><b>Export<\/b>, you can<\/p>\n<ul>\n<li>Export From Collection<\/li>\n<li>Export From Query<\/li>\n<li>Export All Collections<\/li>\n<li>Export Similar Collections<\/li>\n<\/ul>\n<p>For example, export Collections to Excel files<\/p>\n<p><p>Click &#8220;Export All Collections&#8221; at task dialog.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/mongo-loader\/wizard-task.png\" ALT=\"load\/unload MongoDB data - task window\" width=\"819\" height=\"542\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\"><\/p>\n<p>then show the wizard.<\/p>\n<p>1. Select export file type.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/mongotofile\/wizard_type_excel.png\" alt=\"Batch export MongoDB collections to Excel files - select type\" width=\"529\" height=\"189\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<p>2. See MongoDB collections.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/mongotofile\/wizard_source_list_collections.png\" alt=\"Batch extract MongoDB collections to Excel files - select a collections\" width=\"722\" height=\"572\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<p>3. Config target files.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/mongotofile\/wizard_target_folder_excel.png\" alt=\"Batch dump MongoDB collections to Excel files - config Excel files\" width=\"722\" height=\"572\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<p>4. Select collections.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/mongotofile\/wizard_select_collections.png\" alt=\"Batch unload MongoDB collections to Excel files - select collections\" width=\"722\" height=\"572\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<p>5. Summary.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/mongotofile\/wizard_summary_collections.png\" alt=\"Batch convert MongoDB collections to Excel files - summary\" width=\"722\" height=\"572\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<p>6. Convert.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/mongotofile\/wizard_convert_collections_to_excel.png\" alt=\"Batch export MongoDB collections to Excel files - convert files\" width=\"722\" height=\"572\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<p>You can schedule and automate this converting task by: <\/p>\n<p><p><a href=\"https:\/\/withdata.com\/mongo-loader\/cmd.html\" target=\"_blank\">1) Save session and create .bat file.<\/a><\/p>\n<p><a href=\"https:\/\/withdata.com\/dbtodb\/schedule-task.html\" target=\"_blank\">2) Set scheduled task.<\/a><\/p>\n<hr style=\"clear: both;\" \/>\n<p><a href=\"https:\/\/www.withdata.com\/mongo-loader\/\">More about MongoLoader &#8211; the tool to load\/unload MongoDB data to files<\/a><\/p>\n<div style=\"clear: both;\">\n<p>30-day free trial <a href=\"https:\/\/www.withdata.com\/mongo-loader\/download.html\"><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/btn_download_green.png\" alt=\"Download MongoLoader\" width=\"165\" height=\"50\" style=\"max-width:100%;height:auto;\" loading=\"lazy\" decoding=\"async\" \/><\/a>US$95.0 <a href=\"https:\/\/www.withdata.com\/mongo-loader\/purchase.html\"><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/btn_buynow_green.png\" alt=\"Buy MongoLoader\" width=\"154\" height=\"45\" style=\"max-width:100%;height:auto;\" loading=\"lazy\" decoding=\"async\" \/> <\/a><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Want to load\/unload MongoDB data from\/to files? Using MongoLoader, you can load\/unload MongoDB data from\/to files easily and fast, just a few mouse clicks! You can import data from multiple types of file, such as TXT, CSV, TSV, Excel, JSON, XML, RDF, etc. You can export data to multiple types of file, such as SQL, [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2764],"tags":[1440,1910,1706,2762,2763],"class_list":["post-10378","post","type-post","status-publish","format-standard","hentry","category-mongoloader","tag-mongodb","tag-mongodb-export","tag-mongodb-import","tag-mongodb-load","tag-mongodb-unload"],"_links":{"self":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/10378","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=10378"}],"version-history":[{"count":1,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/10378\/revisions"}],"predecessor-version":[{"id":10379,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/10378\/revisions\/10379"}],"wp:attachment":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/media?parent=10378"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/categories?post=10378"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/tags?post=10378"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}