Alfred Snippet Generator lets you transform a spreadsheet (e.g. Google Sheets or Excel) into an .alfredsnippets file, which you can then be imported into Alfred 3.
Entirely cross-platformly browser-based (new browsers). Provides a textarea that triggers a conversion/download when you paste TSV content (just select all your cells and copy from your sheet):
Here is an example spreadsheet if you just want to try it out immediately.
Alfred Snippet Generator uses tab-separated format (TSV) because it's easy to copy+paste it directly from Google Sheets or Excel. Create a sheet with the following columns and add as many rows as you need. This is designed for helping maintain long lists of snippets like emoji or HTML entities, or importing snippets from other systems.
- Keyword(s): e.g.
fox
orfox,foxface,fox face
(required) - Snippet: e.g.
🦊
(required) - Name: e.g.
Fox Face
(optional)
Recommend not to hard-code prefixes or suffixes in keywords, as Alfred now includes the ability to customise these per snippet group. Locking them in means other users of your snippets can't edit them :(
Include multiple keywords for the same snippet by separating the words with commas. Don't add spaces around the commas or the spaces will be included in the keywords!
This demo spreadsheet for Emoji and HTML character entities shows an example of what you need. To try it out just highlight+copy all cells, then paste into Alfred Snippet Generator.