<table class="table table-bordered" id="dataTable" width="100%" cellspacing="0">
<thead>
  <tr>
    <th>№</th>
    <th>Adress</th>
    <th>Shop name</th>
  </tr>
</thead>
<tfoot>
  <tr>
    <th>№</th>
    <th>Adress</th>
    <th>Shop name</th>
  </tr>
</tfoot>
<tbody>
<tr>
    <td>1</td>
    <td>Shop name</td>
    <td>Shop adress</td>
  </tr>
  <tr>
    <td>2</td>
    <td>Shop name</td>
    <td>Shop adress</td>
  </tr>
  <tr>
    <td>3</td>
    <td>Shop name</td>
    <td>Shop adress</td>
  </tr>
</tbody>
</table>


<script>
$(document).ready(function() {
    $('#dataTable').DataTable( {
        aLengthMenu: [
            [10, 25, 50, 100, 200, -1],
            [10, 25, 50, 100, 200, "Все"]
        ],
        iDisplayLength: -1,
        dom: 'Bfrtip',
        buttons: [
            'excelHtml5',
        ]
    } );
} );
</script>