Title: Error When Using Google Sheets
Last modified: January 26, 2018

---

# Error When Using Google Sheets

 *  Resolved [judgeholden](https://wordpress.org/support/users/judgeholden/)
 * (@judgeholden)
 * [8 years, 4 months ago](https://wordpress.org/support/topic/error-when-using-google-sheets/)
 * Hi Tobias and everyone else,
    I have been using TablePress for a few weeks configuring
   it and setting everything up, but I did want to try making my process more streamlined.
   I have spreadsheets set up on Google Sheets and want to have Tablepress read 
   the CSV file straight from there when importing to my website. The problem is
   every time I publish the spreadsheet on Google Sheets as a CSV so that Tablepress
   can see them, they are parsed with some sort of editing interface or Google-related
   text. I’ll attach a screenshot as an example of what it looks like. [https://imgur.com/a/RRQT7](https://imgur.com/a/uTpze).
   It is many lines more than the actual table and almost freezes WordPress. It 
   is a CSV file but it seems to be reading extra information, yet when I use the
   same link and open the file in Excel, it works flawlessly. I have tried adding“
   pub?output=csv” and other solutions, but since it is already published as a CSV
   file, I am still having the issue. Thanks a ton for your plugin and help, Ian
    -  This topic was modified 8 years, 4 months ago by [judgeholden](https://wordpress.org/support/users/judgeholden/).
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Ferror-when-using-google-sheets%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [8 years, 4 months ago](https://wordpress.org/support/topic/error-when-using-google-sheets/#post-9906929)
 * Hi,
 * thanks for your question, and sorry for the trouble.
 * If you have extra output there, the Google link does not actually go to a CSV
   file, I’m afraid – but that’s necessary for TablePress to be able to import it.
   
   I can therefore only suggest that you play around more with the export/publish
   methods of Google Spreadsheets, to find a link that directly returns a CSV file,
   without having to log in.
 * Regards,
    Tobias
 *  Thread Starter [judgeholden](https://wordpress.org/support/users/judgeholden/)
 * (@judgeholden)
 * [8 years, 4 months ago](https://wordpress.org/support/topic/error-when-using-google-sheets/#post-9914951)
 * Thanks for checking that out for me. It is a bit perplexing because it seems 
   to be a totally normal csv file to my other spreadsheet programs. I will keep
   looking into it, as I feel like I’m pretty close.
    Vielen dank! Ian
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [8 years, 4 months ago](https://wordpress.org/support/topic/error-when-using-google-sheets/#post-9915123)
 * Hi,
 * that should always be checked in a text editor. Also, the access rights seem 
   off, I’m asked to log in to see that document (from your link above). This will
   also cause trouble on the server, as TablePress/WordPress can’t log in either.
 * Regards,
    Tobias

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Error When Using Google Sheets’ is closed to new replies.

 * ![](https://ps.w.org/tablepress/assets/icon.svg?rev=3192944)
 * [TablePress - Tables in WordPress made easy](https://wordpress.org/plugins/tablepress/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/tablepress/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/tablepress/)
 * [Active Topics](https://wordpress.org/support/plugin/tablepress/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/tablepress/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/tablepress/reviews/)

## Tags

 * [csv](https://wordpress.org/support/topic-tag/csv/)
 * [Google Sheets](https://wordpress.org/support/topic-tag/google-sheets/)

 * 3 replies
 * 2 participants
 * Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * Last activity: [8 years, 4 months ago](https://wordpress.org/support/topic/error-when-using-google-sheets/#post-9915123)
 * Status: resolved