I would probably use Make’s text parsing tools for this, which offers an “HTML to text” module.

But you can also use Make’s HTTP module to communicate with any API on the web, so you can use any “HTML to text” API that you can find on the web.

For example, here’s an API that I just found online that converts HTML to plain text. So you could have Make communicate with that API.

If you’ve never used Make before, I’ve assembled a bunch of Make training resources in this thread. For example, here is one of the ways that you could instantly trigger a Make automation from Airtable. 

Hope this helps!

If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

Hi ​@Catherine_Murp1,

If you want to take the html from one of the fields after you import it to Airtable and want it to remove all the html tags and keep the text you could do a few things:

1. This is probably a great use case of Airtable AI. You could use an automation that will take the contents of that html field and with a prompt you can tell the AI to return just the text of the html in a nice readable format. Then have it just update that same field with the new content or you could choose to do this on a different field.
2. Another option is to write a small script that would replace all the html tags to clean up the html into text. You could use a similar automation as the above one but instead of an Airtable AI block, you would use a script block.
3. You can create a regex_replace formula that would be able to get rid all of the tags for you in a formula. 

If the AI option is not something you would want to try, and would be interested in either of the 2 other options, I can give you a sample script or formula you can use. Just let me know!