KNOWLEDGE BASE

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


Published: 08 Nov 2017
Last Modified Date: 16 May 2020

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.
  • If any sheet tabs are a pivot table, the pivot tables must be removed

Cause

Issue with the Google Sheets file or the file contains a pivot table.

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.



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