Import data from a Google sheet to Excel

[sitewolf]

OK, so if there's a different place for such questions, let me know....this is a question involving working with both Sheets and Excel
These days some of the data I need to scrape (sports stats) from the web is often easier using Sheets because coding on some sites yields empty sets when querying from Excel.

That said, my end game is to scrape the data, manipulate it for my purposes, and create a csv file I can then upload into my Sql database online.
Yes, of course, if I were more of a programmer I'd do a web scrape directly into my database, but not currently possible.

My Excel spreads use web queries to pull in the data, formulas to manipulate the data, then creates csvs where only the needed data remains. I can get to the point of creating the csvs in Sheets and I know how to create csvs there, but I'd rather import those sheets into an Excel file and create the csvs from there......only I can't figure out how to import from Sheets to Excel.

Any help? Or poking holes in my thought process?

 

[sandy666]

maybe Download - Microsoft Excel (xlsx) ?

 

[sitewolf]

Good thought, but that creates a new xlsx file.....where I guess I could then run the manipulations to create the csv files I need
Now I just recorded a macro to create the csvs, but there's no lines in the macro creating anything, just moving thru the 3 sheets I wanted to save....however, if I just save the entire file I guess I don't need the macro. More than one way to skin a cat! (where's that line come from....who's skinning cats?!)

 

[sandy666]

from downloaded xlsx you can drag sheet(s) to your original workbook then "manipulate" as you wish
if downloaded file contain single sheet , after drag & drop this file will disappear.

read blue line below