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

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

Using Withdata software Redis Data Studio, a Excel importer for Redis, you can batch import Excel files 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

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

Source Excel file folder

An example Excel file in this folder

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

Import Excel files into Redis string keys in same namespace

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

Click “Import From File” at task dialog.

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

1. Open source Excel file folder.

2. Config first source Excel file.

3. Config destination string keys namespace.

4. Summary.

5. Import Excel files into Redis string keys in same namespace.

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

Batch import Excel files to Redis string keys in a namespace in command line

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

• Batch import Excel files to Redis string keys in a namespace in Windows command line.
• Batch import Excel files to Redis string keys in a namespace in Linux command line.
• Batch import Excel files to Redis string keys in a namespace in macOS command line.

Set scheduled tasks for converting Excel to Redis 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

• 
• 
•