Skip to main content
Share Your Experience: Take the 2024 Developer Survey
58 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
  • 922
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,833
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
  • 324
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,379
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

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
6 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
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
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 - Volunteer Moderator -'s user avatar
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.7k
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,949
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

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

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 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

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,924
3 votes
Accepted

Export data from 1 Foursquare account and import it to another one

Foursquare doesn't support importing exported data. Once it's exported you can import it to Google Maps.
user0's user avatar
  • 26.7k
3 votes
Accepted

Liberate all data from Google+

Google Takeout can be used to download data from most Google services, including Google+. From the help article: You can download your Google+ content using Google Takeout. If you want to download ...
John C's user avatar
  • 9,360
3 votes

How to export and import my block list in the 2019 "New Twitter" UI?

This facility is "not currently available", unfortunately. Maybe keep an eye on this page: https://help.twitter.com/en/using-twitter/advanced-twitter-block-options#
Bob D's user avatar
  • 31
3 votes
Accepted

Downloading entire archive of past messages of a Yahoo Group

There's an option in Yahoo Groups to download Groups Data. I submitted a request but I haven't heard back yet so I can't verify if it's the solution to our problem: https://groups.yahoo.com/neo/...
Reed Dunkle's user avatar
3 votes
Accepted

Print Playlist from YouTube Music

I do not recommend playing music from the same tab that you're doing this process in as some of the time it seemed to cause problems for me. Instructions: Go to your Playlists page. Press F12 to open ...
Zach Saucier's user avatar
  • 1,833
3 votes
Accepted

How can I export a Microsoft Office 365 Word online document to PDF without comments?

One can click on View: then Print:
Franck Dernoncourt's user avatar

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