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 ...
- 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 ...
- 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
- 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 ...
- 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 ...
- 131
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 ...
- 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 ...
- 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://...
- 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 ...
- 161
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 ...
- 69
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
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
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....
- 916
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
- 321
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://...
- 71
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-...
- 201
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&...
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 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.
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 ...
- 243
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.
- 31
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 ...
- 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 ...
- 146
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'...
- 56
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 ...
- 3,884
Only top scored, non community-wiki answers of a minimum length are eligible