Hot answers tagged

15

Basics: This is not as straight forward as a normal import using the IMPORT function. With this function, you are able to perform imports only: =IMPORTRANGE("key","range") Adding a function, like SUM or FILTER, within the "range" string will result in an error. The solution must be found, by using the QUERY function: =QUERY(...


13

I have had the same need for quite some time. And because I couldn't find anything suitable, I've built my own app. It's called Calify. http://www.califyapp.com The installer registers the app as the default program for handling *.ics files, so it works for both opening e-mail attachments and downloading event detail exports from webpages. It does not ...


9

If you are using Google Chrome then you can make Google Calendar your handler for ICS files: Click the Chrome menu on the browser toolbar. Select Settings → Show advanced settings (at the bottom of the screen) In the Privacy section, click Content settings (you'll need to scroll down) Click on Manage handlers... and associate webcal with "Google ...


8

diagrams.net online supports the legacy .vsd format and the .vsdx format, which is the default format from the 2013 and 2016 versions of the tool. The actual process of importing to either drag and drop the .vsd(x) file into a diagram, use "File->Import From", or "File->Open From".


6

Most of the solutions I saw here were pretty technical. Here is one that is really easy to do. You could use this Zap to automatically create Trello Cards from Google Docs spreadsheet rows. The idea is that once you make this Zap, you can paste your CSV into the a Google Doc and run it through into Trello. I think there is a limit of about 200 items per 10 ...


6

If you press Ctrl+A, it will select all of the individual notes with its own interface. On the top, the yellow horizontal bar will become dark grey. The rightmost button of the center grouping is three vertical dots. If you click that, there's an option to Copy to Google Doc. Click that and there's a little dialog box that will soon give you a link that says ...


6

Short answer While it's possible to use files stored in Google Drive as website resources at this time it's not officially supported and should not be used for websites and spreadsheets that have a lifespan beyond August 31, 2016. As was mentioned by AE I in his answer to a related question, the use of https://docs.google.com/uc?export=view&id=FILE_ID is ...


5

You can now go to https://google.com/takeout and choose Keep as an option. This will create an archive of hyperlinked HTML notes that should contain all of your content.


5

Here is the solution that I was able to use to resolve a similar need to import historical data as actual form responses. the code first opens the form I created, and the spreadsheet with the historical data in the array named "values". The for loop cycles through each line of the spreadsheet, populating each item of the form, and then submitting each ...


5

The spreadsheet is not the actual repository of responses. There is a 'bucket' of responses that is connected to the form itself. The data presentation features use the responses connected to the form. You need to use a script to add the extra responses to the Form object. You won't be able to save the original dates with the old responses, as the ...


4

There is an official tool by the google liberation front to import and export google sites: From the website: "The downloaded site will not be styled and will not include the chrome and is completely unstyled, but will contain all of the content included in the site." http://web.archive.org/web/20130806050134/http://www.dataliberation.org/google/sites ...


4

See this: Blogger Help: Import and export blogs To make a copy of your blog's posts and comments, you have to export your blog and then import it to another existing blog. Export Your blog To export your blog, simply click "Export Blog" from the Settings | Other tab. Then, click the Export Blog button. Your blog will be stored as a ...


4

I used @Jean-Francois answer together with Mogsdad to achieve my task: to merge data coming from many identical forms into just one. I added a skip for empty answers, as my form had many non required questions and jumping sections. To "upload" about 1000 responses with 30 items, I had to run twice the script because of timeout, just by changing initial row ...


4

If you follow these steps, then you will get the job done: go to Google Calendar settings go to 'calendar' 'import calendar' import the .ics file now tick the sync option under 'email account management' on your blackberry


4

Just announced from the Gmail team: Easily add events from attachments in Gmail into Google Calendar Now when you receive an attachment with calendar events in .ics format, you can add these events to your Google Calendar right from Gmail with just one click. No more downloading and manually importing! Plus, events created in Google Calendar will link back ...


4

Open the document Go the File menu and select Make a copy... Give the document a new name You can optionally share it with the same people as the original Comments are not copied Click "OK" If you only have a link, because the author use the "Publish to the web..." tool, simply follow the link beneath the document to Google Drive, log in (if necessary), ...


4

I made a two lines script to use the share link of an image in Google Drive. Go to Tools > Script editor. Copy, paste the following code Click on run for permission function DRIVE_IMAGE(link){ prefix_url = "https://docs.google.com/uc?export=download&"; link.replace("open?", "uc?export=download&"); } Using the script : Copy the share link ...


4

If the other calendar is shared with you and available in the "Other Calendars" section in Google Calendar, you can save the ICS version of the calendar and import that into your own. To do this: Go to Google Calendar Click the ellipsis to the right of the "other calendar" that has all the events. Select Settings. In the Integrate Calendar section, find ...


3

Had this same issue: This is what I ended up using. =iferror(QUERY(IMPORTRANGE("https://docs.google.com/spreadsheets/d/[YOUR_KEY_FROM_URL]/edit","Title of Sheet You are Using!A2:I42"),"select * WHERE Col5 CONTAINS 'Towel'",1),"no values yet!") Lets break it down a bit IFERROR allows you to display a user friendly message if this fail because no data is ...


3

You'll need to make a spreadsheet. Then go to tools>script editor. You can cut/paste the script below replacing all of the contents that were put in by default. You'll need to add your folder ID where it says THIS_SHOULD_BE_YOUR_FOLDER_ID (leave the quotes). Save it. Hit the play/run button You'll need to give it permission to run when asked. That should ...


3

Foursquare doesn't support importing exported data. Once it's exported you can import it to Google Maps.


2

Use the ImportExportTools add-on in Thunderbird. Within seconds you can import .eml files to Thunderbird. If you have added Gmail to Thunderbird, Gmail will then do a sync within no time.


2

Here is my suggestion for the script as I used for my project. I have modified the script by Tom to adjust when fields have different types of data (and in my case Section Headers where we should not do anything for). I used a "switch" and a "asTypeItem" to do the trick but if anybody got a better suggestion, I'm all ears! We can also easily adapt the ...


2

You can now do this in two simple steps: Download Google Drive for your computer. Download the PDF to the Google Drive folder you just created. Expanding on the above steps: Step 1: Download Google Drive for your computer. 1) Go to http://drive.google.com. 2) You should see "Install Drive for your computer" as highlighted in green in the picture below; ...


2

You can only save wallpapers, snaps, and other links to Google Drive using the "Save to Gdrive" extension for the Chrome browser.


2

When you have an HTML file in Google Drive and ask to open it with Google Docs, there's no 'convert' option AFAICT and you get a 'view source' sort of view instead of seeing it rendered. If you have the HTML file saved locally and you upload from the Google Docs page itself, there is a 'convert' option in the upload dialog, and that will produce a rendered ...


2

The Account and Import tab has disappeared (2009) and returned only Accounts. See the following two references from Google on how to export/import: Import email and contacts Centralize mail from different accounts with Mail Fetcher


2

Workaround for Windows 10: use the Calendar app add your Google calendar to the Windows Calendar app (Start -> Calendar -> Settings -> Manage accounts -> add account) make sure .ics files are opened with the Calendar app (Settings -> Choose a default app by file type -> .ics -> Choose an app -> Calendar) Now, when an .ics file is downloaded from a web site,...


2

A stab in the dark (but OP seems unlikely to revisit in the near future to provide clarification of the requirement): =indirect("'Form Responses'!"&"A4")


2

The best and easy way to handle this is by using substitute formula and having two columns here is the explanation below: Column A5: just put google drive image shareable link e.g. "https://drive.google.com/open?id=1CfUnvGGdt96irA419HnU0BvRafD4F_os" Column B5: use the combination of two formula image and substitute like this: =image(substitute(A5,"open?id",...


Only top voted, non community-wiki answers of a minimum length are eligible