Download Specific Google Sheet as CSV

Help and Support
1

What problem are you having with rclone?

I am experiencing an issue with downloading a specific Google Sheet as a CSV. When I attempt to export Google Sheets as CSV, only the first sheet is exported.

Expectation: If the spreadsheet has 2 sheets, I can export first sheet as first_sheet.csv and second sheet as second_sheet.csv .

Run the command 'rclone version' and share the full output of the command.

rclone v1.67.0
- os/version: alpine 3.20.0 (64 bit)
- os/kernel: 5.10.0-29-amd64 (x86_64)
- os/type: linux
- os/arch: amd64
- go/version: go1.22.4
- go/linking: static
- go/tags: none

Which cloud storage system are you using? (e.g., Google Drive)

Google Drive.

The command you were trying to run (e.g., rclone copy /tmp remote:tmp)

rclone -vv --config rclone.conf copyto "gdrive:File - Me.csv" "config.csv" --drive-export-formats csv

Please run 'rclone config redacted' and share the full output. If you get 'command not found', please make sure to update rclone.

[gdrive]
type = drive

A log from the command that you were trying to run with the -vv flag

I can't share the full verbose logs because they contain credentials.

2024/07/11 09:31:50 INFO  :
Transferred:              0 B / 0 B, -, 0 B/s, ETA -
Elapsed time:         1.8s
2

welcome to the forum,

what other cloud copy tool or program can export a multi-sheet google sheet into multiple individual .csv files?
afiak, with ms-excel, on a local file, trying to export a multi-sheet .xlsx to .csv is not possible without scripting.

does gdrive website have that functionality?

3

Thank you for your reply, really appreciate it,

Actually, that is my question. I would like to know if rclone supports exporting a Google Spreadsheet (a single file with multiple sheets) into multiple individual .csv files? Perhaps I haven't found the relevant documentation yet.

4

never heard of that feature.
rclone relies on google for the exporting.

that is why i asked:

  • does gdrive website support that feature, where is that documented?
  • what other programs supports that feature?
5

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.