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

by

Posted on by

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

Using Withdata software RedisDataStudio, 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 Download RedisDataStudio

Example of bulk importing Excel files into Redis hash keys in same namespace

Source Excel file folder

Batch import Excel file into hash keys in same namespace - source Excel folder

An example Excel file in this folder

Batch import Excel file into hash keys in same namespace - view a source Excel file

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

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

Batch import Excel files into Redis hash keys in same namespace - task window

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

Batch import Excel files into Redis hash keys in same namespace - choose types

1. Open source Excel file file folder.

Batch import Excel files into Redis hash keys in same namespace - source Excel file folder

2. Config first source Excel file.

Batch import Excel files into Redis hash keys in same namespace - config first source Excel file

3. Config destination hash keys namespace.

Batch import Excel files into Redis hash keys in same namespace - config destination hash keys namespace

4. Summary.

Batch import Excel files into Redis hash keys in same namespace - summary

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

Batch import Excel files into Redis hash keys in same namespace - import file

After importing, you can view data in hash keys.

Batch import Excel files 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