Saijo George

Curated by Saijo George

Read more

wednesday8 Jan 2020

Remove HTML from Excel or Google Sheets

Excel or Google Sheets is one of the most quintessential tool in SEO, you often come it for quick data analysis. You often scrape content from websites and it may contain some HTML elements in them, with this simple tip you can easily find and replace all of those pesky HTML elements from you excel or Google sheet content.

How to remove Remove HTML from Excel

  1. Select the cells that contain the HTML
  2. From the Home tab, click the Find and Select command, then select Replace from the drop-down menu. ( You can also use the Windows Shortcut key Ctrl + h )
  3. In the Find what field enter<*> 
  4. Leave the Replace with field blank
  5. Click on the Replace All button. Now you are left with the text content.

How to remove Remove HTML from Google Sheet

Remove HTML from Excel or Google Sheets 1 - Tips and Tricks News

With Google sheet, it’s not easy as it’s in Excel, but you can do the same using Regular Expressions.

  1. Select the cells that contain the HTML
  2. From the Edit tab, click the Find and Replace option. ( You can also use the Windows Shortcut key Ctrl + h )
  3. In the Find field enter<(?:"[^"]*"['"]*|'[^']*'['"]*|[^'">])+> 
  4. Leave the Replace with field blank and select Search using regular expressions
  5. Click on the Replace All button. Now you are left with the text content.
Tips and Tricks


I love tl;dr Marketing because I can get all the latest SEO news and trends in one spot without having to read lengthy articles. I really look forward to the daily emails to see what's new in our industry!

Google Tests New Design For Sitelinks With Descriptions On Mobile 1 - SEO News

Ryan Mews SEO Manager Merkle