Flookup is a powerful data cleaning suite for Google Sheets. It is designed to handle different kinds of datasets, including those that contain text entries with partial matches, typos or different spelling conventions. π A BRIEF OVERVIEW OF FLOOKUP FUNCTIONS + NORMALIZE: Remove diacritical marks, punctuation marks or stop words from any text. This is particularly useful if applied before using any of the functions mentioned in this list. + FUZZYMATCH: Calculate the percentage similarity between two text entries. You can also calculate the percentage similarity between concatenated text entries. + FLOOKUP: Fuzzy match or merge data in vertically structured data, based on percentage similarity. Matches for each lookup value are ranked in order of descending percentage similarity. + SOUNDMATCH: Fuzzy match or merge data in vertically structured data, based on sound similarity. Matches for each lookup value are ranked in alphabetical order. + ULIST: Extract unique values from a specified range based on percentage similarity. + REMOVE DUPLICATES: Use this function to delete any duplicates based on how similar the text entries are by percentage or sound similarity. You can also rollup or combine multiple rows by percentage similarity. + HIGHLIGHT DUPLICATES: Use this function to highlight any duplicates based on how similar the text entries are by percentage or sound similarity. These functions can all be accessed by heading to "Extensions > Flookup Data Wrangler" in your spreadsheet menu. ************************* π HOW TO START USING FLOOKUP Immediately after you install Flookup, you can start using it. During this time, you will be limited to 5 function executions, each processing a maximum of 100 rows, every 24 hours. π§ For a detailed guide, please head here: https://www.getflookup.com/how-to-manage-subscription ************************* π COMMON FLOOKUP USE-CASES + Email Campaigns: Boost your email marketing efforts by cleaning your email lists. Remove duplicates, out-of-use, and invalid email addresses to ensure maximum deliverability and engagement. + Competitor Research: Stay ahead of the competition by performing in-depth analyses of URL and page title differences. Identify keyword opportunities and optimise your content for better search engine visibility. + Internal Linking Opportunities: Enhance your website's user experience and SEO by identifying and linking pages with the same topic cluster or content structure. Find and link relevant pages with ease. + Database Scrubbing: Keep your database error-free with Flookup. Fix common issues like spelling mistakes, missing or duplicate entries, and formatting differences to ensure accurate and reliable data. + Database Standardisation: Ensure that your records are up-to-date and consistent by comparing and linking data across separate sources. Standardise your database for improved accuracy and efficiency with ease. + Website Redirect Mapping: Simplify the process of mapping redirects for 404 and site migration cases. Reduce manual work and errors and improve your overall SEO strategy. + Fraud Detection: Protect your business from fraud by discovering and removing data that exists in more than one database when it should not. Detect "disguised" spelling differences to ensure maximum security. + Platform Independent Fuzzy Matching: Enjoy a peerless fuzzy matching alternative, available on platforms like Windows, macOS, and Linux. Flookup provides a powerful and flexible solution for all your fuzzy matching needs. ************************* π CLEAN-AS-YOU-GROW PRICING PLANS In addition to a free version, we offer these awesome token-based pricing plans to clean data at your own pace: + FLOOKUP STANDARD: $5 / USER / 100 TOKENS + FLOOKUP PROFESSIONAL: $10 / USER / 200 TOKENS ... and they do not expire. Each feature in this plan is carefully selected to meet your data cleaning needs. Please visit our website to find out more about Flookup. ************************* β [OFFICIAL WEBSITE] https://www.getflookup.com β [TWITTER] https://www.twitter.com/getflookup β [LINKEDIN] https://www.linkedin.com/company/flookup-data-wrangler ************************* β If you liked Flookup, please leave us a five-star rating on this platform. βοΈ If you didn't like Flookup, please let us know how we can serve you better. β Your time is much appreciated. π«±π»βπ«²π½ Thank you for choosing Flookup. ************************* [TAGS] VLOOKUP Google Sheets, Fuzzy Match, Fuzzy Search, Dedupe, Data Quality, Data Merging, Data Matching, Data Cleaning, Data Cleansing, Fuzzy Lookup Mac, Fuzzy Matching Software, Fuzzy Match Online, Highlight Duplicates in Google Sheets, Remove Duplicates in Google Sheets, CRM Dedupe Software, Keyword Clusters, OpenRefine, Library Carpentry, FuzzyWuzzy, Soundex, Metaphone, Plagiarism Checker, Data Rollup, Data Aggregation