Ok, I did try that and for that purpose what I did was - I created a test excel sheet with only 3 columns and that had ‘general’ as a format in excel sheet. I then created a table with varchar as datatype for the table. Then also it was not able to push the data.
I am not using any query as of now but ‘Insert’ activity to push data to redshift cluster.