7 Essential Tips & Tricks You Might Not Know


It might not seem like one of many fancy, paid website positioning instruments you’re used to logging into, however Excel stays probably the most versatile and highly effective instruments in an website positioning skilled’s toolbox.

You should use Excel to trace and analyze key metrics resembling rankings, web site site visitors, and backlinks.

Use it to create and replace meta tags, monitor and analyze rivals’ website positioning methods and efficiency, construct automated experiences, and handle most of the information duties you’ll encounter on daily basis.

Mix your Excel data with Python, Tableau, R, and different instruments, and there’s nothing you possibly can’t do.

In case you’ve by no means labored with information earlier than, you’ll discover Excel has a little bit of a studying curve, however you should use it proper from the beginning. And it’s versatile sufficient to scale and develop as your website grows.

Why Excel For website positioning Duties?

Whereas many paid instruments might help you do the identical duties, Excel is a incredible possibility to boost, mix, or exchange these instruments.

  • It’s inexpensive and comes with a variety of instruments you already use.
  • There are a ton of sources and programs that can assist you be taught.
  • Simply handles giant quantities of knowledge.
  • Sorting and de-duplicating – a function usually lacking once you want it.
  • Create and handle databases with easy formulation.
  • Knowledge ports simply to different instruments and is out there for different duties.
  • Pivot tables and sensible charts.

1. Mix A number of Knowledge Sources

You’ll usually end up having to merge information from a number of sources.

That is intuitive and fast in Tableau, Python, or R, however you are able to do the identical in Excel utilizing Energy Question.

There are just a few steps to this course of, however it’s not as sophisticated as you would possibly suppose – even in case you are new to working with information or Excel.

Energy Question has automated and simplified duties that required a whole lot of time and ability.

And it’s in all probability THE finest Excel function for enterprise and website positioning professionals.

Appear a bit daunting? Don’t fear. There are a number of programs and tutorials on YouTube to get you began.

What It’s Good For:

  • Constructing experiences.
  • Analytics and gross sales information.
  • Combining information sources to determine alternatives and acquire insights.

2. Knowledge Cleansing

A lot of your time is misplaced merely making ready information for evaluation. It doesn’t need to be that approach.

Giant lists are sometimes bigger than they must be. Discovering and manually eradicating all of the duplicates, nevertheless, is usually a severe ache.

Excel can do that immediately for you. Merely go to the “Knowledge” tab and click on “Take away Duplicates.”

Remove duplicates in Excel.Screenshot from Excel, January 2023.

Undesirable areas and clean strains are inclined to trigger havoc with many duties, formulation, and statistics.

Excel will take away them for you just by going to Edit > Discover > Go To. Choose “Particular,” “Blanks,” and inform Excel the way it ought to deal with them.

“Convert textual content to columns” is usually a lifesaver, particularly when you’ve acquired information the place the addresses or names are all in the identical cell or you want to extract domains from e mail addresses.

Go to Knowledge > Textual content to Columns. Then, point out what to make use of for Delimiters (comma or area) and preview the outcomes. While you’re prepared, click on “Subsequent,” select a vacation spot, and click on “End.”

When To Use It:

  • Knowledge evaluation.
  • Knowledge processing.
  • Processing and cleansing lead databases.
  • Working with any information.

 3. Energy Excel With Add-On Instruments

A number of the extra complicated duties, resembling crawling, require a little bit of coding data.

In case you don’t have that in your skillset, nevertheless, there are instruments you possibly can obtain, combine with different instruments, and add on.

Power Excel With Add-On ToolsScreenshot from SEOTools, January 2023.

SEOTools affords off and on-page website positioning instruments, integrations, connectors, spiders, and a number of other different instruments that make it straightforward to customise your Excel and create customized initiatives.

SEOGadget brings the facility of Moz, Grepwords, and Majestic to Excel.

Evaluation ToolPak is for severe information evaluation. This add-on improves and automates in-depth statistics, excellent for forecasting, trending, regression evaluation, and extra complicated information evaluation duties you would possibly in any other case carry out in R or Python.

When To Use It:

  • Reporting.
  • Common information evaluation.
  • Shows.
  • Integrating and coordinating with different groups.

4. Infographics And Charts

Knowledge is ineffective when you can’t perceive it.

In reality, information visualization and storytelling are doubtless among the most essential expertise you possibly can have. That is the place instruments like Energy Question and PivotTables are available in.

