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

As an agency director, staying on the pulse of changes in the digital landscape is fundamental to our success. Unlike traditional industries, we can't rely on the methods that worked for us in the past as the pace of change and transformation in digital dictates constant investment in education. Saijo and the tl;dr feed/newsletter is an invaluable source to anyone in digital as it constantly provides value and keeps busy digital talent reliably up-to-date. Make reading it a weekly habit and you'll understand why tl;dr marketing is your secret weapon in digital and why you should consider Saijo a good friend to have in your network.

Senior SEO Specialist / Audience Strategist

Full Time 100% Remote

Company : 10up

10up is a fully distributed, global creative services agency; partnering with some of the biggest brands in the world.  This role at 10up sits on our Audience and Revenue team.…