Edit Text Snippets on a Computer Premium
On this page
Edit many Text Snippets at once in Google Sheets on a computer, then import them back into Typing Hero.
Open the file in Google Sheets
- Export your Text Snippets and save the file to Google Drive.
- On your computer, create a blank spreadsheet in Google Sheets.
- Click File > Import, then choose the file from My Drive.
- Clear Convert text to numbers, dates, and formulas, so Sheets keeps your Keywords and Templates exactly as written.
- Import the data.
Edit the Text Snippets
Each row is one Template. Keep the header row and the column order.
| Column | What it holds |
|---|---|
| Keyword | The Keyword. |
| Text | The Template. |
| Replace after Typing Space | true turns on Expand after space. false turns it off. This applies only to a Keyword with one Template. |
| Position | The Template's place under its Keyword. If a Keyword's values are exactly 1, 2, 3, and so on, they set the Template order. Otherwise the row order does. |
| Multiple Templates Selection Strategy | How a Keyword with multiple Templates chooses one: MANUAL, FIRST, RANDOM, or SEQUENTIAL. Rows for a Keyword with one Template show NONE. |
| Folder | The Folder name. |
To create a Text Snippet, add a row with a new Keyword. To add a Template, add a row with an existing Keyword.
To reorder Templates by moving rows, clear the Position values for that Keyword.
For a Keyword with multiple rows, Typing Hero uses the Replace after Typing Space, Multiple Templates Selection Strategy, and Folder values from its first row.
Import the file back
- Click File > Download > Comma-separated values (.csv).
- Upload the downloaded file to Google Drive.
- On your phone, import the file and select it in Google Drive.
- When asked how to handle existing Text Snippets, choose Replace existing, so your edits replace the Text Snippets on your phone.
To also remove Text Snippets you deleted in the spreadsheet, choose Delete before importing instead. This also removes empty Folders.