Questions tagged [google-docs]
A web-based office suite. Questions may be off topic and should be asked on webapps.stackexchange.com unless specifically involving your browser or computer.
136
questions
4
votes
4
answers
2k
views
How do I create a desktop shortcut to create a new Google Doc?
It is tiresome to open Google Drive in a browser and from there clicking "New document ...". So how do I find and store the URL for creating a new document so that I can put a shortcut on my desktop?
27
votes
3
answers
32k
views
How do I get Google Drive to open text files with arbitrary extensions as text files?
I have text files on Google Drive that do not end with the .txt suffix (such as: .r, .bas, .awk...).
I want to view them using the Drive Notepad app, but it does not recognize the files as text.
Is ...
0
votes
2
answers
120
views
Converting lots of Excel files to Word
I have around 30 Excel spreadsheets, each with 20+ worksheets. Each of these worksheets follows the same basic format, though there are slight differences. I also have a Google doc with sections ...
1
vote
1
answer
217
views
CSV file - Combine title if value=YES in another cell - Libreoffice / Excel / Googledocs
I have a file with text divided into cells that I want to group into another cell.
Cells are:
A, B, C, and D are what I have. In each coluimn, if the value is Yes, I would like the Result column to ...
0
votes
1
answer
382
views
Combine GoogleSheets functions
I'm trying to combine multiple functions into one formula in GoogleSheets spreadsheet.
I've tried learning more from Google's Help center and through YouTube but didn't came to satisfactory result.
...
4
votes
6
answers
23k
views
Why is Google Docs slow on OSX / Chrome?
I recently noticed Google Docs is very slow on my MacBook (mid 2011 with OS 10.8.5) when using it in Chrome (latest version 35.0.1916.153). Safari seems to be doing OK. Tested it on another MacBook of ...
1
vote
2
answers
2k
views
How does one share OneDrive (Office 365) documents without requiring authentication?
You might have seen online that when people share a Google Docs document, they can just post a link and anyone can open it, right?
Well, it turns out that when you do this with Office 365, making a ...
0
votes
0
answers
334
views
All Google services aren't working in Firefox 60.0.1
I'm using Firefox 60.0.1 64bit without plugins. But not a single Google service is working.
As for mail, all the buttons are empty, without icons.
Google image search doesn't load full pictures, ...
2
votes
1
answer
1k
views
Clean up CSV based on another CSV
I have a csv file named master.csv, which has the following columns
link, name
And another csv file called details.csv, which has the following columns
link, name, price, desc
I want to match ...
9
votes
3
answers
1k
views
How to print/upload (a web-page) directly into my Google Drive account?
Is it possible to, from the OS X 10.6 print dialog, print the web-page directly into my Google Documents account? I can save as PDF and upload it, but, well, I want to cut out the middleman (ie, me; ...
0
votes
1
answer
48
views
What could be causing google sites to show source in just Firefox
Some websites just go horribly weird in Firefox, but whenever I search I cannot find anyone else with the same problem.
It isn't fonts, it isn't character encoding.
What I see is the real website ...
0
votes
1
answer
28
views
Separate content of a cell by spaces
I have a spreadsheet on Google Docs, in which are multiple columns. Each row contains all the data tags in one cell. So it is not separated under columns. How could I separate it into more cells? ...
0
votes
1
answer
280
views
Concurrent document collaboration on local servers [closed]
Does a concurrent office document collaboration service exist that does not rely on 3rd party servers?
By "collaboration" I mean changes made to a document are quickly visible to others that have the ...
8
votes
4
answers
17k
views
Google Docs drawings to Visio
Is there a way to export drawings made with Google Docs to Visio? Maybe through some other software. I can see that Lucidcharts supports both Google Drive and export to Visio, but does it actually ...
1
vote
0
answers
159
views
How to get Pentadactyl to work with Google Docs
It appears to be a well-documented fact that Google Docs does not work when using Pentadactyl (I believe it's some kind of focusing issue).
I've spent many hours googling about this, and have yet to ...
3
votes
3
answers
26k
views
Excel lookup data from google docs spread sheet
Can excel lookup values from a spreadsheet in google docs? I would like my current excel forms to be able to lookup data from a spread sheet that used to be held on our server but now is a google ...
2
votes
2
answers
90
views
How to test which MS Word files can be correctly edited in Google Docs?
Is there a way to test/verify which MS Word files can be correctly edited in Google Docs and no formatting will be lost if files are exported back to MS Word format?
Basically, I have quite a number ...
3
votes
1
answer
2k
views
How to synchronize SugarSync and Google Docs automatically?
I would like to be able to edit one of my SugarSync files directly from a Google Docs interface and save it online directly to SugarSync (and then be able to go back to my home computer and have the ...
0
votes
1
answer
220
views
Google Docs / Exel - need to know how to add formula
I'm using Google Docs / Exel and can't work out how or where to add a 'formula'.
I have a column "i" which is the number of items. I have another column "j" which is the cost of those items. Column ...
0
votes
1
answer
160
views
Windows 7 Google Print Service
I'm wondering if there's any way to use a custom Windows 7 print service to send documents directly to Google Docs. My end goal is to use Google Cloud Print to be able to print any document from my ...
2
votes
1
answer
482
views
GMail as mail-in database for attachments?
I'm a teacher and I get students to submit work by email. It would be great if anything they attach could automatically be added to my Google Docs with their name or email address as a label, without ...
0
votes
1
answer
73
views
Google Slides Translations
I'm using Google Slides on my tablet, and I don't know how to add transitions and animations to slides. Is there any solution or app doesn't have option for that.
2
votes
1
answer
2k
views
Why is the Google Drive template will no longer be available after 2016?
I'm using constantly with templates at MS Word, and I seek to move away from it to use only with Google Docs as much as I can for ease my workflow.
But I encounter this help page not long ago, and it ...
24
votes
10
answers
14k
views
Google Docs: How to backup periodically?
How do I periodically backup my entire online documents in Google Docs? I am looking for a tool that can download the documents to my PC. I do not need any kind of two-way synchronization, just plain ...
6
votes
2
answers
10k
views
Migrate Google docs to Office 365, convert from .gdoc to .docx [closed]
Our company is switching from Google apps to Office 365. As I am one of the only using .gdocs documents I am tasked to convert them to .docx before we migrate by hand, or else I cannot open them ...
2
votes
1
answer
3k
views
Where are offline-editable Google Docs stored?
When you choose to save a Google Docs file for editing offline it creates a file in your Google Drive folder. However, that file is just a URL to the online Drive. Do you know where actual file is ...
1
vote
0
answers
70
views
followup on mass converting google docs
This question from apr '14 gives a way to download google docs as word, pdf or other files:
Migrate Google docs to Office 365, convert from .gdoc to .docx
select the files, click "more", then "...
0
votes
2
answers
93
views
Alternating text in word documents
I often want to alter my CV for different purposes, like only mention my German skills when it is relevant.
Is there a way I can have such alternate versions in one Word Document? OR
Alternatively ...
-1
votes
1
answer
47
views
Multi-document view for Google Docs [closed]
I started to use Google Docs for my notes, because I was not satisfied with Onenote and Evernote.
This works great so far, their apps and browser support is wonderful. However, the only thing that's ...
1
vote
1
answer
8k
views
How to calculate percentage in Google Docs [closed]
I have this google-doc: https://docs.google.com/spreadsheet/ccc?key=0Avl3X68NxHC-dFY2YWgzTnRVZm1xaWlBTFl6TU9NTkE&usp=sharing
Now I am trying to calculate the average (=average()) of the ...
0
votes
1
answer
988
views
Multiple row calculation with one fixed value
I have a calculation like this
=B8+((B2-1)*C8)
I want to multiple these calculation by just dragging it down. So I don't need to type the calculation for each row. The values B8 and C8 shall ...
0
votes
1
answer
916
views
Microsoft Excel: Merge two sheets and dedup
I have a pretty simple question and google can't seem to return what I'm looking for.
Essentially I have two sheets in one workbook, both contain the exact same columns. The primary key (and first ...
9
votes
2
answers
2k
views
Is it possible to access and edit Google documents directly from Libreoffice?
I'd like to work with a Google spreadsheet directly inside Libreoffice, without having to export and import it, in order to automatically reflect the changes on the online file.
Basically, I'm looking ...
1
vote
2
answers
806
views
Can I access Google docs on an offline public PC?
I want to make the switch to using Google docs so that I can stick to one family of editable file formats that can be opened on (almost) any device.
However, I work in an environment where I have to ...
8
votes
2
answers
25k
views
Opening .pdf's on Google Drive using Adobe Acrobat
Note: this is a question about Google Drive, not Firefox options.
I've been using Google Drive and Docs a lot, so I tend to keep .PDFs on Drive as well just for convenient storage.
But I don't like ...
7
votes
1
answer
28k
views
Can I link to another page in Google Docs? [closed]
I'm creating a large document (text, not presentation) in Google Docs, and I want to be able to link to other pages in the same document (like a pdf or # in the url). So far all I've found is how to ...
2
votes
4
answers
10k
views
Using COUNTIF in Excel to count number of "Greater than" values in an array of values
So here is my situation. I'm a principal creating a tracker for my teachers to use to track student growth on assessments. In the current tracker it is set up like this:
% of ...
2
votes
1
answer
15k
views
How do I copy rows based on single cell value in Google Sheets?
I have two sheets in Excel, which is duplicated on Google Sheets. Sheet 1 is a list of names with various bits of information for example
Name Number Outcome
Colin Smith ...
-3
votes
1
answer
1k
views
Open a .docx file with Office Online
With Google Drive they have complimentary products like Google Docs that opens the web editor when you double click it on your desktop. Is there a way to set that up with .docx files and Office Online....
0
votes
0
answers
84
views
Sync with Google Drive and Docs
I have a few friends who run a number of Google accounts and uses Google Drive (v3.2.2) and Google Docs (v1.1.3.5459) for iOS (8.1) with iPads. One of the friends has created a directory under Google ...
4
votes
2
answers
11k
views
How to synchronize Excel with Google Docs spreadsheet
This feature is not officially suported by Google. Do you know if is there a way or a product that allows to synchronize the changes performed in excel into a google spread sheet?
Create file in ...
0
votes
2
answers
446
views
How to assign rows in multiples of a number (Excel/Google Docs)
For example, I want the first entry in Column B (B1) to show A5, then B2 shows A10, then B3 shows A15.
How would I go about doing this?
20
votes
9
answers
40k
views
How do I automatically synchronize Google Docs with Dropbox?
I would like to be able to edit one of my Google Docs on another computer, save it online (not download it to that computer and upload it to Dropbox), and then be able to go back to my home computer ...
0
votes
1
answer
86
views
Tab corruption in multiple text file formats
In Google Docs, Wordpad, and Writer (for open office), tabs are being "forgotten" or haphazardly "inserted" where other tabs are. I don't think this issue is local to a particular program or file ...
0
votes
3
answers
3k
views
Not able to connect to Google docs, error message: The remote device or resource won't accept the connection
I have started facing a strange issue on my home network.
I am not able to connect to docs.google.com, it gives the following on firefox:
And in chrome:
When I troubleshoot the link it gives the ...
4
votes
0
answers
1k
views
How to add fold-marks to a Google Docs document?
This question is about how to get fold-marks (very similar to this question) to your document in Google Docs. It would be very helpful. If it is not feasible per se are there any workarounds?
6
votes
5
answers
1k
views
App created in spreadsheet vs programming a full application - is there a middle ground? [closed]
A colleague has a home-grown application in Google Documents, that involves users filling in a form, alternative questions being asked depending on what the answers are, and then outputting a ...
1
vote
0
answers
145
views
Going to print multiple cards in fixed size
I need to print out about 80 "cards" for an invitation and to fit the envelope I need to print them in a very exact size. Each "card" has to be 5cm in width and 7.5cm in height.
Instead of just ...
1
vote
1
answer
778
views
How can I auto-share anything sent to one Drive account with another?
People sometimes share Docs with my rarely used Google account. So I have to email them and ask them to use my main Google account instead.
It's a hassle for them and for me, plus it slows down our ...
1
vote
2
answers
45
views
How focus on the document after find?
I'm filling a column after finding a row via a search on the name column. So I do CTRL + F, type the name, and click the the cell with mouse to fill it. Is there a way to do this without using the ...