Title: Google Sheet Import not Working
Last modified: August 30, 2016

---

# Google Sheet Import not Working

 *  Resolved [riw](https://wordpress.org/support/users/riw/)
 * (@riw)
 * [11 years ago](https://wordpress.org/support/topic/google-sheet-import-not-working/)
 * Nevermind — I found it.

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

 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [11 years ago](https://wordpress.org/support/topic/google-sheet-import-not-working/#post-6236513)
 * Hi,
 * thanks for your post, and sorry for the trouble.
 * When I click that link, I only get a “File not found” error. That could indicate
   that the file is not available publicly, but that the user has to be logged-in
   to download it.
    Your site/server obviously is not logged-in to Google, so that’s
   likely what’s causing this. You will have to configure the Google Docs table 
   so that it can be downloaded publicly, i.e. without having to be logged-in.
 * Regards,
    Tobias
 *  Thread Starter [riw](https://wordpress.org/support/users/riw/)
 * (@riw)
 * [11 years ago](https://wordpress.org/support/topic/google-sheet-import-not-working/#post-6236519)
 * Okay — the correct link is —
 * [https://docs.google.com/spreadsheets/d/1pswNGQO3IGSYjwndvMTGKGmEd1hRafzKOnwU0k1A1-U/export?format=csv&id=1pswNGQO3IGSYjwndvMTGKGmEd1hRafzKOnwU0k1A1-U](https://docs.google.com/spreadsheets/d/1pswNGQO3IGSYjwndvMTGKGmEd1hRafzKOnwU0k1A1-U/export?format=csv&id=1pswNGQO3IGSYjwndvMTGKGmEd1hRafzKOnwU0k1A1-U)
 * I think that when I paste it in for a manual import, the entry form in tablepress
   is automagically selecting “html” as the format because the import line starts
   with “html.” This doesn’t show up on the form, though, which is confusing. If
   I paste the url in, then manually select “csv” (which is already selected), the
   import works.
 * Just looks like some automatic format choosing in the backend is being a little
   too aggressive or something.
 * Thanks.
 * 🙂
 * Russ
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [11 years ago](https://wordpress.org/support/topic/google-sheet-import-not-working/#post-6236521)
 * Hi,
 * ah, yes, you will need to manually select “CSV” from that drop-down, after pasting
   in the URL. TablePress only automatically select “CSV”, if the URL ends with “.
   csv”. Otherwise it falls back to “HTML”.
 * Best wishes,
    Tobias

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

The topic ‘Google Sheet Import not Working’ 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

 * [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: [11 years ago](https://wordpress.org/support/topic/google-sheet-import-not-working/#post-6236521)
 * Status: resolved