Goodlookup delivers the benefits of AI language models to regular people.

The main limitation of traditional fuzzy matching is that it doesn’t consider similarities or cultural references outside of the text strings. Automated fuzzy matching and topic clustering require semantic understanding. Fortunately, recent advances in NLP technology have unlocked new possibilities with text data.

Goodlookup is a smart function for spreadsheet users that gets very close to semantic understanding. It’s a pre-trained model that has the intuition of GPT-3 and the join capabilities of fuzzy matching. Furthermore, it provides confidence scores so users can gauge how well the matches fit. Use it like vlookup or index match to speed up your topic clustering work in google sheets.

https://www.goodlookup.com/

Text Tools and Smart Utilities! Text processing and string manipulations in Excel are not an easy tasks but we’ll help you to simplify string related functions using our add-in.

Feature list:

• Convert text to uppercase, apply Excel lowercase to your data or convert your text values to proper / title case
• Delete first or last character from a selected string
• Delete x characters starting at the nth position
• Remove spaces, non-printable characters, all line breaks, initial apostrophes
• Insert text before first, after last character
• Insert text starting at nth position and much more….
• Calendar. Quick dates entry to save your time.
• Drop-down list creator: Create drop-down list in selected cells in seconds
• Spreadsheet Tools – Effective management for Ranges
• Data Collector: Consolidate Multiple Worksheets into one Workbook
• Split Ranges: Split one data table into several different sheets based on the values of the specified column or other criteria.
• Compare Ranges: Compare two columns or ranges and the output or highlighting of coincidences / differences between them.
• Clean Ranges: Delete text, formats, notes, hyperlinks, conditional formatting, etc. in selected cells.
• Screenshot Manager: Create screenshot of selected range and export it into various formats.
• WorkSheet Manager
• Perform vary operations (adding, sorting, protecting, etc.) on sheets in current workbook.