Converting google spreadsheet to MS excel but values only without the formulas

[David_Hwang]

Hi,

I am trying to convert a google sheets into an MS excel file and I am able to do this but the file won’t open correctly due to having formulas (array formulas) that are not compatible with MS excel. I really don’t need the formulas to be converted to excel but only the values. Is there a way to achieve this with the modules available in Make.com? I would appreciate some advice!

Thanks!

[samliew]

Welcome to the Make community!

Yes, that is possible. You’ll need a minimum of two modules:

1. Make sure you are exporting it as Excel format

2. Upload to OneDrive, which should make it available in MS365 Excel

Give it a go and let us know if you have any issues!

samliew – request private consultation

Join the unofficial Make Discord server to chat with other makers!

[David_Hwang]

Thanks, @samliew

but once I download the file and open it, I see this message.

I click on yes and I have this message below.

So that is why I want to find out how to just extract the values from Google sheets to Excel and not the formulas. I hope this explanation helps.

[samliew]

In that case you can export as CSV

Follow this, but change PDF to CSV: Convert doc / docx to pdf - #6 by samliew

samliew – request private consultation

Join the unofficial Make Discord server to chat with other makers!

[David_Hwang]

It worked! thank you so much!!