KNOWLEDGE BASE

Error "Invalid input: expected..." Connecting to Excel


Published: 10 Jul 2014
Last Modified Date: 04 Dec 2015

Issue

When you try to connect to Excel from Tableau Desktop, the following error might occur:

Invalid input: expected '.'

Environment

  • Tableau Desktop 8.2.0
  • Microsoft Excel

Resolution

Option 1

Upgrade to Tableau Desktop 8.2.1 or a later version. For more information, see Upgrading Tableau Desktop in the Tableau Knowledge Base.

Option 2

In Microsoft Excel, change the name of the Countries column to Country.

Cause

This behavior is a known issue that has been corrected in more recent releases.
Did this article resolve the issue?