Google Sheets Formulas Every SEO Marketer Should Know

Google Sheet Formulas for Keyword Management

[{"selector":"#anim-9e5075f2-45dd-4801-ac30-980a81fcce95","keyframes":{"opacity":[0,1]},"delay":100,"duration":1700,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-e300f071-5d5d-47c5-bbaa-e15f564f568a","keyframes":{"opacity":[0,1]},"delay":200,"duration":1400,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-1f60287a-8069-4062-bd6f-65f2573f336f","keyframes":{"transform":["translate3d(0px, 142.51544%, 0)","translate3d(0px, 0px, 0)"]},"delay":200,"duration":1400,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] =VLOOKUP(A2, $E$3:$F$10, 2, FALSE) This formula looks up the value in cell A2 in the range E3:F10 and returns the corresponding value from the second column.

2. CONCATENATE

[{"selector":"#anim-145c27e3-d727-4b2c-a31f-81039180525e","keyframes":{"opacity":[0,1]},"delay":100,"duration":1700,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-158a802a-0618-464a-b88e-0ad972c6570c","keyframes":{"opacity":[0,1]},"delay":200,"duration":1400,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-3115b3b1-336c-40ea-8a8c-4c15c5535a00","keyframes":{"transform":["translate3d(0px, 216.02337%, 0)","translate3d(0px, 0px, 0)"]},"delay":200,"duration":1400,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] =CONCATENATE(A1, " - ", B1) This formula concatenates the values in cells A1 and B1 with a hyphen in between.

Want to Discuss your SEO Strategies for Your Business? Talk to Our Uvisible Experts NOW! Click here!

3. FLATTEN

[{"selector":"#anim-73faa571-7df8-4f6e-89ca-ac9392ca1f30","keyframes":{"opacity":[0,1]},"delay":100,"duration":1700,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-adf5bb91-75e3-4fef-ac8e-0a1fdf647897","keyframes":{"opacity":[0,1]},"delay":200,"duration":1400,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-41f39fcd-1984-45bb-b55f-8897ac1a8ef3","keyframes":{"transform":["translate3d(0px, 220.66911%, 0)","translate3d(0px, 0px, 0)"]},"delay":200,"duration":1400,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] =FLATTEN(A1:C10) Assuming A1:C10 contains data, this formula compresses all the ranges into a single colum

4. LOWER

[{"selector":"#anim-cc1cc361-cfa2-4e1c-8add-b785b900a169","keyframes":{"opacity":[0,1]},"delay":100,"duration":1700,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-fe0c2b92-c15b-4568-a9d8-0ed801cc60a4","keyframes":{"opacity":[0,1]},"delay":200,"duration":1400,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-e31f949c-afdd-41c9-ac85-a200cb0fbfc7","keyframes":{"transform":["translate3d(0px, 289.04547%, 0)","translate3d(0px, 0px, 0)"]},"delay":200,"duration":1400,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] =LOWER(A1) Converts the text in cell A1 to lowercase.

5. COUNTIF

[{"selector":"#anim-cd485f3f-63ef-46cc-beca-7ab5f4a6f845","keyframes":{"opacity":[0,1]},"delay":100,"duration":1700,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-ad074826-b96d-4d84-b0c9-b53fc06ed9ff","keyframes":{"opacity":[0,1]},"delay":200,"duration":1400,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-c73c5dac-2e86-46f6-92f6-1eb991f40bd7","keyframes":{"transform":["translate3d(0px, 216.02337%, 0)","translate3d(0px, 0px, 0)"]},"delay":200,"duration":1400,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] =COUNTIF(B2:B20, ">10") Counts the number of cells in the range B2:B20 that have values greater than 10.

6. SUMIF

[{"selector":"#anim-cca71201-9943-4c9a-a98a-c42a1ffabc6d","keyframes":{"opacity":[0,1]},"delay":100,"duration":1700,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-d42a3889-e4c0-468c-b941-f8cd953f6da6","keyframes":{"opacity":[0,1]},"delay":200,"duration":1400,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-24f6a994-22e8-4682-a072-432784b63a86","keyframes":{"transform":["translate3d(0px, 149.45226%, 0)","translate3d(0px, 0px, 0)"]},"delay":200,"duration":1400,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] =SUMIF(A1:A100, "Category A", B1:B100) Sums the values in the range B1:B100 where the corresponding value in A1:A100 is "Category A".

7. GOOGLETRANSLATE

[{"selector":"#anim-ab511a49-90d9-434b-aa83-f0debad994a4","keyframes":{"opacity":[0,1]},"delay":100,"duration":1700,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-821461eb-2d2c-4185-a261-2c7500e4baa3","keyframes":{"opacity":[0,1]},"delay":200,"duration":1400,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-a17aeb76-3c0e-422d-953b-0afb9ae8e025","keyframes":{"transform":["translate3d(0px, 179.84938%, 0)","translate3d(0px, 0px, 0)"]},"delay":200,"duration":1400,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] =GOOGLETRANSLATE(A1, "auto", "es") Translates the text in cell A1 from the detected language to Spanish.

Google Sheets formulas for URL/Content management

[{"selector":"#anim-1a3b1121-33b5-4e40-8012-41648cc495a7","keyframes":{"opacity":[0,1]},"delay":100,"duration":1700,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-ca24e375-61dc-4de7-a524-04a9476e8407","keyframes":{"opacity":[0,1]},"delay":200,"duration":1400,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-a64e2f3b-07d8-40e0-832b-c6611f16e7c8","keyframes":{"transform":["translate3d(0px, 220.66911%, 0)","translate3d(0px, 0px, 0)"]},"delay":200,"duration":1400,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] =SPLIT(A1, ",") Splits the text in cell A1 into separate columns based on commas.

9. LEN

[{"selector":"#anim-78321d3e-9e06-4115-9aef-131f2deb4936","keyframes":{"opacity":[0,1]},"delay":100,"duration":1700,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-8029807c-332a-4504-bdc6-58f93881f47c","keyframes":{"opacity":[0,1]},"delay":200,"duration":1400,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-a6b96327-fb45-475e-96dc-1270407f870d","keyframes":{"transform":["translate3d(0px, 284.60324%, 0)","translate3d(0px, 0px, 0)"]},"delay":200,"duration":1400,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] =LEN(A1) Counts the number of characters in cell A1.

10. REGEXREPLACE

[{"selector":"#anim-c094cd2b-582f-40cb-ab83-1a4d6d466598","keyframes":{"opacity":[0,1]},"delay":100,"duration":1700,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-3af8e4db-84fe-4008-96f7-114ea6ae9d79","keyframes":{"opacity":[0,1]},"delay":200,"duration":1400,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-4bf9eea7-4076-43f6-90a4-f71d6e7b1b07","keyframes":{"transform":["translate3d(0px, 167.71130%, 0)","translate3d(0px, 0px, 0)"]},"delay":200,"duration":1400,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] =REGEXREPLACE(A1, "\d{2}/\d{2}/\d{4}", "MM/DD/YYYY") Replaces date formats in cell A1 with "MM/DD/YYYY".