Want to import Excel file into Redis hash keys in same namespace without programming?
Using Redis Data Studio, a native GUI tool, you can import Excel file 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.
Import Excel file into Redis hash keys in same namespace
Choose Excel file -> Set Redis hash keys namespace -> Import Excel to Redis
Click “Import From File” at task dialog.
Choose “File”, “Excel”, “Namespace Hash Keys”, “Hash”.
1. Config source Excel file.
The Excel file like this:
2. Config destination hash keys namespace.
3. Summary.
4. Import Excel file into Redis hash keys in same namespace.
After importing, you can view hash keys.
Import Excel to Redis hash keys in a namespace in command line
Save “Import Excel to Redis” session, then you can:
- Import Excel to Redis hash keys in a namespace in Windows command line.
- Import Excel to Redis hash keys in a namespace in Linux command line.
- Import Excel to Redis hash keys in a namespace in macOS command line.
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.