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

by

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

Using Withdata software Redis Data Studio, a Excel importer for Redis, you can import Excel file into Redis namespaced string keys (key name contains ‘:’) easily and fast.

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

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

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

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 RedisDataStudioExcel to Redis Converter

Download RedisDataStudio Download RedisDataStudio