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.
Example of bulk importing Excel files into Redis hash keys in same namespace
Source Excel file folder
An example Excel file in this folder
After importing, you can view data in Redis 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.
Choose “Files”, “Excel”, “Namespace Keys”, “Hash”.
1. Open source Excel file file folder.
2. Config first source Excel file.
3. Config destination hash keys namespace.
4. Summary.
5. Batch import Excel files into Redis hash keys in same namespace.
After importing, you can view data in hash 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.