Application server to Excel file

I am using open data sets to download data to Appl server. After download data to Appl server, that should be saved as Excel format. In Excel I got that data, but problem is

I am not getting data as columns wise. Is there any solution for this.

Rgards,

Naseer.