Skip to main content
Web Applications

Return to Question

added 2 characters in body
Source Link
user0
user0
  • 27.1k
  • 10
  • 53
  • 78

Scenario:
I

I get an email every two weeks with a vendor's price list as a link to an Excel file in their Dropbox.

At this point, I have to:

  • open the link — This takes me to Dropbox, where the file is opened in a preview mode that is not compatible with cut and paste into a spreadsheet.
  • download the file to my computer — I have a choice to download to my computer or copy to my Dropbox.
  • upload the file to my Google Drive — To do this I go to any open Google app tab, click New, Upload, grovel through the file structure to find it.
  • from there I can open it with Google Sheets.
  • copy 6 columns of data out of the sheet, and
  • dispose of the file.

What I would like to do in Google Sheets is to open the file directly as a read only-only file and save a bunch of steps.

My personal account is inon Gmail. I use the web interface.

Is there a way to easily open this link directly as a sheet?

Scenario:
I get an email every two weeks with a vendor's price list as a link to an Excel file in their Dropbox.

At this point, I have to:

  • open the link — This takes me to Dropbox, where the file is opened in a preview mode that is not compatible with cut and paste into a spreadsheet.
  • download the file to my computer — I have a choice to download to my computer or copy to my Dropbox.
  • upload the file to my Google Drive — To do this I go to any open Google app tab, click New, Upload, grovel through the file structure to find it.
  • from there I can open it with Google Sheets.
  • copy 6 columns of data out of the sheet, and
  • dispose of the file.

What I would like to do in Google Sheets is to open the file directly as a read only file and save a bunch of steps.

My personal account is in Gmail. I use the web interface.

Is there a way to easily open this link directly as a sheet?

Scenario:

I get an email every two weeks with a vendor's price list as a link to an Excel file in their Dropbox.

At this point, I have to:

  • open the link — This takes me to Dropbox, where the file is opened in a preview mode that is not compatible with cut and paste into a spreadsheet.
  • download the file to my computer — I have a choice to download to my computer or copy to my Dropbox.
  • upload the file to my Google Drive — To do this I go to any open Google app tab, click New, Upload, grovel through the file structure to find it.
  • from there I can open it with Google Sheets.
  • copy 6 columns of data out of the sheet, and
  • dispose of the file.

What I would like to do in Google Sheets is to open the file directly as a read-only file and save a bunch of steps.

My personal account is on Gmail. I use the web interface.

Is there a way to easily open this link directly as a sheet?

added 2 characters in body; edited title
Source Link
Alex
Alex
  • 22.8k
  • 12
  • 83
  • 104

Given a shared dropboxDropbox link to an excelExcel file, how can I easily open it in google sheetsGoogle Sheets?

Scenario: 
I get an email every two weeks with a vendor's price list as a link to an excelExcel file in their drop boxDropbox.

At this point, I have to:

  • open the link: — This takes me to drop boxDropbox, where the file is opened in a preview mode that is not compatible with cut and paste into a spreadsheet.
  • download the file to my computer, — I have a choice to download to my computer or copy to my dropboxDropbox.
  • upload the file to my Google Drive, — To do this I go to any open googleGoogle app tab, click New, Upload, grovel through the file structure to find it.
  • from there I can open it with Google sheetsSheets.
  • Copycopy 6 columns of data out of the sheet, and
  • dispose of the file.

What I would like to do in google sheetsGoogle Sheets is to open the file directly as a read only file and save a bunch of steps.

My personal account is in gmailGmail. II use the web interface.

Is there a way to easily open this link directly as a sheet?

Given a shared dropbox link to an excel file, how can I easily open it in google sheets?

Scenario: I get an email every two weeks with a vendor's price list as a link to an excel file in their drop box.

At this point, I have to:

  • open the link: This takes me to drop box, where the file is opened in a preview mode that is not compatible with cut and paste into a spreadsheet.
  • download the file to my computer, I have a choice to download to my computer or copy to my dropbox.
  • upload the file to my Google Drive, To do this I go to any open google app tab, click New, Upload, grovel through the file structure to find it.
  • from there I can open it with Google sheets.
  • Copy 6 columns of data out of the sheet, and
  • dispose of the file.

What I would like to do in google sheets is to open the file directly as a read only file and save a bunch of steps.

My personal account is in gmail. I use the web interface.

Is there a way to easily open this link directly as a sheet?

Given a shared Dropbox link to an Excel file, how can I easily open it in Google Sheets?

Scenario: 
I get an email every two weeks with a vendor's price list as a link to an Excel file in their Dropbox.

At this point, I have to:

  • open the link — This takes me to Dropbox, where the file is opened in a preview mode that is not compatible with cut and paste into a spreadsheet.
  • download the file to my computer — I have a choice to download to my computer or copy to my Dropbox.
  • upload the file to my Google Drive — To do this I go to any open Google app tab, click New, Upload, grovel through the file structure to find it.
  • from there I can open it with Google Sheets.
  • copy 6 columns of data out of the sheet, and
  • dispose of the file.

What I would like to do in Google Sheets is to open the file directly as a read only file and save a bunch of steps.

My personal account is in Gmail. I use the web interface.

Is there a way to easily open this link directly as a sheet?

Clarified in response to comment.
Source Link
Sherwood Botsford
Sherwood Botsford
  • 804
  • 2
  • 12
  • 33

Scenario: I get an email every two weeks with a vendor's price list as a link to an excel file in their drop box.

At this point, I have to:

  • open the linkopen the link: This takes me to drop box, where the file is opened in a preview mode that is not compatible with cut and paste into a spreadsheet.
  • download the file to my computer, I have a choice to download the file to my computer, or copy to my dropbox.
  • uploadupload the file to my Google Drive, To do this I go to any open google app tab, click New, Upload, grovel through the file structure to my Google Drive, andfind it.
  • from there I can open it with Google sheets.
  • Copy 6 columns of data out of the sheet, and
  • dispose of the file.

What I would like to do in google sheets is to open the file directly as a read only file and save a bunch of steps.

My personal account is in gmail. I use the web interface.

Is there a way to easily open this link directly as a sheet?

Scenario: I get an email every two weeks with a vendor's price list as a link to an excel file in their drop box.

At this point, I have to:

  • open the link,
  • download the file to my computer,
  • upload the file to my Google Drive, and
  • from there I can open it with Google sheets.
  • Copy 6 columns of data out of the sheet, and
  • dispose of the file.

What I would like to do in google sheets is to open the file directly as a read only file and save a bunch of steps.

My personal account is in gmail. I use the web interface.

Is there a way to easily open this link directly as a sheet?

Scenario: I get an email every two weeks with a vendor's price list as a link to an excel file in their drop box.

At this point, I have to:

  • open the link: This takes me to drop box, where the file is opened in a preview mode that is not compatible with cut and paste into a spreadsheet.
  • download the file to my computer, I have a choice to download to my computer or copy to my dropbox.
  • upload the file to my Google Drive, To do this I go to any open google app tab, click New, Upload, grovel through the file structure to find it.
  • from there I can open it with Google sheets.
  • Copy 6 columns of data out of the sheet, and
  • dispose of the file.

What I would like to do in google sheets is to open the file directly as a read only file and save a bunch of steps.

My personal account is in gmail. I use the web interface.

Is there a way to easily open this link directly as a sheet?

Source Link
Sherwood Botsford
Sherwood Botsford
  • 804
  • 2
  • 12
  • 33