Excel Online & Google Sheets XML/HTML-tag cleaner

Overview

This script removes unwanted XML/HTML tags from Google Sheets, making content more readable.

Features

• Removes <p>, <ul>, <li>, <strong> and other common tags.
• Replaces bullet points for <li> tags.
• Converts   and & into readable spaces and symbols (&).
• Prevents excessive empty lines and ensures clean formatting.

How to Use

1. Open your Google Sheet and ensure that the project is saved "as a Google Sheet", and not as .xls or .xlsx
2. Click Extensions → Apps Script ("Extensions" won't appear if saved as .xlsx or .xls)
3. Copy and paste the cleanXMLTags.gs script into the editor
4. Click the Save and then the Run button (you may be prompted to authorize with your Google account)

For Excel Online:

1. Go to: Excel Online → Ribbon bar → Automate tab → Script Editor → New Script → Paste code
2. Click Save & Run