Want to parse cloud Excel file and save to Redshift?
Using File To DB, a native GUI tool for Windows, MacOS, and Linux, you can convert cloud EXCEL file to Redshift table 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.
- Import Excel to Redshift locally and privately, avoid uploading Excel file(s) to online services.
Import cloud EXCEL file to Redshift table
Choose Redshift and logon.
Click “Wizard – 1 File To 1 Table” at task dialog.
Select “Source Type” with “Url”.
then show the wizard.
1. Input the EXCEL file URL, and download the file.
2. Open the saved EXCEL file.
3. Config target Redshift table.
4. Summary.
5. Import cloud EXCEL file to Redshift.
See Redshift table
Import cloud Excel to Redshift in command line
Save “Excel to Redshift” session, then you can:
- Import cloud Excel to Redshift in Windows command line.
- Import cloud Excel to Redshift in Linux command line.
- Import cloud Excel to Redshift in macOS command line.
Set scheduled tasks for importing Excel to Redshift
You can schedule and automate this converting task by:
1) Save session and create .bat file.
FAQ