Title: Missing data in table
Last modified: February 3, 2022

---

# Missing data in table

 *  [dkshyrion](https://wordpress.org/support/users/dkshyrion/)
 * (@dkshyrion)
 * [4 years, 4 months ago](https://wordpress.org/support/topic/missing-data-in-table/)
 * Hello,
 * I am using Inline Google Spreadsheet Viewer for quite some time and like it really
   much.
    My shortcode looks like this: `[gdoc key="URL" use_cache="no" class="no-
   datatables" query="select A,B,C,D,E,F where A = 'Example'"]`
 * The problem is that the content of some cells are missing. For example if you
   imagine a fully filled 3×4 table in Google sheets, the result looks like this
   on the website:
    X X _ _ X X X X X _ _ _ All rows are displayed. I figured out
   that changing the format in Google sheets sometimes helps, e.g. when I change
   the format to “Date” the value in the cell appears on the WordPress site, when
   it actually includes a date, but not every data is a date. I tried out to include`
   csv_headers=1` as proposed here: [Link](https://wordpress.org/support/topic/table-first-row-text-missing/#post-12138163)
 * But this doesn’t work for me. I noticed that removing `query="select ...` solves
   the problem, but I need this feature as my table is very big.
 * Do you have any ideas? In the thread linked above, it was proposed to format 
   the Google Sheets cells as Data. How can I do this?
    Thank you.
    -  This topic was modified 4 years, 4 months ago by [dkshyrion](https://wordpress.org/support/users/dkshyrion/).

Viewing 1 replies (of 1 total)

 *  [gskensho2jp](https://wordpress.org/support/users/gskensho2jp/)
 * (@gskensho2jp)
 * [4 years, 3 months ago](https://wordpress.org/support/topic/missing-data-in-table/#post-15424654)
 * hi
 * >But this doesn’t work for me. I noticed that removing query=”select … solves
   the problem, but I need this feature as my table is very big.
 * →Is it possible for you to make a new worksheet on googlespreadsheet and use “
   Query” in order to choose nessesary data from your big table?
    and, you can write
   the URL of new worksheet in shortcode. Is it good for you?

Viewing 1 replies (of 1 total)

The topic ‘Missing data in table’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/inline-google-spreadsheet-viewer.
   svg)
 * [Inline Google Spreadsheet Viewer](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/)
 * [Active Topics](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [gskensho2jp](https://wordpress.org/support/users/gskensho2jp/)
 * Last activity: [4 years, 3 months ago](https://wordpress.org/support/topic/missing-data-in-table/#post-15424654)
 * Status: not resolved