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

by

Posted on by

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

Using RedisDataStudio, 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 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.

Import Excel file into Redis hash keys in same namespace - task window

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

Import Excel file into Redis hash keys in same namespace - task window

1. Config source Excel file.

Import Excel file into Redis hash keys in same namespace - source file

The Excel file like this:

Import Excel file into Redis hash keys in same namespace - view the source Excel file

2. Config destination hash keys namespace.

Import Excel file into Redis hash keys in same namespace - config destination hash keys namespace

3. Summary.

Import Excel file into Redis hash keys in same namespace - summary

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

Import Excel file into Redis hash keys in same namespace - import file

After importing, you can view hash keys.

Import Excel file into Redis hash keys in same namespace - view 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

Download RedisDataStudio for 30-day free trial Download RedisDataStudio