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.

Filter by
Sorted by
Tagged with
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 ...