-4

I need some data (text/numbers) from specific columns or rows of EXCEL to be received into Google Sheets.

player0
  • 124,011
  • 12
  • 67
  • 124
Abu Saeed
  • 3
  • Welcome. Please add a brief description of your search/research efforts as is suggested in [ask]. – Rubén Dec 01 '19 at 17:35

1 Answers1

2

you need to upload your excel file to Drive convert it to Sheets and use IMPORTRANGE to extract given range into your spreadsheet.

uploading can be automated via https://www.google.com/drive/download/backup-and-sync/

conversion can be automated via https://stackoverflow.com/a/55645062/5632629

and IMPORTRANGE formula syntax is:

=IMPORTRANGE("spreadsheet_ID_here"; "sheet_name_here!A1:D20")
player0
  • 124,011
  • 12
  • 67
  • 124