https://store-images.s-microsoft.com/image/apps.13127.d9fd6c2e-cf99-4570-b90e-4a6c5dfdc234.afe52074-f8ef-4b4d-a6ae-37301d9992f0.f0a951b8-381e-464d-9875-17a040d8c2a8.png

Opti' Easy Data Analysis Tool

by Thomas LEQUEUX Consulting

(1 ratings)

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

  1. Open your Kobo/ODK (or other) dataset in Excel.
  2. Provide minimal context and analysis goals in the add-in.
  3. 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

When this app is used, it
  • Can read and make changes to your document
  • Can send data over the Internet

At a glance

https://store-images.s-microsoft.com/image/apps.38178.d9fd6c2e-cf99-4570-b90e-4a6c5dfdc234.afe52074-f8ef-4b4d-a6ae-37301d9992f0.1dfcf2ab-f16a-42d5-a535-081684f548ba.png
/staticstorage/20250901.5/assets/videoOverlay_62a424ca921ff733.png
https://store-images.s-microsoft.com/image/apps.38178.d9fd6c2e-cf99-4570-b90e-4a6c5dfdc234.afe52074-f8ef-4b4d-a6ae-37301d9992f0.1dfcf2ab-f16a-42d5-a535-081684f548ba.png
https://store-images.s-microsoft.com/image/apps.7234.d9fd6c2e-cf99-4570-b90e-4a6c5dfdc234.afe52074-f8ef-4b4d-a6ae-37301d9992f0.82182e5e-a563-4e33-9e4c-43b811ebbd18.png
https://store-images.s-microsoft.com/image/apps.18794.d9fd6c2e-cf99-4570-b90e-4a6c5dfdc234.afe52074-f8ef-4b4d-a6ae-37301d9992f0.f53b8686-5f70-463f-978f-079bea3b0657.png
https://store-images.s-microsoft.com/image/apps.28706.d9fd6c2e-cf99-4570-b90e-4a6c5dfdc234.afe52074-f8ef-4b4d-a6ae-37301d9992f0.12b5de8e-7e4b-4eb0-89d2-36170ffad862.png
https://store-images.s-microsoft.com/image/apps.54739.d9fd6c2e-cf99-4570-b90e-4a6c5dfdc234.afe52074-f8ef-4b4d-a6ae-37301d9992f0.b191b351-d76f-469b-9db7-a016d146910b.png