Opti’ is an Excel add-in that turns raw survey data into clear analysis tables and decision-ready, AI-assisted reports — directly inside Excel, no coding required. Built for humanitarian, development, and field-research workflows, it helps teams move from data to insight in minutes.

Pricing disclosure: Opti’ includes a 14-day free trial with unlimited analysis tables and limited AI tokens.

After the trial period, to continue using the add-in a paid subscription is required.

(monthly or annual). Full details of available plans are provided on our website:

https://lequeux-thomas.com/addin/.

Who it’s for

MEAL officers, M&E consultants, data analysts, project coordinators, database managers, local & international NGOs, UN agencies, and research institutes — anyone working with KoboToolbox, ODK, XLSForm, or Google Sheets exports.

What it does

Automated tables (in Excel) — Generates reliable tables with auditable, reusable Excel formulas.

Four analysis modes — Adapted to real humanitarian and research workflows, each mode is fully automated and generates reliable Excel tables:

Simple: Instantly produces percentage distributions for each selected column — ideal for a quick, high-level overview of your dataset.

Cross: Disaggregates any variable by a reference column (e.g. sex, region, age group) to highlight differences and comparisons.

Simple-multi: Designed for multiple-choice questions (common in Kobo/ODK exports), automatically grouping responses and generating one clean table per question.

Cross-multi: Combines cross-tabulation with multiple-choice groups, producing detailed disaggregated tables without manual cleaning.

AI-assisted interpretation — Beyond tables, Opti’ transforms raw outputs into decision-ready insights:

Per-table insights: Each table is explained in plain language, highlighting key trends and outliers.

Synthesis: Condensed takeaways for busy decision-makers, pointing directly to what matters most.

Final narrative report (Pro & Infinity): A publication-ready document with trends, correlations, adapted writting from your guidances and automated protection & accountability alerts.

Multilingual — Understands and writes in 120+ languages.

How it works

Open your Kobo/ODK (or other) dataset in Excel.

Provide minimal context and analysis goals in the add-in.

Select analysis modes & columns, then generate tables + summaries (and the final report on eligible plans).

Why customers choose Opti’

Time saved, week after week — Run dozens of analyses in batch, avoid repetitive work, and free up hours for interpretation instead of manual processing.

Clarity & consistency — Clean, standardized tables and focused narratives that reduce ambiguity and make reports easier to share with donors, partners, and field teams.

Seamless workflow in Excel — No external tools or coding required. Opti’ works where your data already lives, with transparent formulas you can audit and reuse.

Decision-ready outputs — From quick snapshots to full narrative reports, insights are presented in a way that supports real-time decisions in humanitarian and development contexts.

Plans

Discovery — Entry plan to explore Opti’. Generate automated analysis tables directly in Excel and experience faster, cleaner reporting. Ideal for trial and training.

Essential — All core features unlocked: AI-powered table summaries, synthesis at run level, and consistent outputs for everyday survey analysis.

Pro — Designed for publication-ready outputs. Includes everything in Essential plus the final narrative report: structured findings, trends, correlations, and accountability alerts.

Infinity — Enterprise-grade plan: higher limits, multi-user support, and customization options for organizations that need scalable, collaborative survey analysis.

Requirements

Microsoft Excel; internet connectivity for AI features. Works with datasets exported from KoboToolbox, ODK, XLSForm, or Google Sheets.

Opti' Easy Data Analysis Tool

by Thomas LEQUEUX Consulting