Hot answers tagged

49 votes

How to export a filtered set of rows from a Google Spreadsheet?

Create a new sheet (Sheet2) within the spreadsheet. Set the A1 cell to be =filter(Sheet1!A:X, Sheet1!A:A>1). (See docs on the filter function.) You should then be able to save or export Sheet2 as ...
  • 832
34 votes

Print Playlist from Google Play Music

(Updated 2016-05-09, more robust than current top answer) If you just need to save a few playlists, you can just use my Javascript snippet below. This snippet can save every list as it is shown on ...
  • 440
24 votes

How do I export my YouTube playlists?

How about we make this more easy.. Go to: http://www.williamsportwebdeveloper.com/FavBackUp.aspx Put in the playlist-url you want to create in excel-format, that's all :) Here's a preview how it ...
22 votes
Accepted

Print Playlist from Google Play Music

Notice: While this answer is still completely accurate, now Google is phasing out Google Play Music in favor of YouTube Music. If you use their automatic converter, your playlists (including uploaded ...
  • 1,808
13 votes

How do I export my YouTube playlists?

In light of deprecation of v2, the current answer is no longer works. v3 is the new version. The documentation link - https://developers.google.com/youtube/v3/docs/playlistItems/list This limits ...
  • 355
13 votes

How do I export my YouTube playlists?

This is not the most elegant way to accomplish what you ask, but here's a manual method that I just used to do it. Because I'm using Powershell for part of this, I'm assuming you're on a Windows ...
  • 131
12 votes
Accepted

Is there a way to export my starred locations from Google Maps?

Go to https://takeout.google.com/ and select only Maps (your places) After downloading and extracting zip, use http://nearby.org.uk/convert-saved-places.php to convert to KML
  • 296
12 votes

Download 1 sheet from Google Sheets

I'm aware this was asked some months ago but this recently became a part of my weekly workflow and I decided there had to be a better answer than the roundabout answers that were given. My solution ...
8 votes
Accepted

How can I copy all events from one calendar to another?

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 ...
  • 1,301
7 votes

Is there a way to export my starred locations from Google Maps?

A lot of the answers here are old and refer to the discontinued Google Bookmarks, which did seem to have this data usefully. Using Google Takeout, like the accepted answer suggests, gives you your ...
  • 191
6 votes

How do I export my YouTube playlists?

Nowadays there are many solutions that do even more than what you requested: http://www.playlist-converter.net/ - Convert your playlist from multiple music services and file formats https://...
  • 195
5 votes

How to export a filtered set of rows from a Google Spreadsheet?

The best way to do this is to just select the cells you want to save as CSV, paste it into notepad, then find/replace tab with a comma.
  • 151
5 votes

How do I export my YouTube playlists?

Use Google Takeout. Deselect all Scroll all the way to the bottom for YouTube and YouTube Music and select it Click on All YouTube data included to get sub-selections and click Deselect all Select ...
  • 161
5 votes

How do I export my YouTube playlists?

You can do it with a new site we Developed https://www.tunemymusic.com/ You can choose export from Youtube a specific playlist, all your playlists and also all your liked videos. Then you can export ...
5 votes

How do I export my YouTube playlists?

I've created a service called www.recovermy.video to fix this problem. See my answer on another question.
  • 171
5 votes

Is there a way to export list of Pandora songs that I have upvoted or downvoted?

I created a small script to export your entire list of liked songs, see here: http://www.tedtrowbridge.com/exporting-liked-songs-from-pandora/ The solution works by using a little bit of javascript ...
  • 151
5 votes

Export Google Drive Including Shared Folders

I would try the following: Create a new folder in your Google Drive to move all your shared items into. Go to "Shared with Me" and add all the shared items from there to the new folder in your drive....
5 votes
Accepted

How do I download all Google Docs in a folder as PDF?

I found that the drive Google Drive client can download a folder structure that contains Google Docs exported as PDF (and some other formats as well). drive pull -export pdf /path/to/folder
5 votes

How do I download all Google Docs in a folder as PDF?

The easiest way to download an entire folder is with the Google Takeout tool. You can download just the folder you need, and you can chose which format you would like (in this case PDF). https://...
4 votes

How to export selected emails from Gmail

Select the emails you want to download, right click, and select "forward as attachment". This will make a new email with all selected e-mails as ".eml" file attachments. Send that yourself and ...
4 votes
Accepted

Google Spreadsheets CSV Encoding not UTF-8?

Actually, Google Sheets exports to CSV using UTF-8. In Excel, instead of using double-click to open a CSV file, use the Text Import Wizard as it allows to select the "File origin". On the "File ...
  • 43.1k
4 votes
Accepted

How to export Telegram's member list?

You can try Telethon which can extract all the members of a given group and saves it in an SQLite database. You need to be an admin for the channel of course. You can get it with a method like: from ...
  • 25.5k
4 votes
Accepted

Download 1 sheet from Google Sheets

One solution I found was to right click the sheet in the bottom bar copy to > new spreadsheet. This will create a new spreadsheet containing just this tab. Just make sure to delete this new ...
  • 6,625
4 votes

How can I export a single event as an ICS file from Google Calender?

I didn't find any option in Google Calendar to export a single event, but there is a workaround. Simply invite yourself with a non-Gmail account, by default the event will be attached to that ...
  • 41
3 votes

How to export a filtered set of rows from a Google Spreadsheet?

You can make a Pivot table for that, inserting the desired filter. Then just export it as CSV.
3 votes

Print Playlist from Google Play Music

I have some much shorter JavaScript you can paste into the console. Instead of re-running the code you can just scroll down and all albums that come into view are added. Then you can download the ...
3 votes

How can I export track.scrobble data from last.fm?

You can use Ben Foxall's Last.fm to CSV exporter, which will fetch the pages of your history and save it in CSV format. The code is available on Github if you want to incorporate into a JS project.
3 votes
Accepted

How do I export a YouTube playlist?

If the playlist is public you can get atom feed of it with an http request like. https://www.youtube.com/feeds/videos.xml?playlist_id=ID Where the ID is replaced with an actual ID like this. https:/...
  • 662
3 votes

How to get the real filelocations of all real svg-files on commons.wikimedia?

From File:A to https://commons.wikimedia.org/wiki/Special:Redirect/file/A https://commons.wikimedia.org/wiki/Special:Redirect/file/11-cube_t0_B5.svg redirects to https://upload.wikimedia.org/...
  • 687
3 votes

Export Trello board to CSV/XLS including custom fields and labels

As of January 2017, there isn't currently a way to export the custom fields data via the UI. Luckily, it is accessible via the API and a call to the pluginData resource /cards/[cardId]/pluginData. I'...

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