Title: Problem with Google Spreadsheet Live Data
Last modified: August 31, 2016

---

# Problem with Google Spreadsheet Live Data

 *  Resolved [romapad](https://wordpress.org/support/users/romapad/)
 * (@romapad)
 * [10 years, 1 month ago](https://wordpress.org/support/topic/problem-with-google-spreadsheet-live-data/)
 * After last two updates I got strange layout in my google live tables generated
   by the plugin. Seems there is problem with columns formatting. See attached screen:
   
   [https://onedrive.live.com/redir?resid=2397EBD3F320C25E!88182&authkey=!AAaPpV34zXCTF6I&v=3&ithint=photo%2cpng](https://onedrive.live.com/redir?resid=2397EBD3F320C25E!88182&authkey=!AAaPpV34zXCTF6I&v=3&ithint=photo%2cpng)
 * [https://wordpress.org/plugins/contact-form-7-to-database-extension/](https://wordpress.org/plugins/contact-form-7-to-database-extension/)

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

 *  Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * (@msimpson)
 * [10 years, 1 month ago](https://wordpress.org/support/topic/problem-with-google-spreadsheet-live-data/#post-7290156)
 * OK. I think I messed this up in a recent update because I update the CSV export
   to be “smart” about whether to use comma or semicolon delimiters based on region.
   This is good for Excel, but I guess Google Sheets always expects commas.
 * To fix, edit the IMPORTDATA function that you have in your cell and add “&delimiter
   =,” to the end of the URL.
 *  Thread Starter [romapad](https://wordpress.org/support/users/romapad/)
 * (@romapad)
 * [10 years, 1 month ago](https://wordpress.org/support/topic/problem-with-google-spreadsheet-live-data/#post-7290166)
 * Thank you for super fast answer! That’s work!
 *  Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * (@msimpson)
 * [10 years, 1 month ago](https://wordpress.org/support/topic/problem-with-google-spreadsheet-live-data/#post-7290194)
 * I put in a fix and just released version 2.10.9. It should work again without
   the additional text in the URL. If you would update to that version, test the
   original URL, and tell me if it works, I would be grateful.
 *  Thread Starter [romapad](https://wordpress.org/support/users/romapad/)
 * (@romapad)
 * [10 years, 1 month ago](https://wordpress.org/support/topic/problem-with-google-spreadsheet-live-data/#post-7290211)
 * Thanks for quick fix, I did update plugin, but it still showing the same problem
   with original URL:
    [https://onedrive.live.com/redir?resid=2397EBD3F320C25E!88187&authkey=!ANwp35bdBxxa6Qg&v=3&ithint=photo%2cpng](https://onedrive.live.com/redir?resid=2397EBD3F320C25E!88187&authkey=!ANwp35bdBxxa6Qg&v=3&ithint=photo%2cpng)
 * with this addition: &delimiter=, – working perfectly
 *  Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * (@msimpson)
 * [10 years, 1 month ago](https://wordpress.org/support/topic/problem-with-google-spreadsheet-live-data/#post-7290267)
 * Thanks for reporting back.
    – What is the language setting on your site? – And
   is your Google Spreadsheets on “docs.google.com”?
 *  Thread Starter [romapad](https://wordpress.org/support/users/romapad/)
 * (@romapad)
 * [10 years, 1 month ago](https://wordpress.org/support/topic/problem-with-google-spreadsheet-live-data/#post-7290282)
 * Hi!
    – russian language – yes Do you need more details? I can send to email

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

The topic ‘Problem with Google Spreadsheet Live Data’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/contact-form-7-to-database-extension_ffffff.
   svg)
 * [Contact Form DB](https://wordpress.org/plugins/contact-form-7-to-database-extension/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/contact-form-7-to-database-extension/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/)
 * [Active Topics](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/reviews/)

 * 6 replies
 * 2 participants
 * Last reply from: [romapad](https://wordpress.org/support/users/romapad/)
 * Last activity: [10 years, 1 month ago](https://wordpress.org/support/topic/problem-with-google-spreadsheet-live-data/#post-7290282)
 * Status: resolved