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

Published: 24 Apr 2018
Last Modified Date: 13 Oct 2019


Japanese has bigger characters (upper case) like シヨウ and smaller characters (lower case) like ショウ, which have different meanings and pronunciations. In Tableau Desktop 10.5 or Tableau Desktop 2018.1, 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 - 10.5.4
  • Tableau Desktop 2018.1.0 - 2018.1.1


Option 1

Upgrade to Tableau Desktop 2018.1.2, 10.5.5. For more information, see Upgrading Tableau Desktop in Tableau Help.

Option 2

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


This behavior is related to a known issue (ID: 767724) which has been fixed in recent releases of Tableau Desktop. 

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".

Discuss this article... Feedback Forum
Did this article resolve the issue?