STANDARDIZE DATA

Overview

The Standardize Data tool helps you clean and normalise your data by removing noise such as stop words, punctuation and diacritical marks. This is a crucial pre-processing step that significantly improves the accuracy of fuzzy matching and data reconciliation by focusing on the substantive content of your text.

How to Use the Standardize Data Tool

  1. Select the function to run
    Open Flookup and select Standardize Data.
  2. Select the range to clean
    Highlight the column or range of data you wish to process and click Grab selected range.
  3. Specify the result location
    Click an empty cell within the spreadsheet to mark the position where the cleaned results should be displayed.
  4. Choose the cleaning operation
    Select the type of content to remove, such as Remove punctuations, Remove diacritics or Remove stop words.
  5. Clean the data
    Click the Standardize data button to finish.

Visual Learning Resources

Labels might differ slightly but the steps remain the same.

You Might Also Like