title: Datatables export Excel
body: <p>I'm exporting the datatables in csv. And when I open the file with excel, I've got problem with big numbers (around 20 digits). I also have problem with the special characters.
  I guess it's a formatting problem. But I don't know How to correct the problem.</p>
  
  <p>The code in my Js file: </p>
  
  <pre><code>dom: 'Bfrtip',
      buttons: [
          {
              extend: 'csv',
              text: 'csv',
              fieldSeparator: ';' // with ';' we can export the file in csv and each column is in one column. Without ';' everything is in one column
          },
          'pdf',
          'print'
      ]
  </code></pre>
  
  <p>An image of the problem:
  <a href="https://i.stack.imgur.com/oDvFH.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/oDvFH.png" alt="enter image description here"></a></p>
  
  <p>Thanks for your help.</p>