A | B | |
---|---|---|
1 | Please Make A Copy Of This Sheet Enter your query in column A, then use the formula in column B to create the URL you need to crawl with Screaming Frog. | |
2 | Query | SERP URL |
3 | keyword one | https://www.google.co.uk/search?q=keyword+one |
4 | keyword two | https://www.google.co.uk/search?q=keyword+two |
5 | keyword three | https://www.google.co.uk/search?q=keyword+three |
6 | keyword four | https://www.google.co.uk/search?q=keyword+four |
7 | keyword five | https://www.google.co.uk/search?q=keyword+five |
8 | keyword six | https://www.google.co.uk/search?q=keyword+six |
9 | keyword six | https://www.google.co.uk/search?q=keyword+six |
10 | keyword seven | https://www.google.co.uk/search?q=keyword+seven |
11 | keyword eight | https://www.google.co.uk/search?q=keyword+eight |
12 | keyword nine | https://www.google.co.uk/search?q=keyword+nine |
13 | keyword ten | https://www.google.co.uk/search?q=keyword+ten |
14 | keyword eleven | https://www.google.co.uk/search?q=keyword+eleven |
15 | keyword twelve | https://www.google.co.uk/search?q=keyword+twelve |
16 | keyword thirteen | https://www.google.co.uk/search?q=keyword+thirteen |
17 | keyword fourteen | https://www.google.co.uk/search?q=keyword+fourteen |
18 | keyword fifteen | https://www.google.co.uk/search?q=keyword+fifteen |
19 | keyword sixteen | https://www.google.co.uk/search?q=keyword+sixteen |
20 | keyword seventeen | https://www.google.co.uk/search?q=keyword+seventeen |
21 | keyword eighteen | https://www.google.co.uk/search?q=keyword+eighteen |
22 | ||
23 | ||
24 | ||
25 | ||
26 | ||
27 | ||
28 | ||
29 | ||
30 | ||
31 | ||
32 | ||
33 | ||
34 | ||
35 | ||
36 | ||
37 | ||
38 | ||
39 | ||
40 | ||
41 | ||
42 | ||
43 | ||
44 | ||
45 | ||
46 | ||
47 | ||
48 | ||
49 | ||
50 | ||
51 | ||
52 | ||
53 | ||
54 | ||
55 | ||
56 | ||
57 | ||
58 | ||
59 | ||
60 | ||
61 | ||
62 | ||
63 | ||
64 | ||
65 | ||
66 | ||
67 | ||
68 | ||
69 | ||
70 | ||
71 | ||
72 | ||
73 | ||
74 | ||
75 | ||
76 | ||
77 | ||
78 | ||
79 | ||
80 | ||
81 | ||
82 | ||
83 | ||
84 | ||
85 | ||
86 | ||
87 | ||
88 | ||
89 | ||
90 | ||
91 | ||
92 | ||
93 | ||
94 | ||
95 | ||
96 | ||
97 | ||
98 | ||
99 | ||
100 |