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 the Screaming Frog SEO Spider. | |
2 | Download the Screaming Frog SEO Spider | https://www.screamingfrog.co.uk/seo-spider/ |
3 | ||
4 | Query | SERP URL |
5 | keyword one | https://www.google.co.uk/search?q=keyword+one |
6 | keyword two | https://www.google.co.uk/search?q=keyword+two |
7 | keyword three | https://www.google.co.uk/search?q=keyword+three |
8 | keyword four | https://www.google.co.uk/search?q=keyword+four |
9 | keyword five | https://www.google.co.uk/search?q=keyword+five |
10 | keyword six | https://www.google.co.uk/search?q=keyword+six |
11 | keyword six | https://www.google.co.uk/search?q=keyword+six |
12 | keyword seven | https://www.google.co.uk/search?q=keyword+seven |
13 | keyword eight | https://www.google.co.uk/search?q=keyword+eight |
14 | keyword nine | https://www.google.co.uk/search?q=keyword+nine |
15 | keyword ten | https://www.google.co.uk/search?q=keyword+ten |
16 | keyword eleven | https://www.google.co.uk/search?q=keyword+eleven |
17 | keyword twelve | https://www.google.co.uk/search?q=keyword+twelve |
18 | keyword thirteen | https://www.google.co.uk/search?q=keyword+thirteen |
19 | keyword fourteen | https://www.google.co.uk/search?q=keyword+fourteen |
20 | keyword fifteen | https://www.google.co.uk/search?q=keyword+fifteen |
21 | keyword sixteen | https://www.google.co.uk/search?q=keyword+sixteen |
22 | keyword seventeen | https://www.google.co.uk/search?q=keyword+seventeen |
23 | keyword eighteen | https://www.google.co.uk/search?q=keyword+eighteen |
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 |