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

by

Posted on by

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

Using Withdata software RedisDataStudio, a Excel importer for Redis, you can import Excel file into Redis namespaced string keys (key name contains ‘:’) 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 Download RedisDataStudio

Import Excel file into Redis string keys in same namespace

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

Click “Import From File” at task dialog.

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

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

Import Excel file into Redis string keys in same namespace - choose types

1. Open source Excel file.

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

The Excel file like this:

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

2. Config destination string keys namespace.

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

3. Summary.

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

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

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

After importing, you can view string keys in the namespace.

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

Download RedisDataStudio for 30-day free trial Download RedisDataStudio