google sheet to excel

GSHEETS(SURL) - Given the "Anyone with the link" Share URL from Google Sheets (SURL), provides URL to use in a Web Power Query to retrieve data from the Google Sheet file. =LAMBDA(SURL, LET(base,"https://docs.google.com/spreadsheets/d/", tail...

hi all i am trying to get 5% of upcoming result auto in case of new value entered in Cell C i have try below formula but its not work =arrayformula(IF(C5:C="","",(D4*1.05)))

Watching this video, I figured out how to set up a live connection to a Google Workbook through Power Query. Basically, you copy the URL for sharing, and then set up a URL with an ID gleaned from that URL. The ID is between the /d/ and the last / of the URL provided. The video is 2 years old...

Hello! I need help figuring out how to get a formula I had working on Google Sheets to now work in Excel and was counting on this community's expertise, please! I basically have a table with ticket items where one of the columns for each ticket is called Linked Issues. If an item from my table...

I know this may be a large ask and may not be possible but I am new to VBA and never really used sheets before in a very elaborate fashion. I didn't realize that the excel sheet with vba wouldn't translate to sheets so I need to convert my vba code to google script so that it will work in...

Hi All, Below is my problem: I have a excel file which have 8 different sheets and eachsheets contains a table of data which range is “D6: Q2926”. In every sheet ofthose 8 sheets, same range data is available and that sheet is uploaded togoogle docs for editing. Now for security purpose, I am...