Backup Del.icio.us with Excel

February 13th, 2005 | Categories: XML/Services | Tags:

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

Notes:
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:
2007 Calender Templates
Excel Mortgage Calculator


Get LIVE Help
Custom Excel solutions & live Excel help!
► Go to www.ExcelAutomationHelp.com
► Email Now@ExcelAutomationHelp.com
  1. March 1st, 2005 at 12:03
    Reply | Quote | #1

    I found a large collection of all del.icio.us tools at
    Absolutely Del.icio.us – Complete Tool Collection

  2. June 15th, 2005 at 17:20
    Reply | Quote | #2

    Hi,

    I’m looking for a way to grab all the urls into excel from delicious that have been tagged by all users. Can your tool do this? Do you know of one that can?

    Thanks

  3. Mark
    June 15th, 2005 at 18:49
    Reply | Quote | #3

    Beth,

    I’ve never heard of a tool with the functionality you’re requesting, and guessing this would definitely be considered abusive to their system.

    For what data you can get your hands non: Here’s a list of the API functions and acceptable use.

    Not sure the reason you need it, but you could always ask the delicious folks directly.

  4. June 17th, 2005 at 19:26
    Reply | Quote | #4

    Thanks! A group of professionals who work with nonprofits on technology issues – started a folksonomy experiment — using the nptech tag. Basically an opportunity to collaborative/share urls. We wanted to get a sense of how many uers/urls have been tagged so far. It is for analysis purposes …

  5. j0e
    June 24th, 2005 at 22:51
    Reply | Quote | #5

    Hi
    Great Concept but I cannot get it to work. I have my bookmarks in firefox but does that matter?

    Thanks
    joe

  6. Mark
    June 25th, 2005 at 05:24
    Reply | Quote | #6

    Joe, thanks for testing.

    Are you using Excel 2003?

    Your bookmarks need to be stored in delicious, at a location like http://del.icio.us/username?

    The spreadsheet doesn’t retrieve bookmarks from firefox.

  7. fer
    August 8th, 2005 at 22:51
    Reply | Quote | #7

    Excellent! But how can I restore my backup if delicious loses my bookmarks for whatever reason?

  8. December 20th, 2005 at 14:41
    Reply | Quote | #8

    Have you tested or updated this recently? I’ve tried it and can’t get it to run on my machine. Is it WinXP only?

    Seems like a good idea but I can’t verify that it works anymore.

    Thanks!

  9. Mark
    December 20th, 2005 at 15:14
    Reply | Quote | #9

    Just tested and worked like a charm.

    Needs Excel 2003.

  10. December 20th, 2005 at 17:13

    Ah, that’s my bad. User error — I’m still using Excel X.

    I’ll find someone with 2003 and test it for my own assurance, and then give a fuller endorsement. Thanks!

  11. Mark
    December 20th, 2005 at 19:23

    No problem, hopefully you get it working. It’s pretty fast with

  12. johnny
    August 25th, 2008 at 11:47

    Hi
    Great Tool! Unfortunately the tool works at home on Excel 2007, but doesnt at my office on Excel 2003. How can that be? Macros are enabled on both machines.

  13. September 2nd, 2008 at 21:06

    hey ))
    its very reasonable article.
    Good post.
    realy gj

    thank you ;)

  14. Tom
    January 19th, 2009 at 08:10

    This is great. Thanks for creating it.

  15. Rob Greavs
    August 28th, 2009 at 14:12

    Help

    This is a brilliant tool which I use to move bookmarks into Web Ceo for link building. Unfortunately it’s stopped working and I don’t understand why.

    Anyone found the same?

    Thanks

    Rob

  16. September 30th, 2009 at 12:47
  17. Jason
    May 14th, 2010 at 02:50

    Just downloaded and used, awesome, thank you!

  18. October 8th, 2010 at 06:57

    Hey great blog, im glad you shared this topic and im even more glad with the comments! Keep it up everyone!

  19. April 3rd, 2013 at 10:11

    Great but can I use this with excel 2013.

  20. 2 trackbacks