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

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

Using Withdata software Redis Data Studio, a Excel importer for Redis, you can batch import Excel files into Redis namespaced hash keys (key name contains ‘:’) easily and fast, no need to program.

• 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 in same namespace

Source Excel file folder

An example Excel file in this folder

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

Import Excel files into Redis hash keys in same namespace

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

Click “Import From File” at task dialog.

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

1. Open source Excel file file folder.

2. Config first source Excel file.

3. Config destination hash keys namespace.

4. Summary.

5. Batch import Excel files into Redis hash keys in same namespace.

After importing, you can view data in hash keys.

Batch import Excel files to Redis hash keys in a namespace in command line

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

• Batch import Excel files to Redis hash keys in a namespace in Windows command line.
• Batch import Excel files to Redis hash keys in a namespace in Linux command line.
• Batch import Excel files to Redis hash keys in a namespace 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

• 
• 
•