Documentation

Getting Started with DataOlllo

Welcome to DataOlllo — Handle Large Datasets Locally, Without Limits for no‑code, privacy-first data analysis and workflow automation. This guide helps you install DataOlllo, load your first dataset, and build your first workflow.

1. Installation Options

You can install DataOlllo in three easy ways:

1.1 EXE Installer (Recommended — Always Latest Version)

  • Download the latest installer from www.dataolllo.com/download
  • Double‑click the .exe file
  • Follow the on‑screen steps to complete installation

1.2 Portable Version (.7z — No Installation Needed)

  • Download the .7z portable package
  • Extract it anywhere
  • Double‑click DataOlllo.exe to start immediately
  • No system changes, fully portable

1.3 Microsoft Store (Classic Version)

  • Search “DataOlllo” in the Microsoft Store
  • Click Install
  • Auto‑updates via the Store

2. Launching the App

  • Open DataOlllo from your desktop, Start Menu, or extracted folder (portable version)

3. Loading Your First Dataset

DataOlllo opens all the file types you commonly use in daily work — including CSV, XLS/XLSX, JSON, TXT, TSV, HTML tables, log files, as well as other frequently used formats like Parquet, Feather, ORC, and Arrow.
Whether it’s exported from a website, a spreadsheet, a database, or a business system, DataOlllo can load it smoothly so you can start analyzing right away.

You can load a dataset in this way:

Open File

Click Open File → Choose File
Select something like:

shopping_data.csv (example dataset)

Your data appears after a second in the main window.

4. Explore Your Data (Two No‑Code Ways)

DataOlllo offers two ways to explore and transform your dataset — all without writing code.

4.1 Built‑In Functions (Button‑Based)

Use built‑in functions such as:

  • Filter rows
  • Remove duplicates
  • Clean missing values
  • Sort, group, aggregate
  • Create charts

These actions require zero code and operate instantly.

4.2 AI Assistant

You also have a dedicated page explaining the AI assistant in detail, so here we only summarize:

The AI can:

  • Analyze your dataset
  • Create charts
  • Suggest insights

You choose whether the AI receives:

  • Masked metadata + masked sample rows (default),
  • Metadata + Real data (user‑controlled)

And you may connect:

  • Default built‑in cloud LLM
  • Your own API keys (ChatGPT, Gemini, etc.)
  • Local Ollama models

5. Your First Workflow (Quick Example)

Workflows let you automate repeated steps.
Here’s an example using a dataset shopping_data.csv

Step 1 — Add and Analyze Your Dataset

  • Open your dataset (shopping_data.csv)
  • Clean and transform the data: fill NaN values, sort, group, etc.
  • Use either:
    • Buttons for built-in functions
    • AI Assistant with natural language, e.g., “Group by customer_id and sum total_spent”
  • Optionally, add a chart step with the AI Assistant, e.g., “Generate a bar chart”

Step 2 — Save the Workflow

  • Click New Workflow or Save Workflow at the bottom of the chart step
  • Give it a name, e.g., "Shopping Data Analysis"
  • Save it for reuse

Step 3 — ReRun the Workflow on Another Dataset

  • Click Run Workflow → Select a new dataset → Run All Steps
  • DataOlllo will automatically produce:
    • Cleaned data
    • Spending summary
    • A chart

6. Exporting Your Results

You can export:

  • CSV
  • XLS or XLSX
  • JSON
  • Charts (PNG/SVG)
  • Entire workflows
  • Lots of formats

Click Export anytime to save results.

If you need help, visit our Help Center or reach out anytime.
Happy analyzing with DataOlllo! 🚀