In the past when I needed to create a data export and dump it to a csv/xls file, I would create a file then loop through the query and append each line of data. This was not a hard task and did not take too many lines of code.

However, with ColdFusion 9 this task can be done with one line of code using the cfspreadsheet tag.

Here is a quick example, where "yourqueryname" is the name you gave your query object:

CF simply writes the xls file to the location you told it to in the filename parameter.