Google Sheets - Regex Find and Replace

date-created:: 2023-08-15

#regex
Google Sheets allows regex in find and replace. This is extremely helpful in turning embedded newlines (\n) into HTML
for CSV or TSV files for Anki.

It's important to do this find and replace to recode newlines as HTML before downloading the file as CSV and TSV. Without this step, all those newlines will turn into simple spaces, losing their newlineness.

Before

Applying regex

After