Import data from excel files to Redis 1 hash key without programming

Want to batch import multiple Excel files into a single Redis hash key without programming?

Using Withdata software Redis Data Studio, a Excel importer for Redis, you can batch import multiple Excel files into a single Redis hash key easily and fast.

• Can run in GUI mode, Step by Step, just a few mouse clicks.
• Can run in Command line, for Scheduled Tasks and Streams.
• Support Windows, Linux, macOS.

Download RedisDataStudio

Example of bulk importing multiple Excel files into a single Redis hash key

Source Excel file folder

An example Excel file in this folder

After importing, you can see string keys, and key value

Import multiple Excel files into a single Redis hash key

Choose Excel files -> Set Redis hash key -> Import Excel to Redis

Click “Import From File” at task dialog.

Choose “Files”, “EXCEL”, “Key”, “Hash”.

1. Select source file folder.

2. Config first source EXCEL file.

3. Config destination hash key, choose an exists key or create a new one.

4. Summary.

5. Batch import Excel files into a single Redis hash key.

View Hash Key.

Import multiple Excel to 1 Redis hash key in command line

Save “Import multiple Excel to 1 Redis hash key” session, then you can:

• Import multiple Excel to 1 Redis hash key in Windows command line.
• Import multiple Excel to 1 Redis hash key in Linux command line.
• Import multiple Excel to 1 Redis hash key in macOS command line.

Set scheduled tasks for converting multiple Excel to 1 Redis hash key

You can schedule and automate this “Excel to Redis” conversion task by:

1) Save session and create .bat (Windows) or .sh (Linux/macOS) file.

2) Set scheduled task.

---

More about RedisDataStudio – Excel to Redis converter

• 
• 
•