Title: Table first row text missing Last modified: November 13, 2019 --- # Table first row text missing * Resolved [tipsstar](https://wordpress.org/support/users/tipsstar/) * (@tipsstar) * [6 years, 6 months ago](https://wordpress.org/support/topic/table-first-row-text-missing/) * Hi, in the website I have imported few google sheet tables with this plugin. The plugin is working nicely as a whole. Only in few cases the first row text are missing. In my google sheet there is text in the first row. Can you please check and suggest a solution. * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Ftable-first-row-text-missing%2F%3Foutput_format%3Dmd&locale=en_US) to see the link]_ Viewing 7 replies - 1 through 7 (of 7 total) * Thread Starter [tipsstar](https://wordpress.org/support/users/tipsstar/) * (@tipsstar) * [6 years, 6 months ago](https://wordpress.org/support/topic/table-first-row-text-missing/#post-12137697) * Bumping this 🙁 * Plugin Author [Meitar](https://wordpress.org/support/users/meitar/) * (@meitar) * [6 years, 6 months ago](https://wordpress.org/support/topic/table-first-row-text-missing/#post-12138163) * This has been asked quite a few times before and the issue is always that the way you’ve written your shortcode makes it so that the data you expect is simply not there to be consumed by the plugin. Here is your raw data coming from google: * [https://docs.google.com/spreadsheets/d/1OLd6zAwL1YZ1R1hgnrdJtbZdPZdJSfEM532asI6Cv3I/gviz/tq?tqx=out:csv](https://docs.google.com/spreadsheets/d/1OLd6zAwL1YZ1R1hgnrdJtbZdPZdJSfEM532asI6Cv3I/gviz/tq?tqx=out:csv) * As you can see, the data from Google omits the text in the header, as is to be expected from Google’s Chart Tools datasource protocol. * If you contrast this with the simpler CSV export endpoint, which this plugin uses when you do not supply a `query` or a `chart` attribute in your shortcode, you’ll see the full data in the first row as you may expect is there: * [https://docs.google.com/spreadsheets/d/1OLd6zAwL1YZ1R1hgnrdJtbZdPZdJSfEM532asI6Cv3I/export?format=csv](https://docs.google.com/spreadsheets/d/1OLd6zAwL1YZ1R1hgnrdJtbZdPZdJSfEM532asI6Cv3I/export?format=csv) * The lesson: if you do not need the `chart` or `query` attribute, do not use it. If you absolutely do need to use the `chart` or `query` attribute, then you have historically had to construct your query in such a way as to ensure that the data you want is considered by Google as data and _not_ as headers, otherwise Google strips out certain headers for you, which is what most people want. * I recently became aware of a new parameter available to the Google Chart Tools datasource API that instructs Google not to strip headers in this fashion, so as of Inline Google Spreadsheet Viewer version 0.13.1 (released today), you can add `csv_headers="1"` to your shortcode to restore stripped headers like this. * Let me know if, after updating, that does not work for you. * Thread Starter [tipsstar](https://wordpress.org/support/users/tipsstar/) * (@tipsstar) * [6 years, 6 months ago](https://wordpress.org/support/topic/table-first-row-text-missing/#post-12139663) * Thank you Meitar. Working like a charm. 🙂 * Plugin Author [Meitar](https://wordpress.org/support/users/meitar/) * (@meitar) * [6 years, 6 months ago](https://wordpress.org/support/topic/table-first-row-text-missing/#post-12139691) * Glad to hear it! * [ng1234](https://wordpress.org/support/users/ng1234/) * (@ng1234) * [6 years, 6 months ago](https://wordpress.org/support/topic/table-first-row-text-missing/#post-12140835) * Do not show [gdoc key=”[https://docs.google.com/spreadsheets/d/11mwHFlxPpIFu24sRxvcK1ZktkjvBQg1oTv035OSp_OI/edit#gid=67079046″](https://docs.google.com/spreadsheets/d/11mwHFlxPpIFu24sRxvcK1ZktkjvBQg1oTv035OSp_OI/edit#gid=67079046″); datatables_order=’%5B%5B 5, “desc” %5D%5D’ query = “select B,C,F,G,H,I”] * [geriebiffle](https://wordpress.org/support/users/geriebiffle/) * (@geriebiffle) * [6 years, 3 months ago](https://wordpress.org/support/topic/table-first-row-text-missing/#post-12434726) * If I use this shortcode I get the query results but no headers (the first row of data is displayed as the column headers): * [gdoc key=”[https://docs.google.com/spreadsheets/d/1AS_uvjotrQPAt06IIT3e25qVH7gTRWIYLO-BWHX-xMM/edit#gid=1108019399″](https://docs.google.com/spreadsheets/d/1AS_uvjotrQPAt06IIT3e25qVH7gTRWIYLO-BWHX-xMM/edit#gid=1108019399″); csv_headers=”1″ query= “select * where C contains ‘Sinai’ order by A desc” ] * Am I applying the csv_headers=”1″ incorrectly? - This reply was modified 6 years, 3 months ago by [geriebiffle](https://wordpress.org/support/users/geriebiffle/). - This reply was modified 6 years, 3 months ago by [geriebiffle](https://wordpress.org/support/users/geriebiffle/). * [seekingescape](https://wordpress.org/support/users/seekingescape/) * (@seekingescape) * [6 years, 3 months ago](https://wordpress.org/support/topic/table-first-row-text-missing/#post-12479635) * I had missing headers too. Instead of the one suggestion, and your example: ` csv_headers="1"` * Per the 0.13.1 Changelog notes, I added the statement without the quotes: `csv_headers =1` and it worked for me. Viewing 7 replies - 1 through 7 (of 7 total) The topic ‘Table first row text missing’ 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/) * 7 replies * 5 participants * Last reply from: [seekingescape](https://wordpress.org/support/users/seekingescape/) * Last activity: [6 years, 3 months ago](https://wordpress.org/support/topic/table-first-row-text-missing/#post-12479635) * Status: resolved