InstaPaper — Download Your Content As Hyperlinked Links Into MS Excel

Image for post
Image for post
https://www.instapaper.com/iphone

InstaPaper is great cloud service for accumulating your content — links, videos, articles, etc. — to “read later” on any of your devices.

However, if you use it for awhile, you accumulate a LOT of links that you may want to download and keep (I’ve seen this a few times…).

Here’s how you do it.

Image for post
Image for post
InstaPaper home page
Image for post
Image for post
Click “Settings”
  • Scroll down and select “Download HTML File”. This selection creates a file and downloads a hyperlinked list of contents.
Image for post
Image for post
Scroll down page and select “Download HTML file”
  • A file named “Instapaper-export.html” will download. Open this file in your web browser. The “Unread” category is what you want to paste into Excel (this assumes you have not moved content into folders, etc.)
Image for post
Image for post
Instapaper-export.html opened in Web Browser
  • Copy and paste the data into Excel (up to the Archive point)
Image for post
Image for post
Instapaper links selected for copying
  • Paste the copied data into Excel — it will appear as follows, hyperlinked to the website where it is located.
Image for post
Image for post
Excel file with Instapaper links copied in
  • At this point, clean up the data (Header, assign categories if desired, etc.) and you have the start of a permanent searchable / linked reference.
  • Lastly, return to the InstaPaper website and “Archive” all content (unless you want to keep as Unread in Instapaper — note, this will cause problems the next time you want to download any updated content and add it to your Excel file).
Image for post
Image for post
Instapaper Archive All menu option
Image for post
Image for post
Instapaper with everything Archived

There you go — a simple solution to keeping your Instapaper content in a linked resource. This was demonstrated with Microsoft Excel, but would work the same in way in Google Sheets. If you use Google Sheets, you have the added benefit of the content being available in the Google cloud!

Good luck!

Image for post
Image for post

Don Tomoff is a “recovering CPA”, who is passionate about helping professionals and organizations keep up and adapt to the changing business world that we operate in.

One lesson learned over the years is that all of us, regardless of organization type or size, struggle with similar issues — primarily information management and presentation, and effective use of our time. Let’s change that…one person at a time!

LinkedIn, Flipboard, Twitter, Snapchat

Or, just Google me…I’m everywhere

Send Don an email

It’s time for DIFFERENT— On a mission to challenge the status quo to a more productive and effective end… #digital #Excel #data #analytics

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store