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.
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.