logo ASAP Utilities

You can do this too

Download "The one essential add-in for all Excel users."
Sit down and relax, while ASAP Utilities does the rest!

“Working in Excel will be fun again with all these extra supersmart tools”

ASAP Utilities, description of our Excel tools

Language: English Nederlands (Dutch) Deutsch (German) Espa˝ol (Spanish) Franšais (French)

Web » Decode all URL and HTML encoded text

This utility decodes all URL-encoded text in your selected cells.

This can be useful when you use Excel for example to analyze reports with website statistics or keyword performances.
The utility will replace the "+" character with a space and it decodes any %## encoded character in the cells.
It will also decode named HTML entities such as   and € and it will decode a string of text such as %c3%84 and %c3%a7 and unicode characters such as © and “.

This utility will for example decode the text http%3A%2F%2Fwww%2Emicrosoft%2Ecom to "http://www.microsoft.com, which is more readable.

URL encoding is used when text is place in a query string in the URL to avoid that it gets mixed up with the address of the website and it is usually placed behind a question mark (?) in the address. This technique is often used when the internet browser sends data via a form on the website to the web server.
The cells in your selection with formulas are skipped.

Screenshots

Web » Decode all URL and HTML encoded text

Starting this utility

In the Excel menu choose: ASAP Utilities » Web » Decode all URL and HTML encoded text

« Return to the list of “Web” tools.
« Previous
Remove all HTML tags in the selected cells...
 
 Next »
Extract hyperlinks...
Excel 2010 with ASAP Utilities in the menu
Download ASAP Utitilities
Additional keywords for this tool:
urldecode, excel php alternative, decode string, decode website address, percent-encoding, uri, Internationalized Resource Identifier, Uniform Resource Locator (URL), decode google analytics search keywords, urlencoded, hyperlink, convert html encoded characters

Follow ASAP Utilities on Facebook



Home Sitemap Search List of all utilities Printer friendly page ^ Back to Top
ę 1999-2014 - - - - The Netherlands EnglishDutch - NederlandsGerman - DeutschSpanish - Espa˝olFranšais (French)

Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
Follow us on TwitterFollow us on Facebook