Remove HTML from Scraped Google Maps Reviews

questions
1

Is there a way to remove html from scraped google maps reviews? For example, when I scrape maps, I get html tags and unusual characters like this in the output: (*edit: when I entered this comment, the br tags are shown as line breaks in this forum, but they show up in the spreadsheet)


<br/>1 review<br/>5 days ago<br/>NEW<br/>We’ve had an incredible experience working with [company name].  They’ve gone above and beyond (etc...)

Ideally, I’d like this to show up as just text without HTML tags, using the correct characters. If it’s not possible now, can this be added as an option?

Thanks for your help and for making such a great product!

2

You can surround html with preformat command in discourse so it shows properly for me.

If you remove line I can remove BR but it should be replaced with something else, maybe a newline character?

As for the unusual character, its most likely a text decode problem.

How are you opening the resulting CSV file?

If you can send me the corrupted CSV file that would also help

3

Thanks! I figured out how to do this in excel after download so not a huge issue. I tried opening the csv in excel and google sheets and it was the same for both.

4

Ok, if you can send me the corrupted characters CSV file I can have a look as well.

A regex-find-replace would be a quick way to fix <br>