Intelligo
Feature Overview

OfficeReports Intelligo automates the entire market-research reporting workflow inside Excel and PowerPoint.Below you’ll find a complete overview of all Intelligo features — from survey data import and crosstab creation to live PowerPoint updates and AI-assisted report automation.

Workbook

Data

Import raw data from SPSS, Excel, CSV etc.
Connect directly to SurveyMonkey and Alchemer
Import/Merge multiple Datasets
Explore & Discover: Quick data overview incl. significance

Data Editor

Variable View & Data View
Recode Variables
Search & Replace Text
(Un)hide Variables
Create Aggregate Variables

General

All Excel functionality as an integrated part of the reporting

Crosstabs / Banner Tables

All Basic Statistics (incl. Confidence interval, Chi Square & Median)
NPS & Top/Bottom N
Advanced Sorting (Rows & Columns)
Z-Test (Column Proportions)
Student's & Welch's T-Test (Column Means)
Low Base notification: 2 levels by optional characters
Weighting
Grid Tables (containing many variables)

Productivity

Create Many Tables in one step
Copy/Paste Tables
Copy/Paste & Filter Worksheets
Refresh Worksheet / Refresh Report
Mass-Edit Tables

Advanced

Filtering on 3-levels (Report & Table & Table Column)
Ignore Filters (from other levels)
Create Weighting Variables (RIM)
Correlation
Pairwise Sig Test: Show significance as font- or background-color
Second Pairwise Sig Test in same table
Sort Table Like (another table or range)

Report Automation

3 'Hierachy' Report Filters (for tracking surveys and generating many reports)
"Compset" functionality (International Brand Comparison)
Save Report as a Template
Generate Reports (using different filters, 3 'hierarchy' levels available)
MS Office VBA-Macro Integration

Presentation

PowerPoint Shapes

Link fill and font colors from the Excel range (use Excel's Conditional Formatting)
Text-to-Image
Link background colors from the range

Customizable Infographics

Sliders
Filled Shapes
Conditional Shapes (e.g. Smiley)

General

Slide Library
Automatically create and attach a worksheet for every utilized slide
Generate "Table of Contents" Slide(s)

Interactive Filters

Dropdown Filters for 'Slide Show'
Slicer Filters for 'Slide Show'

PowerPoint Tables

Automatic adjustment of number of rows and columns based on selected Excel range
Link fill and font colors from the Excel range (use Excel's Conditional Formatting)
Color-Driven Icons based on Excel fill or font color
Text-to-Image
Switch row/column
Hide 'Zero Values' in tables and charts
Efficiently display long lists across multiple slides
Automatically remove 'zero' rows and/or columns

Report Automation

Copilot - Populates tables and chart on many slides using your specifications
Utilize 'dynamic' links: automatically adjust the linked number of rows and columns from Excel area
Automatically 'refresh' the entire presentation with data from another workbook
Generate Reports (controlled by 3 'Hierarchy' filters)
MS Office VBA-Macro Integration

PowerPoint Charts

Chart Types: Rotated Line, Quadrant, XY, Diverging Bar
Automated labeling for XY-charts, inside the chart or adjacent table
Color-Driven Icons based on Excel fill or font color
Text-to-Image
Switch row/column
Hide Zero Values
'Sticky' colors: Maintain consistent e.g. brand colors, even after sorting
Table-based Axis Text Display with text formatting and alignment
Automatically remove 'zero' rows and/or columns

Reorganizing Data in Excel

Linked Range - Links directly to the needed data
Lookup Range - Text search to find a range
Lookup Table - Text search to find specific cells
See how it works
Button Right Arrow
Pricing
Button Right Arrow
Request a Demo
Button Right Arrow
Try it now
Button Right Arrow
Footer Logo
Trusted by users in 30+ countries

OfficeReports helps businesses automate survey reporting, ensuring fast, accurate, and professional data visualizations without manual updates.

Compatible
ExcelSPSSQualtricsSurveyMonkeyAlchemer
Find us on
GreenbookQuirksCapterraG2Software AdviceGetApp
Copyright ©2025 OfficeReports