1

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.

Melissa
  • 41
  • 4

2 Answers2

2

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:

https://docs.google.com/spreadsheets/d/1XQnp7RK-Ddq4wCjpHjmcnVEKood1U08kIfRGr8sDRoU/export?format=csv&gid=0

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:

  • enter image description here
  • enter image description here
SputnikDrunk2
  • 3,398
  • 1
  • 5
  • 17
  • @Melissa My apologies for the inconvenience this issue has caused you. May I know if you're open to any alternative solution? – SputnikDrunk2 Mar 23 '22 at 06:01
  • Thanks for your answer! The alternate export url works perfectly. – Melissa Mar 23 '22 at 15:03
  • Thank you @SputnikDrunk2 it worked for me as well. Note: If anyone wants the specific sheet, should update gid=SHEET_ID (it's shown in the Google Sheets URL when the specific sheet is selected) – HumanoVirtual Sep 02 '23 at 13:18
0

If you set the column to 'Plain text' under the Format menu > Number, you should receive the data upon export.

Yuval
  • 3,207
  • 32
  • 45