title: Using Python to write a CSV file with delimiter
body: <p>I'm new to programming, and also to this site, so my apologies in advance for anything silly or "newbish" I may say or ask.</p>
  
  <p>I'm currently trying to write a script in python that will take a list of items and write them into a csv file, among other things. Each item in the list is really a list of two strings, if that makes sense. In essence, the format is [[Google, http://google.com], [BBC, http://bbc.co.uk]], but with different values of course.</p>
  
  <p>Within the CSV, I want this to show up as the first item of each list in the first column and the second item of each list in the second column. </p>
  
  <p>This is the part of my code that I need help with:</p>
  
  <pre><code>with open('integration.csv', 'wb') as f:
      writer = csv.writer(f, delimiter=',', dialect='excel')
      writer.writerows(w for w in foundInstances)
  </code></pre>
  
  <p>For whatever reason, it seems that the delimiter is being ignored. When I open the file in Excel, each cell has one list. Using the old example, each cell would have "Google, <a href="http://google.com" rel="nofollow">http://google.com</a>". I want Google in the first column and <a href="http://google.com" rel="nofollow">http://google.com</a> in the second. So basically "Google" and "http://google.com", and then below that "BBC" and "http://bbc.co.uk". Is this possible?</p>
  
  <p>Within my code, foundInstances is the list in which all the items are contained. As a whole, the script works fine, but I cannot seem to get this last step. I've done a lot of looking around within stackoverflow and the rest of the Internet, but I haven't found anything that has helped me with this last step.</p>
  
  <p>Any advice is greatly appreciated. If you need more information, I'd be happy to provide you with it.</p>
  
  <p>Thanks!</p>