title: Issue storing data in csv using scrapy
body: <p>Below is my parse method of scrapy spider. My expected output in csv is three columns with corresponding values. Although in terminal output I get all the three columns (even it shows 84 items stored in output.csv, which correct). but in actual output file I only 1st column &quot;Title. help appreciated</p>
  <p>EDIT:In JSON all the data is there</p>
  <pre><code>    def parse(self, response):
          for titl in response.xpath('//span[@class=&quot;jv-job-list-title&quot;]/text()').extract():
              title = titl.strip()
              yield {&quot;Title&quot;:title}
          for dep in response.xpath('//span[@class=&quot;jv-job-list-title&quot;]/text()').extract():
              department = dep.strip()
              yield{&quot;Department&quot;:department}
          for countr in response.xpath('//td[@class=&quot;jv-job-list-name&quot;]/span[2]/text()').extract():
              country = countr.strip()
              yield{&quot;Country&quot;:country}
  scrapy crawl task -o output.csv
  </code></pre>
  <p>Complete code:</p>
  <pre><code>class TaskUs(scrapy.Spider):
      name = 'task'
      start_urls = [&quot;https://jobs.jobvite.com/taskus-inc/search?c=Workforce%20Management&amp;p=0&quot;]
  
      # def start_requests(self):
      #     for URL in self.start_urls:
      #         yield scrapy.Request(url=URL, meta={'proxy': 'http://103.241.227.108:6666'}, callback=self.parse)
  
      def parse(self, response):
          # for titl in response.xpath('//span[@class=&quot;jv-job-list-title&quot;]/text()').extract():
          #     title = titl.strip()
          #     yield {&quot;Title&quot;:title}
          # for dep in response.xpath('//span[@class=&quot;jv-job-list-category&quot;]/text()').extract():
          #     department = dep.strip()
          #     yield{&quot;Department&quot;:department}
          # for countr in response.xpath('//td[@class=&quot;jv-job-list-name&quot;]/span[2]/text()').extract():
          #     country = countr.strip()
          #     yield{&quot;Country&quot;:country}
          ti = response.xpath('//span[@class=&quot;jv-job-list-title&quot;]/text()').extract()
          de = response.xpath('//span[@class=&quot;jv-job-list-category&quot;]/text()').extract()
          co = response.xpath('//td[@class=&quot;jv-job-list-name&quot;]/span[2]/text()').extract()
          yield{'titl':ti, 'Depa': de, &quot;Cou&quot;: co}
  </code></pre>