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.
Download RedisDataStudio
Windows 64 bit
Windows 32 bit
Linux .deb (For Debian, Ubuntu) 64 bit
Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit
MacOS 64 bit
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.