How to retrieve data from a google sheet on a Gdrive to an excel file in the same google drive

[Maxime_LAUGIER]

Hello everyone,

I’m trying to get some sheet data from a google sheet file and export it to an XLSX excel file.

The worry I have is that the copy works but when copying, it does not copy the cell values but also with the formulas, so some some cells are in #N/A
Attached is the screenshot.

Do you have any idea if this is possible?

The 2 files are located in a shared google drive.

Thank you

[Anil_G (Anil Gorthi)]

@Maxime_LAUGIER

copy sheet would ideally replicate the data

instead if you need only values use copy paste range in that you have options to select paste type as well

cheers

[Maxime_LAUGIER]

@Anil_G

copy paste range

Thank you

i would like the full sheet and i got this error

[Maxime_LAUGIER]

It’s works.

Thank you @Anil_G