9 Replies Latest reply on Jan 23, 2015 6:28 AM by Kevin Andrist

    Export -> Crosstab to Excel Problem?

    Deep Sarmah

      Hi Guys,

       

      I have a problem with Export -> Crosstab to Excel. When I do Crosstab to Excel in Tableau Desktop it opens up MS Excel and displays the data in excel’s native format which is perfect for my needs. However, it also puts a ‘comma at the beginning of each cell? Which is not ideal when I want to use the spreadsheet to update corrected data to the database directly. So my point is there any way I can get rid of the ‘comma and just have the data as normal please? Right now it displays as below:

       

      ‘ID                          ‘Title                      ‘Name

      ‘001                        ‘Mr                         ‘John

       

      Thanks to all.