More WinHTTP/XML fun…
If you have Excel 2003 and use the social bookmarking tool Del.icio.us, you can backup your bookmarks in Excel.
1. Download the Del.icio.us Excel Spreadsheet
2. Press the “Backup Del.icio.us” Button
3. Enter your Del.icio.us Username and Password then click GO!
That’s it. Your spreadsheet should now look like the picture.
A few additional benefits:
• Save your data multiple ways; as Excel (.xls), Comma Delimited Text File (.csv) or XML.
• I like having the URL’s as clickable links, so when I do a quick browse if I see something interesting, I click, and I’m taken to the bookmark
• I can do data analysis on my bookmarking behavior if desired, possibly bookmark frequency chart, tag chart, filtering, etc. This requires additional modification.
You need to click YES when opening the workbook and prompted to enable macros for things to work correctly. However, if you’re hesitant, the code is unprotected so hit NO, then open the VB editor(alt F11) and inspect the code first.
This workbook makes use of the del.icio.us API, specifically only one call: /api/posts/all.
Update: On May 16, 2006 there was announced a new URL for the del.ico.us API. The spreadsheet has been updated to reflect this. If you downloaded the spreadhsheet prior to May 16, 2006 and arrived here wondering why your old version doesn’t work anymore, simply download again and replace your old file.
You might also like these posts:
Take the Shortcut Boot Camp Challenge
Download our free Excel Shortcut Boot Camp and become an Excel shortcut Guru with our hands-on training