Google Sheet gviz csv export - two column labels not exporting
I'm trying to export this Sheet to a csv for use in a webmap using this link: https://docs.google.com/spreadsheets/d/1XQnp7RK-Ddq4wCjpHjmcnVEKood1U08kIfRGr8sDRoU/gviz/tq?tqx=out:csv&sheet=Sheet1
It works well, except that two of the column headers (lat, long) are not exporting and the column labels in the csv are blank. I tried to change the format of the cell from Automatic to Plain text, but that didn't fix it.
Findings
It seems this is an issue with gviz api as there's an ongoing Google Issue tracker report about it. You may want to click the star icon on the top left of issue report page to indicate that your are also affected by this issue.
UPDATE
As an alternative solution, you may try this way as this will export the same csv file:
Reference: Download link for Google Spreadsheets CSV export
Test
I did some quick tests on my end & after manually downloading the sheet file as a Comma Separated Values (CSV) file from the Google Sheet UI & after using the alternative solution, there's no issue with missing cells. But when using the gviz api link, the issue occurs:
- Javascript case sensitive
- Can I alter a formula using the cell number instead of its cell value?
- Dynamically referencing worksheets to dynamically fill a table based on a condition
- How do you add UI inside cells in a google spreadsheet using app script?
- How can I force data input into cells in Google Sheets to be in a desired date format?
- How do I find a partial match from a data table to an individual cell?
- Highlighting non-first instance duplicates of words and counting highlighted cells
- Lock google sheets for data entry after a wrong entry
- Schedule View: INDEX MATCH from table and return multiple cells into one
- How to Show/Hide rows in google sheets using a script?
- Popping a Modal Dialog when changing the drop down entry in Google Sheets
- Transfer background color from cell range to drop down options
- How can I match a smart chip using SUMIF?
- List Google drive folder contents to google sheets with only new files
- Trying to figure out why my GoogleSheets Date formula is not working
- Count if name matches and outcome is complete
- Google Sheets Row Number of last row in a defined table
- How can I use INDEX and MATCH along with conditions to filter data into different tables?
- Google Sheets formula to remove all punctuation excluding period (.)
- Formula to find missing serial numbers
- Google Sheet Vlookup Multiple Criteria
- Copy Data from one column and past at the end of another column
- Query formula not grouping properly
- Comparing text fields that contain dates in Google Sheets
- Signature Pad (Canvas) to Google Sheets
- How to use the cell number instead of its value in a Filter + Importrange
- regexreplace multiple columns for football data
- I want to use a macro to check a value in a sheet and return one of two values
- How can I remove consecutive duplicates from a range in Google Sheets?
- Using FILTER with multiple conditions on Google Sheet