Batch import data from excel files to Redis hash keys without programming

Want to batch import Excel files into Redis hash keys without programming?

Using Withdata software Redis Data Studio, a Excel importer for Redis, you can batch import Excel files into Redis hash keys 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 Excel files into Redis hash keys

Source Excel file folder

An example Excel file

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

Import Excel files into Redis hash keys

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

Click “Import From File” at task dialog.

Choose “Files”, “Excel”, “Keys”, “Hash”.

1. Select source file folder.

2. Config first source EXCEL file.

3. List exists Redis hash keys, choose “Import Type”.

4. Map Excel files to hash keys.

5. Summary.

6. Import Excel files into Redis hash keys.

After importing, you can view imported data in Redis hash keys.

Import Excel to Redis hash keys in command line

Save “Import Excel to Redis” session, then you can:

• Import Excel to Redis hash keys in Windows command line.
• Import Excel to Redis hash keys in Linux command line.
• Import Excel to Redis hash keys in macOS command line.

Set scheduled tasks for converting Excel to Redis hash keys

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

• 
• 
•