Opti' Easy Data Analysis Tool
by Thomas LEQUEUX Consulting
Opti’ automates data analysis, turning database into clear tables and AI-generated reports
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.
App capabilities
- Can read and make changes to your document
- Can send data over the Internet