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


tldrMarketing has really impressed me with the useful information being shared and also the use of emerging technology - web stories. It was already becoming a great source of information for me, and sharing news in new engaging ways has made it my first web stop for SEO news.

Google to shutter CallJoy, virtual agent for SMBs, on July 22 1 - General News

Jess Joyce Search Consultant

Prosperity Media SEO Consultant

Full Time Sydney

Company : Prosperity Media

Prosperity Media is a well known SEO Agency based in Sydney. The thing about our company is we are not trying to do everything. We specialise in SEO and mid to large…