Hot answers tagged

53 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 ...
user29020's user avatar
  • 872
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 ...
Zach Saucier's user avatar
  • 1,813
15 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
ariel's user avatar
  • 326
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 ...
Sairam's user avatar
  • 355
13 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 ...
Dave Feldt's user avatar
10 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 ...
Anson W Han's user avatar
  • 1,349
9 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 ...
polm23's user avatar
  • 211
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://...
red-o-alf's user avatar
  • 195
5 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 ...
Colin Fukai's user avatar
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 ...
tbc0's user avatar
  • 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 ...
tunemymusic's user avatar
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.
ninsky's user avatar
  • 171
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.
botmin's user avatar
  • 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....
Christopher Su's user avatar
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
Andrew Sun's user avatar
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://...
Mark Hall's user avatar
5 votes

How do I add all my Amazon Kindle purchases to Goodreads?

I found the button class for the 'Want to Read' button and looped through and clicked them all by running this Javascript in the console. var buttonArray = document.getElementsByClassName('w-button-...
Steve Moser's user avatar
4 votes

How to download all directory contacts?

Apologies for the late answer, but I have recently been wanting to accomplish this too. I used the latest version of Google Contacts at the time of writing, and the density layout of "Compact&...
idontknow's user avatar
  • 244
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 ...
Rubén's user avatar
  • 44.6k
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 ...
user0's user avatar
  • 26.2k
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 ...
sam's user avatar
  • 6,833
3 votes

How to download/export own passwords stored at Google Passwords?

Google's Password Manager now has an Export feature in desktop Chrome, Android Chrome, and iPhone and iPad Chrome. It saves a CSV file which you can open with any spreadsheet program or (less ...
Jerry101's user avatar
  • 2,470
3 votes

How can I export the cards from the Trello stack as a list?

If you are comfortable with using the browser console, the following JavaScript snippet from this blog post will copy the the board, list and card titles sorted as requested to the clipboard in ...
mrts's user avatar
  • 226
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.
Guilherme Franco's user avatar
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 ...
Charles Clayton's user avatar
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.
Tim Hordern's user avatar
3 votes

How can I export all emails from my Gmail inbox to a .csv file?

Google Takeout will let you download your Gmail messages in MBOX format. From there, you'd need to convert it to CSV. I haven't used any of these, but a quick search found several possible paths you ...
ale's user avatar
  • 52.3k
3 votes
Accepted

How can I export my LinkedIn messages?

Per LinkedIn's documentation: LinkedIn > Download your account data Click the Me icon at the top of your LinkedIn homepage. Select Settings & Privacy from the dropdown. Click the Data ...
Keith Bennett's user avatar
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'...
Bentley Cook's user avatar
3 votes
Accepted

Exporting Telegram chat histories with emojis and images

From 23-24/06/2018 Telegram added this option, as part of the GDPR changes. Now you can request to download all you data: Unfortunately it's not available yet (and not sure when) on the Telegram ...
arieljannai's user avatar
  • 3,884

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