Want to import Excel file into Redis hash key without programming?
Using Withdata software Redis Data Studio, a Excel importer for Redis, you can import Excel file into Redis hash key 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.
Import Excel file into Redis hash key
Choose Excel file -> Set Redis hash key -> Import Excel to Redis
Click “Import From File” at task dialog.
Choose “File”, “Excel”, “Key”, “Hash”.
1. Open source Excel file.
The Excel file like this:
2. Config destination hash key, choose an exists key or create a new one.
3. Summary.
4. Import Excel file into Redis hash key.
After importing, you can view data in the Hash Key.
Import Excel to Redis hash key in command line
Save “Import Excel to Redis hash key” session, then you can:
- Import Excel to Redis hash key in Windows command line.
- Import Excel to Redis hash key in Linux command line.
- Import Excel to Redis hash key in macOS command line.
Set scheduled tasks for converting Excel to Redis hash key
You can schedule and automate this “Excel to Redis hash key” conversion task by:
1) Save session and create .bat (Windows) or .sh (Linux/macOS) file.