Japanese Big Characters And Small Characters Are Joined When Connecting To Excel Data Source

Published: 24 Apr 2018
Last Modified Date: 24 Apr 2018


Japanese has bigger characters (upper case) like シヨウ and smaller characters (lower case) like ショウ, which have totally different meanings and pronunciations. In Tableau Desktop 10.5, these characters are case insensitive and ショウ (lower case) is joined to シヨウ (upper case) when connecting to Excel file data sources.

This issue does not occur in Tableau Desktop 10.4 and earlier versions of Tableau on Japanese OS, but occurs on any version of Tableau Desktop on English OS. Also, the issue does not exist, if data sources are CSV files.


  • Tableau Desktop 10.5.0 and later


Workaround: Convert the Excel sheets to CSV files and join the CSV files. 


This issue is under investigation as ISSUE ID 767724.

Additional Information

 "ショウ" has totally different meaning and pronunciations from "シヨウ". See below example
  • "ショウ" means "show", which is pronounced as "show".
  • "シヨウ" means "expected behavior", which is pronounced as "shi-yo-u".
Did this article resolve the issue?