The Differentiation of Japanese Characters:Half and Full-width Hiragana and Katakana

Published: 08 Nov 2016
Last Modified Date: 08 Jul 2022


When data is imported into Tableau from CSV/Txt/Excel, the Japanese characters Hiragana and Katakana are converted to be the same character.
  Japanese characters: Hiragana(full-width) are converted to be the Japanese characters: Katakana(full-width/half-width)
  Japanese characters: Katakana(full-width/half-width) are converted to be the  Japanese characters: Hiragana(full-width)


  • Tableau Desktop 10.0.1
  • Text Files / Excel


  • Upgrade to Tableau Desktop 2019.1 or later.
  • This feature is released since Tableau Desktop 2019.1
Hiragana and Katakana can be distinguished with the following setting:
Data > Maintain Character Case (Excel)
User-added image
  • Use a text file instead of Excel, and set the locale to English when importing the text file.  ( select file Right Click > Text file properties, Select Locale: English. )

Additional Information

Did this article resolve the issue?