Want to batch import Excel files into Redis hash 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 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.
Batch import Excel files to Redis hash keys in a namespace in command line
Save “Import Excel to Redis” session, then you can:
- Batch import Excel files to Redis hash keys in a namespace in Windows command line.
- Batch import Excel files to Redis hash keys in a namespace in Linux command line.
- Batch import Excel files to Redis hash keys in a namespace in macOS command line.
Set scheduled tasks for converting Excel to Redis 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.