00:00This is a URL. Most URL includes parameter appended at the end of the base URL, also known as query
00:07string. In this Excel tips and tricks, I will show you how you can extract and tabulate the data from
00:13the query string of a URL. Actually, the solution is quite simple. To start off with, I'm going to
00:20go ahead and copy the query string from the URL. Let's highlight it. Control C to copy, and then
00:28I'm going to paste it on maybe cell J2 like this, and press Control V, and then hit Enter. You
00:36can see
00:37that the query string starts to go way out of hand. Maybe highlight a couple of rows or other columns
00:42like this, and press Control 1, and I'm going to go ahead and merge and wrap the text, and then
00:48you'll
00:48come up nicely like that. Now, the idea is how you can tabulate this data into an Excel table. This
00:55is
00:55how you do it. First, you're going to say equal textSplit. That's the function name, and the
01:02first argument on textSplit will be the text itself, which is the query string itself on
01:08cell J2, comma. Next argument, the second argument is column delimiter. Our column delimiter would
01:17be equal because we want to go apple, and next column will be 3, 5, 4, 7. So it's going
01:23to
01:23say equal. And then the third argument allows you to specify the row delimiter, which is going
01:29to be the ampersand sign here, the end sign here like this. So which means it goes to the
01:33next row. Double quote, n, double quote, and then close parenthesis, and hit Enter. And what you'll
01:41see is that you'll actually tabulate all this text value, which is equal and n sign, into
01:49an Excel table itself. And all you have to do now is to just give some title header here,
01:57and then maybe you want to beautify the title header like this, and then you're done. You
02:03have a nice looking Excel table, just out of a query string.
Comments