{"id":14275,"date":"2025-08-16T02:36:41","date_gmt":"2025-08-16T02:36:41","guid":{"rendered":"http:\/\/www.withdata.com\/blog\/?p=14275"},"modified":"2025-08-16T03:36:40","modified_gmt":"2025-08-16T03:36:40","slug":"batch-import-excel-files-to-redis-hash-keys-in-a-namespace","status":"publish","type":"post","link":"https:\/\/www.withdata.com\/blog\/redisdatastudio\/batch-import-excel-files-to-redis-hash-keys-in-a-namespace.html","title":{"rendered":"Batch import data from excel files to Redis hash keys in same namespace without programming"},"content":{"rendered":"<p>Want to batch import Excel files into Redis hash keys in same namespace without programming?<\/p>\n<p>Using Withdata <a href=\"https:\/\/www.withdata.com\/redis-data-studio\/\">Redis Data Studio<\/a>, a desktop Excel importer for Redis, you can batch import  <a href=\"https:\/\/products.office.com\/excel\">Excel<\/a>  files into Redis namespaced hash keys (key name contains &#8216;:&#8217;) easily and fast, no need to program.<\/p>\n<ul>\n<li>Can run in <span id=\"gui\">GUI<\/span> mode, <a href=\"#import\">Step by Step<\/a>, just a few mouse clicks.<\/li>\n<li>Can run in <a href=\"\/tools\/file-to-redis\/excel-to-redis-cmd\" target=\"_blank\">Command line<\/a>, for <a href=\"\/tools\/file-to-redis\/excel-to-redis-task\" target=\"_blank\">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<li>Support <a href=\"\/tools\/file-to-redis\/excel-to-redis-windows\" target=\"_blank\">Windows<\/a>, <a href=\"\/tools\/file-to-redis\/excel-to-redis-linux\" target=\"_blank\">Linux<\/a>, and <a href=\"\/tools\/file-to-redis\/excel-to-redis-macos\" target=\"_blank\">macOS<\/a>.<\/li>\n<\/ul>\n<p><a href=\"#download-top\" onclick=\"dtv.style.display = 'block';\">Download Withdata RedisDataStudio<\/a>  <a href=\"#download-top\" onclick=\"dtv.style.display = 'block';\"><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/download_3.jpg\" alt=\"Download RedisDataStudio\" width=\"80\" height=\"22\" style=\"max-width:100%;height:auto;\" \/><\/a> <span id=\"dtv\" style=\"display: none;\"><br \/>\n<a href=\"\/download.php?app=RedisDataStudio&#038;ver=win64\">Windows 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=RedisDataStudio&#038;ver=win32\">Windows 32 bit<\/a><br \/>\n<a href=\"\/download.php?app=RedisDataStudio&#038;ver=deb\">Linux .deb (For Debian, Ubuntu) 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=RedisDataStudio&#038;ver=rpm\">Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=RedisDataStudio&#038;ver=pkg\">MacOS 64 bit<\/a><br \/>\n<\/span><\/p>\n<h2 id=\"example\">Example of bulk importing Excel files into Redis hash keys in same namespace<\/h2>\n<p>Source Excel file folder<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/redisdatastudio\/source_nto1_excel.png\" alt=\"Batch import Excel file into hash keys in same namespace - source Excel folder\" width=\"339\" height=\"182\" style=\"max-width:100%;height:auto;display:block;\" \/><\/p>\n<p>An example Excel file in this folder<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/redisdatastudio\/excel_files_to_1_hash_key_source_file.png\" alt=\"Batch import Excel file into hash keys in same namespace - view a source Excel file\" width=\"772\" height=\"560\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<p>After importing, you can view data in Redis hash keys.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/redisdatastudio\/x_files_to_hash_namespace_view.png\" alt=\"Import Excel file into Redis hash keys in same namespace - view hash keys\" width=\"956\" height=\"699\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<h2 id=\"import\">Import Excel files into Redis hash keys in same namespace<\/h2>\n<p><a href=\"#source\">Choose Excel files<\/a> -> <a href=\"#target\">Set Redis hash keys namespace<\/a> -> <a href=\"#do\">Import Excel to Redis<\/a><\/p>\n<p> Click &#8220;Import From File&#8221; at task dialog.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/redisdatastudio\/wizard-task.png\" ALT=\"Batch import Excel files into Redis hash keys in same namespace - task window\" width=\"844\" height=\"543\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\"><\/p>\n<p> Choose &#8220;Files&#8221;, &#8220;Excel&#8221;, &#8220;Namespace Keys&#8221;, &#8220;Hash&#8221;.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/redisdatastudio\/excel_files_to_hash_namespace_types.png\" alt=\"Batch import Excel files into Redis hash keys in same namespace - choose types\" width=\"677\" height=\"358\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<p id=\"source\">1. Open source Excel file file folder.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/redisdatastudio\/excel_files_to_hash_namespace_source_folder.png\" alt=\"Batch import Excel files into Redis hash keys in same namespace - source Excel file folder\" width=\"724\" height=\"573\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<p>2. Config first source Excel file.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/redisdatastudio\/excel_files_to_hash_namespace_first.png\" alt=\"Batch import Excel files into Redis hash keys in same namespace - config first source Excel file\" width=\"724\" height=\"573\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<p id=\"target\">3. Config destination hash keys namespace.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/redisdatastudio\/x_files_to_hash_namespace_destination.png\" alt=\"Batch import Excel files into Redis hash keys in same namespace - config destination hash keys namespace\" width=\"724\" height=\"573\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<p>4. Summary.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/redisdatastudio\/x_files_to_hash_namespace_summary.png\" alt=\"Batch import Excel files into Redis hash keys in same namespace - summary\" width=\"724\" height=\"573\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<p id=\"do\">5. Batch import Excel files into Redis hash keys in same namespace.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/redisdatastudio\/excel_files_to_hash_namespace_import.png\" alt=\"Batch import Excel files into Redis hash keys in same namespace - import file\" width=\"724\" height=\"573\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<p>After importing, you can view data in hash keys.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/redisdatastudio\/x_files_to_hash_namespace_view.png\" alt=\"Batch import Excel files into Redis hash keys in same namespace - view key\" width=\"956\" height=\"699\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<hr style=\"clear: both;\" \/>\n<p>More about <a href=\"\/tools\/file-to-redis\/excel-to-redis\">Excel to Redis Converter<\/a><\/p>\n<div id=\"download-bottom\" style=\"clear: both;\">\n<p>Download Withdata RedisDataStudio<a href=\"#download-bottom\" onclick=\"dbv.style.display = 'block';\"><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/btn_download_green.png\" alt=\"Download RedisDataStudio\" 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=RedisDataStudio&#038;ver=win64\">Windows 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=RedisDataStudio&#038;ver=win32\">Windows 32 bit<\/a><br \/>\n<a href=\"\/download.php?app=RedisDataStudio&#038;ver=deb\">Linux .deb (For Debian, Ubuntu) 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=RedisDataStudio&#038;ver=rpm\">Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=RedisDataStudio&#038;ver=pkg\">MacOS 64 bit<\/a><br \/>\n<\/span><\/p>\n<\/div>\n<p>See <a href=\"https:\/\/www.withdata.com\/videos\/redis-data-studio\/excel-files-to-hash-namespace\">Video: Batch import data from EXCEL files to Redis hash keys in same namespace<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Want to batch import Excel files into Redis hash keys in same namespace without programming? Using Withdata Redis Data Studio, a desktop Excel importer for Redis, you can batch import Excel files into Redis namespaced hash keys (key name contains &#8216;:&#8217;) easily and fast, no need to program. Can run in GUI mode, Step by [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3136],"tags":[15,4181,3134],"class_list":["post-14275","post","type-post","status-publish","format-standard","hentry","category-redisdatastudio","tag-excel","tag-excel-to-redis","tag-redis"],"_links":{"self":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/14275","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=14275"}],"version-history":[{"count":9,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/14275\/revisions"}],"predecessor-version":[{"id":39193,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/14275\/revisions\/39193"}],"wp:attachment":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/media?parent=14275"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/categories?post=14275"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/tags?post=14275"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}