How to do it

With Teradata Studio Express

Here is how we do it for Studio Express:

1. Go to data explorer.
2. Search for the database under which the required table is located.
3. Explore the database.
4. Right-click on the table, Name | Data | Export Data.
5. The Wizard will come up; select the destination file where the data needs to be written in.
6. Select the option of Export Data Format from File options.
7. Once the data is written to the file, you will get a success message. 
8. Open the file to verify the data.

With Teradata SQLA

1. Select the Export Data option from the File tab.
2. Execute the select query from which you need to export the data.
3. As you hit F5 for execution, a window prompt will appear. Save the file with the required name and format.
4. Your data will be written to the file.

To save the file in the Excel format, use "filename.xlsx" in double quotes:

"filename.xlsx"