KNOWLEDGE BASE

Error "An error occurred while communicating with Excel Reader" Connecting to Google Sheets


Published: 08 Nov 2017
Last Modified Date: 13 Nov 2017

Issue

After selecting a sheet in a Google Sheets connection, the following error occurs:
  An error occurred while communicating with Excel Reader

The issue may not occur with all sheets in the connection.

Environment

  • Tableau Desktop 10.4.0
  • Google Sheets
  • Mac OS

Resolution

In Google Sheets:
  • If any column in the sheet has clickable URL links, right click the column and choose Unlinked to resolve the issue. 
  • If the sheet in question does not have the URL Links but is in a workbook with other sheets that do, try copying the sheet to a new workbook and connecting to it from there.

Cause

Issue with the Google Sheets file.

Additional Information

If the sheet causing the error is downloaded as an Excel file, it will not open in Microsoft Excel and may be reported as a corrupt file.
Did this article resolve the issue?