I have the following for loop:
for titles in titles:
title = titles.xpath("a/text()").extract()
link = titles.xpath("a/@href").extract()
You should use the python CSV module. Look here for more information: Writing List of Strings to Excel CSV File in Python.
Here is an example for your problem:
import csv results =  # your code... also add this to your for loop. results.append([title, link]) csv_file = open("csv_file.csv",'wb') wr = csv.writer(csv_file) for row in results: wr.writerow(row)