title: How to keep commas when exporting a csv file with python for Airtable?
body: <p>I'll try to make my request as clear as possible. I'm trying to export a table written with Python in <code>.csv</code> format for Airtable. </p>
  
  <p>Once my <code>.csv</code> is exported, if I open it with Excel, there is no problem, but then if I upload it to Airtable (used by my association), it doesn't tolerate the strings in which there is a comma. </p>
  
  <p>The result will be :</p>
  
  <pre><code>prenom|nom|instrument|
  
  jean,dupont,"violon,piano,guitar"| &lt;-- ERROR
  
  marie|moulin|guitar
  </code></pre>
  
  <p>instead of :</p>
  
  <pre><code>prenom | nom    | instrument            |
  -------+--------+-----------------------+
  jean   | dupont | violon, piano, guitar |
  marie  | moulin | guitar                |
  </code></pre>
  
  <p>Can I fix the problem by exporting differently my csv with Python? Do you see any other solution?</p>
  
  <p>This is how i exported my csv :</p>
  
  <pre><code>
  with open('CRMtest.csv', 'w', newline='') as csvfile:
      linewriter = csv.writer(csvfile, delimiter=":", quotechar = '"')
      for i in range(len(list_nom)):
          linewriter.writerow([row_1[i],row_2[i],row_3[i])
  </code></pre>
  
  <p>All of my row_X are strings and some of them contains comas. </p>
  
  <p>For example :</p>
  
  <pre><code>row_1 = 'prenom','jean','marie'
  
  row_2 = 'nom','dupont','moulin'
  
  row_3 = 'instrument','violon, piano, guitare','guitare'
  </code></pre>