Import data from excel file to Redis hash keys in same namespace without programming

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

Using Redis Data Studio, a native GUI tool, you can import Excel file 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

Import Excel file into Redis hash keys in same namespace

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

Click “Import From File” at task dialog.

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

1. Config source Excel file.

The Excel file like this:

2. Config destination hash keys namespace.

3. Summary.

4. Import Excel file into Redis hash keys in same namespace.

After importing, you can view hash keys.

Import Excel to Redis hash keys in a namespace in command line

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

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

Set scheduled tasks for converting Excel to Redis namespace

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

• 
• 
•