Andy Beal
posted this on July 12, 2011 02:10 pm
When you download your results to CSV, we're unable to reconstitute the complex dynamic URLs used by Facebook. In other words, clicking on a Facebook permalink inside of Excel will result in a broken page.
To fix this, you will need to do a "Find and Replace" for the following:
Replace: %3D with =
Replace: %26 with &
We recommended following that order and matching the case, just to be safe.
It takes about 30 seconds and you can apply it to all links in your spreadsheet. All Facebook links will then open from inside Excel, Numbers, etc.