When you are doing crosstab to excel by default for Text fields apostrophe (') will be placed at the front of the text. We have to manually format the text in excel using excel functions..
I've taken data out of Tableau to Excel daily for many years using Tableau v5 to v8.3 & Excel 2003 to 2010..never seen this. I have seen the apostrophe when extracting data from ERP databases, but never with Tableau generating the '.
Maybe you could list what you're doing & what versions you're using??
There are a number of ways to clean up '123 to 123 in Excel, but you shouldn't have to..odd.
Very odd. About 95% of my Tableau use involves the Tableau-Excel pair and the Excel files run as large as Excel can handle without losing control(100-200+MB, given 32 bit hardware resources) and I've never seen the apostrophe when pulling data out of Tableau and into Excel...1000s of extractions..
..very strange..good to know the cure if it starts..
I've never seen the apostrophe when pulling data out of Tableau and into Excel
Neither have I experienced this. Thanks for sharing. It is good to know that this happens rarely.
I wonder if Deep Sarmah's issue relates to a particular version of Tableau and or Excel.
At least it seems like an exception rather than the rule. (glad of that!.the work-arounds would be a big time sink given the amount of this I do)
I run Tableau Desktop 8.3.1 on a 32 bit machine, Win 7 Pro SP1, Office 2010 Pro
Thanks all. I use Tableau Professional 8.2.2 with MS Office Professional Plus 2013 and Windows 7 64 bit machine? The problem I am facing since I started using Tableau from early last year. Thanks again and hope to get a fix from the Vendor soon. Cheers.
The answer by kettan solves the problem but its a workaround. I also agree by the solution why Tableau does that as Excel has a trend to reformat everything to its own format. Putting an apostrophe at front of every cell stops excel from doing that. But it will really be helpful to have a decent answer rather than a workaround in case someone has lots and lots of report to export as CSV and reimport? Thanks.
I wonder if the apostrophe is an artifact of the original datasource and Tableau is just passing it through when some extract from Tableau to Excel?
I have seen the apostrophe in some data I extract from ERP systems that transfers directly from the ERP to a CSV file to Excel (it never passes through Tableau). I do some processing on this data, make additions to it, clean it up as needed, and then connect to Tableau for further analysis...and never see the ' once I extract back to Excel.
Just a thought..