I Saw It On The Interwebs

The Ford ‘Murica.

The Ford ‘Murica.

That Ruth. Deft Hands.

That Ruth. Deft Hands.

Painting by Amy Judd

Painting by Amy Judd

How to get all the URLs for your starred items on Google Reader out of that darn .json file.

I saw a ton of Python based How To’s online on how to do this. They drove me crazy. I worked out a system to get it done in about five minutes, using Excel.

Note: This is really for users with more than 1000 starred items. If you have less, check out Feedly as a replacement. Check it out either way, really. 

  1. Go to Google Takeout, Click Choose Services, then Reader, then Create Archive (when the file reaches 100%).
  2. Wait for the Takeout file to finish building, then click Download.
  3. Unzip the downloaded file, and change starred.json to starred.txt.
  4. Open an Excel Workbook in Microsoft Excel.
  5. In the menu: File > Open > starred.txt (wherever you left it)
  6. The Text Import Wizard should pop up. Leave on Delimited and click Next.
  7. Under Delimiters, Add a quote (“) to Other, click Next, then Finish.
  8. Highlight all of Column D (click the “D” at the top of the column).
  9. Find Sort (the A-Z thingy) in the toolbar. In my version of Excel, it’s under the Data tab, and click it. If it asks for options, pick Sort Ascending.
  10. When the Sort Warning pops up, select Continue With The Current Selection and click Sort.
  11. Scroll wayyyy down column D until you find the first entry that starts with http.
  12. Select the first http entry, scroll down to the last http entry, hold Shift and click it, to select all the URLs.
  13. Right click the selection and Copy.
  14. Paste into a text file, Word, Evernote, whatever.
  15. You’re Done!

Note: Every URL has a companion generic URL in this list. For example: http://lifehacker.com/5837068/8-essential-bacon-hacks, comes with a useless companion (http://lifehacker.com). Fortunately, these are all grouped together, thanks to the Sort, so you can just manually delete those later.

Exsmellsior!

Exsmellsior!

"She Lived Happily on this Earth for Seven Years," by Ai Weiwei.
Made from thousands of school backpacks, the sentence comes from a letter written by the parents of a seven year old who died in the 2008 Sichuan earthquake, which was notable for killing thousands (possibly tens of thousands) of children due mainly to cheaply built schools.
This is brilliant combination of art and activism, and it breaks my heart to look at.

"She Lived Happily on this Earth for Seven Years," by Ai Weiwei.

Made from thousands of school backpacks, the sentence comes from a letter written by the parents of a seven year old who died in the 2008 Sichuan earthquake, which was notable for killing thousands (possibly tens of thousands) of children due mainly to cheaply built schools.

This is brilliant combination of art and activism, and it breaks my heart to look at.

Kitty Pryde and Lockheed, by Alberto Varanda.

Kitty Pryde and Lockheed, by Alberto Varanda.

Shepard Fairey Space Station Mission Patch.

Shepard Fairey Space Station Mission Patch.

Funko’s Catwoman.

Funko’s Catwoman.

Reed and Sue Richards, by Phil Noto.

Reed and Sue Richards, by Phil Noto.

To Cloud City, by Tsuneo Sanda.

To Cloud City, by Tsuneo Sanda.