pbutler83's Avatar
pbutler83 3
27 Asked
2 Answered
0 Best
0
No one has voted on this question yet :(
2 years, 2 months ago

Can you embed a file in a google spreadsheet cell?

Can you embed a file (or a clickable link to a google docs file) in a google spreadsheet cell?

Here's what I tried so far:

1. I uploaded the pdf to google.
2. I got the link of the pdf and pasted it in the cell

The problem with this is that when I click on the cell, it just has the text, and doesn't transport you directly to the file.

Thanks!
Tip for best answer: M$4.00
Separate topics with commas, or by pressing return. Use the delete or backspace key to edit or remove existing topics.

You can leave an optional "tip" with Mahalo's virtual currency, Mahalo Dollars. If you are asking a difficult question that might require some research, or if you'd like a wide variety of feedback, a higher tip often leads to more answers to your question.

M$

What is Your Answer?

0
0
0

2 Answers

0
justin_time's Avatar
justin_time | 2 years, 2 months ago
2
After much fiddling, I got this to work.

1) Go to http://createpdf.neevia.com/ Select jpeg output format. For resolution, set 100 (this may have to be adjusted; Google only allows pixels of up to x1250, some trial and error may be required).
2) Upload your pdf in the box labled 2.
3) Leave the delivery method to its default "wait for conversion in browser."
4) Click on the file name to open a new window and get the link
5) Click in a cell and select insert image and paste your web link

I don't know exactly what you're trying to do, but this will get the pdf document embedded in the Google Spreadsheet.

I fooled with many other things, and this was the only thing I could get to work. There may be other ways, mind you.

You can leave an optional "tip" with Mahalo's virtual currency, Mahalo Dollars. If you are asking a difficult question that might require some research, or if you'd like a wide variety of feedback, a higher tip often leads to more answers to your question.

M$

Report Abuse

Post Reply Cancel
0
dilvie's Avatar
dilvie | 2 years, 2 months ago
4
To upload the file to Google docs:

1. Open Google Docs http://docs.google.com/
2. Select "Upload" (next to the file menu, upper left)
3. Select files to upload
4. Uncheck the convert checkbox and click "Start Upload" and wait for the progress meter to complete
5. Click the newly hyperlinked filename, and click share -> get link to share
6. Check "Allow anyone with url to view" and click save and close

Type this into a cell:

=HYPERLINK( "http://locationofyourfile.com/yourfile.pdf" ; "Title of your PDF File" )

Working example:
=HYPERLINK( "https://docs.google.com/leaf?id=0BygaPM8JvuQ7M2M4YzlmZTAtNjM0YS00ODVlLTljNmItOGJmZDBkYzMzMmI0&hl=en"; "Test File")

You can leave an optional "tip" with Mahalo's virtual currency, Mahalo Dollars. If you are asking a difficult question that might require some research, or if you'd like a wide variety of feedback, a higher tip often leads to more answers to your question.

M$
justin_time's Avatar
justin_time | 2 years, 2 months ago Report

I tried your method and all I could get was the Title of your pdf here" displayed in the cell. Can you create an example via your method and paste the URL so I can see what you did to get it to work?

Report Abuse

Post Reply Cancel

Learn something new with our FREE educational apps!

Private lessons in the comfort of your own home. Get back in shape or finally pick up a guitar with our great experts guiding you the whole way!
Learn Guitar
Learn Hip Hop
Learn Pilates