FLOOKUP AI DOCUMENTATION

Introduction to Flookup AI

Simplify data cleaning in Google Sheets with AI that understands and refines messy data with minimal input.  Rather than relying solely on traditional algorithms, it responds to natural language prompts to carry out corrections, formatting and more, based on your instructions.  

Whether you are fixing typos, harmonising categories or preparing sheets for analysis, this tool adapts to your intent and streamlines the process.

IMPORTANT INFORMATION

Flookup AI an extension but separate feature of Flookup Data Wrangler and requires its own subscription.

• To activate Flookup AI click here. Buy Now Pay Later™ supported.

HOW TO UPGRADE

1. Click the link in the previous section above.

2. Choose any payment method you would like to use and fill in the details as prompted. You could choose to use your PayPal account or your debit card.

3. Open the confirmation email we send to you after your completed payment and copy your "Activation License".

4. Head back to your add-on menu at Extensions > Flookup Data Wrangler > Manage your subscription > Profile activation.

5. Submit your "Activation License" and wait for the confirmation message.

Data Cleaning with Flookup AI

1. Head to Extensions > Flookup Data Wrangler > Smart data cleaning using AI in your spreadsheet menu.

2. Select the data cleaning mode you want to run. See explanation below.

3. Enter your own OpenAI™ API key. You can choose to click the button labelled "STORE" to store the key for subsequent uses or the button labelled "ERASE" to delete the key. Your key is stored securely inside your Google account and it cannot be accessed by any who does not have your login credentials.

4. Highlight a range of data you would like to analyse and click "Grab selected range.

5. Enter your prompt, making sure to reference the data in your selection above using the column number, not column letter. For example, if I selected range B2:H5000, then column B would be "column 1", column C would be "column 2" and so on. This is our recommendation.

6. Click an empty cell to indicate the column where you would like your results to be displayed.

7. Click the "Submit data cleaning prompt" button.

EXPLANATION OF DATA CLEANING MODES

• Match and merge: Compare data from two different columns and return best matches.

• Remove duplicates: Remove duplicates and return only unique values.

• Standardize data: Standardize data by adjusting case, trimming spaces, correcting misspellings and ensuring numeric consistency.

• Transform data formats: Transform data by modifying date formats, converting measurement units and applying user-specified change formats.

• Fill in missing data: Fill missing data with placeholders or computed values.

• Remove common outliers: Remove outliers and return the cleaned dataset.

How to Write Good AI Prompts

• Be clear and direct: Describe exactly what you want to clean or modify e.g. "Remove duplicate rows" or "Standardize dates to DD-MM-YYYY".

• Do not be vague: Use precise language instead of vague terms like "fix" or "clean up". Say what needs to be fixed and how e.g. "Remove duplicates in the first column and second column".  

• Keep it simple: Stick to one task per prompt when possible. If needed, separate complex tasks into multiple steps.  

• Use data cleaning keywords: Short, structured instructions work better than long, detailed explanations e.g. "Remove punctuation marks from all cells".  

• Specify edge cases: If certain values should be ignored or handled differently, mention that e.g. "Do not change column headers".  

• Test and refine: If results are not perfect, tweak the wording slightly to improve accuracy while taking note of the quality of output you are getting.

Flookup AI Usage Policy

The way you use AI for data cleaning depends on your specific use case and data set. Experimenting with different approaches to find the most effective solution is recommended. Please note that the number of rows you can clean with AI is determined by the available load, but it should be at last of 50,000 rows per month.

Flookup AI Privacy Statement

We greatly value your privacy.
Personal details are collected solely to manage your subscription and are never shared.
Data processed via the add-on remains strictly within your Google Sheet and is only transmitted securely to OpenAI for AI-powered responses, never seen by us or any third party.
All operations are sandboxed with encrypted transmission and no data is stored externally.

You retain full rights over your data and can request deletion at any time. For concerns, please contact us via our contact page.

Explore More

The following are quick links to variants of some of the functions shown here that use traditional data cleaning algorithms:

• How to Use Custom Functions to Clean Data

• Removing Duplicates by Text Similarity

• Highlighting Duplicates by Text Similarity