Constructed proper into Excel, pivot tables are the opposite helpful instruments you’ve got for this goal.

Nonetheless, as an alternative of simply making a straight pivot desk and a associated chart, save your self some steps by making a grasp “template” first that you may then replicate as wanted and alter to fit your wants.

Excel pivot tables for reportingScreenshot from Excel, January 2023.

In lots of cases, nevertheless, you’ll need to work with dates or segments of the info. For that, you’ll need to enter splicers and timelines.

  • To splice information into segments: Choose the pivot desk and go to PivotTable Instruments > Analyze > Filter > Insert Slicer. Then, merely enter the way you want to phase the content material (e.g., by product or subject).
  • To make the most of timelines: Click on the pivot desk’s instruments possibility, go to Analyze > Filter > Insert Timeline. As soon as there, you possibly can select what you’d like to make use of, model it, add captions, and extra.

In case you’ve by no means used Excel’s PivotTables earlier than, a brief tutorial could have you in your approach to analyzing information very quickly.

Nonetheless need a bit extra? Make your experiences, social media, and updates even higher by upping your information visualization sport with add-ons like Individuals Graph.

When To Use It:

  • Reporting.
  • Day by day updates.
  • Floor information evaluation.
  • Group collaboration and integration.

5. Automate Widespread Duties With Macros

website positioning, notably company website positioning, is filled with repetitive duties like weekly reporting that eat a lot of your time. Excel’s macros are the reply. And so they’re very easy to make use of.

Beneath the “View” tab, click on “Macros” and “Report Macro.”

Automate Common Tasks With MacrosScreenshot from Excel, January 2023.

Fill out the small print.

The macro is now recording. So, merely stroll by means of the steps that you just’d wish to automate. And once you’re performed, return to the ribbon and cease the recording.

While you’re able to run the automation, go to the macro button within the ribbon, click on “View Macros,” and choose the specified macro from the listing.

When you have some macros that you just use extra usually than others, you possibly can add them to the Fast Entry Toolbar.

When To Use It:

  • Sorting.
  • Calculations.
  • Reformatting information.
  • Organising new website paperwork or new pages for experiences.

6. Simply Import Feeds And Knowledge Into Excel

In case you use Google Alerts or publish often, robotically importing feeds into Excel is usually a large time saver.

To start out, merely seize the RSS feed handle. (Or, create an alert for Google Alerts and have them delivered as an RSS feed.)

Importing rss feeds into google sheets for excelScreenshot from Google Sheets, January 2023.

Then, go to Google Sheets and use the IMPORTFEED perform to convey the updates straight right into a spreadsheet.

Alternatively, you possibly can add the knowledge to separate columns.

Importing rss feeds into excel through google sheetsScreenshot from Google Sheets, January 2023.

From right here, you possibly can often obtain and import the info into Excel, mix it with different associated information, or combine it into your customized dashboards.

In case you want one thing a bit extra computerized, use Google Apps Script or one of many add-ons accessible to automate the method.

Need a bit extra information behind your experiences? You may scrape and import Google Search Outcomes into Excel, too.

7. Backlink Evaluation

To investigate backlinks with Excel, acquire backlink information with instruments resembling Ahrefs, Majestic, or Google Search Console.

Then, import it into Excel and use it to investigate your backlinks in various methods:

  • Who hyperlinks to you: Use Excel’s sorting and filtering instruments to filter the info and use the IF perform: IF(logic, true_value,[false_value]) to type and determine domains linking to you.
  • What do folks hyperlink to: Kind and filter to see the anchor textual content used most frequently to your backlinks (utilizing frequency/depend).
  • When did folks hyperlink to you: Arrange the info by date to see how outdated your hyperlinks are and when most of your backlinks have been acquired.

Discover developments or patterns in your backlink profiles with pivot tables, teams, charts, and graphs by combining your backlink and gross sales or conversion information.

Spotlight particular information based mostly on sure situations with conditional formatting. This makes it straightforward to identify backlinks from high-authority web sites or backlinks with particular anchor textual content.


Many individuals overlook Excel both as a result of they suppose it’s too primary to be of a lot use. Or it appears too intimidating or formidable to be taught.

However these of us who use it perceive simply how highly effective it may be and the limitless potentialities it offers.

Hopefully, the following tips will make it easier to craft higher methods, discover new alternatives, and inform your story with higher experiences and dashboards.

Featured Picture: Paulo Bobita/Search Engine Journal


Scroll to Top