Want to batch import Excel files into Redis hash keys without programming?
Using Withdata software Redis Data Studio, a Excel importer for Redis, you can batch import Excel files into Redis hash keys 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.
Example of bulk importing Excel files into Redis hash keys
Source Excel file folder
An example Excel file
After importing, you can see hash keys, and key value
Import Excel files into Redis hash keys
Choose Excel files -> Set Redis hash keys -> Import Excel to Redis
Click “Import From File” at task dialog.
Choose “Files”, “Excel”, “Keys”, “Hash”.
1. Select source file folder.
2. Config first source EXCEL file.
3. List exists Redis hash keys, choose “Import Type”.
4. Map Excel files to hash keys.
5. Summary.
6. Import Excel files into Redis hash keys.
After importing, you can view imported data in Redis hash keys.
Import Excel to Redis hash keys in command line
Save “Import Excel to Redis” session, then you can:
- Import Excel to Redis hash keys in Windows command line.
- Import Excel to Redis hash keys in Linux command line.
- Import Excel to Redis hash keys 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.