title: Writing to different columns in Excel from python
body: <p>I'm using Python Selenium webdriver to scrape a web table by iterating over the rows in the table, and CSV module to write to excel.</p>
  
  <pre><code>When printing in python my scraped web table shows
  ['PS208\n43:51\nOUTBOUND\nFDEX\n708135']
  ['PS207\n01:24\nINBOUND\nUPSS\n889058']
  ['PS206\n12:34\nOTHER\nFDEG\n506796']
  </code></pre>
  
  <p>when writing to excel csv</p>
  
  <p>all the data goes into column A</p>
  
  <pre><code>A
  </code></pre>
  
  <p>1 PS208
  2 43:51
  3 OUTBOUND
  4 FDEX
  5 708135
  6
  7 PS207
  8 01:24
  9 INBOUND
  10 UPSS
  11 889058</p>
  
  <p>I need each piece of data between the \n to be on a different column
  and each block of data between the ' to be on a different row.</p>
  
  <pre><code> A     B      C      D      E
  </code></pre>
  
  <p>1 'PS208 43:51 OUTBOUND FDEX 708135'
  2 'PS207 01:24 INBOUND  UPSS 889058'</p>
  
  <pre><code>import csv
  import time
  from selenium import webdriver
  
  
  # ****Logging****
  # Current time
  now = ("Run Time = " + time.ctime())
  print(now)
  
  # ****Visible Chrome Browser****
  # Path to Chrome exe
  chrome_path = r"C:\Users/userr\Desktop\chromedriver.exe"
  # Chrome as browser
  browser = webdriver.Chrome(chrome_path)
  # URL to open
  url = "https://somewebsite"
  browser.maximize_window()
  browser.get(url)
  time.sleep(5)
  
  # Open csv to write to
  outfile = open("YMS.csv", "w")
  # Parse by spaces
  writer = csv.writer(outfile,  delimiter=" ")
  
  # ******Query******
  # Select "empty trailers"
  browser.find_element_by_xpath("""//*[@id="empty_checkbox"]""").click()
  time.sleep(5)
  table = browser.find_element_by_xpath("""//*[@id="ship-clerk-   dashboard-      table"]""")
  rows = table.find_elements_by_tag_name("""tr""")
  for row in rows:
      foo = row.text
      print([foo])
      writer.writerow([foo])
  
  # Close CSV file
  outfile.close()
  # Close browser
  browser.close()
  </code></pre>