Question: how to export data from teradata to excel file?
Answer: Make sure you have the columns in Excel in the same order as the table you created. ... 
In SQL Assistant set the Delimiter as ","(comma) . ... 
Go to "Tools=>Options" and select the Date Format as 'YYYY-MM-DD'. ... 
From Teradata SQL Assistant, click 'File', then 'Import Data'.