# Download Specific Google Sheet as CSV

**URL:** <https://forum.rclone.org/t/download-specific-google-sheet-as-csv/46780>\
**Category:** Help and Support\
**Created:** [July 11, 2024, 9:35am UTC](https://forum.rclone.org/t/download-specific-google-sheet-as-csv/46780 "2024-07-11T09:35:23Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![michael.tester](https://forum.rclone.org/letter_avatar_proxy/v4/letter/m/dbc845/32.png) [@michael.tester](https://forum.rclone.org/u/michael.tester)\
**Post date:** [July 11, 2024, 9:35am UTC](https://forum.rclone.org/t/download-specific-google-sheet-as-csv/46780/1 "2024-07-11T09:35:23Z")

</div>

#### 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.

```auto
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`)

```auto
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.

```auto
[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.

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

```

---

<div class="post-metadata">

**Author:** ![asdffdsa](https://forum.rclone.org/letter_avatar_proxy/v4/letter/a/848f3c/32.png) [@asdffdsa](https://forum.rclone.org/u/asdffdsa)\
**Post date:** [July 11, 2024, 3:12pm UTC](https://forum.rclone.org/t/download-specific-google-sheet-as-csv/46780/2 "2024-07-11T15:12:28Z")

</div>

welcome to the forum,

> [@michael.tester](#):
>
> Expectation: If the spreadsheet has 2 sheets, I can export first sheet as first\_sheet.csv and second sheet as second\_sheet.csv

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?

---

<div class="post-metadata">

**Author:** ![michael.tester](https://forum.rclone.org/letter_avatar_proxy/v4/letter/m/dbc845/32.png) [@michael.tester](https://forum.rclone.org/u/michael.tester)\
**Post date:** [July 11, 2024, 5:02pm UTC](https://forum.rclone.org/t/download-specific-google-sheet-as-csv/46780/3 "2024-07-11T17:02:42Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![asdffdsa](https://forum.rclone.org/letter_avatar_proxy/v4/letter/a/848f3c/32.png) [@asdffdsa](https://forum.rclone.org/u/asdffdsa)\
**Post date:** [July 11, 2024, 5:06pm UTC](https://forum.rclone.org/t/download-specific-google-sheet-as-csv/46780/4 "2024-07-11T17:06:37Z")

</div>

> [@michael.tester](#):
>
> I would like to know if rclone supports exporting a Google Spreadsheet (a single file with multiple sheets) into multiple individual _.csv_ files?

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?

---

<div class="post-metadata">

**Author:** ![system](https://forum.rclone.org/uploads/default/original/2X/3/39ad3235f6ffec76ccd0c81616bd55697b4c300d.png) [@system](https://forum.rclone.org/u/system)\
**Post date:** [August 10, 2024, 5:07pm UTC](https://forum.rclone.org/t/download-specific-google-sheet-as-csv/46780/5 "2024-08-10T17:07:28Z")

</div>

Closed on August 10, 2024, 5:07pm UTC

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