Data import & integration

Import SPSS, Excel and databases

Import SPSS files including labels, CSV and Excel, or connect your database directly. DataLion detects structures automatically. The dataset is ready for an interactive dashboard without manual preparation.

Try DataLion free Book a demo
DataLion dashboard built from imported data

DataLion imports SPSS files with variable and value labels, plus CSV and Excel. It connects directly to databases such as MySQL, Exasol and Oracle. The software detects data structures automatically. Scheduled imports keep dashboards current. A new dataset can be available in an interactive dashboard within minutes.

  • 🇩🇪 Made in Munich
  • GDPR-compliant
  • DPA included
  • Hosted in Germany
  • 🌐 Interface in EN, DE, FR & NL

Direct SPSS import — including labels

DataLion imports SPSS files (.sav) together with variable and value labels. No manual rework, no lost metadata.

Handle weighting, recoding and flexible bases directly in DataLion — exactly the way market research needs it.

  • SPSS .sav import including labels
  • Weighting and flexible bases per question or category
  • Recode and compute new variables
  • Analyze open-ended responses
DataLion demo dashboard

Automated imports from survey platforms

Connect your survey software (e.g. LamaPoll, Qualtrics) and let data flow in automatically. Scheduled imports keep tracking dashboards up to date with no manual work.

After setup, scheduled imports update your reports with each new wave.

  • Integration with common survey platforms
  • Scheduled, automatic data updates
  • Ideal for tracking studies and waves

CSV with smart clean-up

Column names with dots, spaces or special characters? DataLion offers auto_fix or lets you correct the file yourself. Delimiters are detected automatically.

Identifiers may also contain `#`, `@` and `.` — with clear error messages if something still does not fit.

Connect databases & APIs

From single files to large datasets: DataLion connects MySQL, Exasol, Oracle and other SQL, NoSQL and big-data sources — plus API imports.

Your analyses always sit on the current, central data foundation.

  • MySQL, Exasol, Oracle and other databases
  • SQL, NoSQL and big-data sources
  • API imports

AI-powered codebook mapping

When you import a codebook, DataLion automatically suggests the right column mappings and detects data structures and metadata with AI.

Learn more on our AI-powered market research page.

Related topics

Common questions about data import

Can DataLion import SPSS files with labels?
Yes. DataLion imports SPSS .sav files including variable and value labels and integrates the metadata automatically — with no manual rework.
Do my dashboards update automatically?
Yes. Through scheduled imports and survey-platform integration, new data flows in automatically so tracking dashboards stay current without manual effort.
Which databases does DataLion support?
DataLion connects MySQL, Exasol and Oracle as well as other SQL, NoSQL and big-data sources, and additionally supports API imports.
Can I import CSV files with special characters in column names?
Yes. DataLion detects problematic column names and offers automatic clean-up (auto_fix). Identifiers may also contain #, @ and . characters.
Does AI help with data import?
Yes. When importing a codebook, DataLion automatically suggests matching column mappings and detects data structures and metadata with AI.

Get your data into a dashboard in minutes

Try DataLion free with your own SPSS, CSV or Excel data — or book a personal demo.

Start for free Book a demo