Graphs and Charts, Core Enhancements, Data Import & Export, Data Reports, Tables & Lists

jDBexport allows you to deliver any data from your databases (JOOMLA and others) as Excel documents directly to your users. Write any valid SQL query in the administration of this component and combine such queries into multiple Excel worksheets/workbooks. The query is executed when a user clicks the downloadlink (frontend or backend) and the current result of the query is delivered to the user as a downloadable Excel file (or any other of the below listed document formats). With the on-the-fly ajax-driven SQL syntax checker, the multitude of available export dataformats, formatting options and a great number of database drivers to get your data from, jDBexport is very likely the most exhaustive reporting instrument and data mining tool available on the market.

  • Favourite
  • Report

Main features

  • create data reports in various formats (xlsx, xls, ods, csv, html, pdf, json) from your databases
  • individualise these reports with variable substition (such as userid or current date) or parameters entered by the user
  • embed graphical charts (bar, pie, area, line, etc.) based on the requested data into your worksheets
  • format these reports with colors, fonts, backgrounds (also alternating backgrounds), images, headers and footers, borders and more
  • use a wide varity of conditions (including the result of SQL queries) for conditional formatting
  • add additional cells with text, images or results from additional SQL queries
  • define autofilter areas within your worksheets
  • add any additional files (e.g. Excel Makros in an *.xlmx file) along with your workbook when compressing is activated
  • deliver these reports regularly and fully automatically to your users, utilising our sophisticated scheduler
  • define SQL based rules whether to run the scheduled task or not
  • or let the users request these reports online or in the background or through the GoogleDocViewer
  • or let the users preview these reports in a HTML preview within your website
  • or prepare these reports (without showing them) for post processing with individual programs
  • include virtually any accessible database - local or remote - into your reports (MySQL, MariaDB, MS-SQL, ORACLE, SQLite3, DB2, INGRES, SAP MaxDB, PostgreSQL, Firebird and others)
  • check the validity of your SQL query with our on-the-fly (AJAX-driven) SQL syntax checker, while preparing the worksheet
  • get inline help on creating your SQL queries, or reference the SQL manual that corresponds to your environment
  • and many, many other features...

  • jDBexport is translated in many languages (you can help us here...)

-jDBexport comes with a set of additional tools (frontend and backend module for easy access to your workbooks, datagrid and datafield plugin to embed worksheets or a single cell from a worksheet into any Joomla content, workbook link plugin to style jDBexport workbook links according to your template, support for additional Truetype fonts in PDF creation)

If you are missing a specific feature, call us and we will find a solution...

jDBexport was originally forked from the well known (Joomla 1.5 data reports) extension SQL2Excel (actually SQL 2 Excel Pro).

For helping with the translation of jDBexport into your own language, please visit or translation project at

For more details, please visit our website at

{functionality}Fully compatible with Excel, it allows you to generated files with filters, conditional, etc..{/functionality}\n{ease_of_use}Needs some knowledge specially when linking more than two tables. SQL checker is of great help. Help given in the forum and sql forum.{/ease_of_use}\n{support}Assistance given by the developer is amazing. He responds immediately to emails and provide the necessary assistance. {/support}\n{documentation}Consistent and useful. {/documentation}\n{value_for_money}100%{/value_for_money}\n

I used this to: To generate email list for my users and to extract data required for the instructors of my sport club.

{functionality}conditional formatting based on cell contents, customized texts and logo, charts, PDF, full compatibility with excel, I am blown away!{/functionality}\n{ease_of_use}it's very easy, it includes the SQL checker, and it is not overwhelming. You use what you need, without having to repeat the same steps{/ease_of_use}\n{support}The author quickly answers your e-mails, he provides you with all the information you need, very kind and very professional{/support}\n{documentation}There is an extensive documentation, and it was written for new users. I just wonder how to do something, and I find it already explained{/documentation}\n{value_for_money}It is not just Excel export, it allows you to create charts, PDF files, in other words a complete package! Outstanding value!{/value_for_money}\n

I used this to: I use it to develop automatic monthly reports in Excel, where the cells are custom-formatted based on their contents, so the users can use Excel filters and calculations. I use many databases, which is why this extension is perfect!

{functionality}Funktioniert tadellos.{/functionality}\n{ease_of_use}Intuitiv bedienbar.{/ease_of_use}\n{support}Exzellenter Support mit sofortiger Antwort innerhalb kürzester Zeit. Problemlösung innerhalb weniger Stunden! {/support}\n{documentation}Sehr umfangreich.{/documentation}\n{value_for_money}Sehr gut{/value_for_money}\n

I used this to: Datenbankabfragen mit Benutzereingabe und Download in Excel

{functionality}jDBexport hält, was es verspricht und bietet unendliche Einsatzmöglichkeiten, um Daten als Excel zur Verfügung zu stellen.{/functionality}\n{ease_of_use}Logisch aufgebaut und nach kurzer Zeit einfach zu benutzen.{/ease_of_use}\n{support}Super Support des Herstellers - antwortet bei Anfragen innert kürzester Zeit.{/support}\n{documentation}Noch keine Erfahrungen, was ja auch wieder für die Anwenderfreundlichkeit spricht{/documentation}\n{value_for_money}jDBexport ist seinen Preis wert - bei rechtzeitiger Verlängerung der Subskription gewährt der Hersteller zudem einen Rabatt.{/value_for_money}\n

I used this to: Unter anderem werden Vereinsmitgliedern Mitgliederlisten und Veranstaltern Anmeldeübersichten zur Verfügung gestellt.

{functionality}Creates complex Excel sheets for my client{/functionality}\n{ease_of_use}If you know your way around SQL, you can do almost anything with this extension.{/ease_of_use}\n{support}Excellent, in-depth support. Whatever the problem, Ruediger is determined to solve it. {/support}\n{documentation}For some subjects, a little more explanation would be nice. But overall: very good documentation.{/documentation}\n{value_for_money}Worth every penny.{/value_for_money}\n

I used this to: Creating large, complex, multi-sheet Excel spreadsheets containing and combining data from different tables in the database.

Excellent Tool

Posted on 05 January 2017

{functionality}Allows me to offer excellent up-to-date databse information to my customers{/functionality}\n{ease_of_use}Like anything complex you need to read the instructions. This is not for the absolute beginner.{/ease_of_use}\n{support}Can't be bettered. The developer is repsonsive, polite and knowledgable.{/support}\n{documentation}Excellent{/documentation}\n{value_for_money}Excellent{/value_for_money}\n

I used this to: Extracting up-to-date contact data.

{functionality}Used for getting data out of various Joomla products{/functionality}\n{ease_of_use}You'll need a bit of SQL knowledge to get full use, but a keen amateur could probably find all the code they need on the web.{/ease_of_use}\n{support}Always there and willing to help when you need it.{/support}\n{documentation}Fairly comprehensive, just a few gaps an maybe a few more examples would help.{/documentation}\n{value_for_money}Excellent value{/value_for_money}\n

I used this to: Extracting reports from other extensions that have left reports as an after-thought.

{functionality}There is no way to add a password-to-open to the spreadsheet. Ruediger offered to custom develop this, but I came up with a workaround.{/functionality}\n{ease_of_use}Very clear to use - I barely needed the manual.{/ease_of_use}\n{support}Unusually outstanding support - A+. Ruediger responded immediately to a minor issue I had, and quickly developed a patch. {/support}\n{documentation}Very good, although not really needed for most use cases once you understand the basics.{/documentation}\n{value_for_money}Well worth the money{/value_for_money}\n

I used this to: jDBexport was a great way for our club to transition from an Excel based membership database to an online Community Builder database. We still have many workflows that require the spreadsheet, but now they can be automatically generated/maintained from the database.
Owner's reply: Carl, this is just to let you know:
PHP 7.2 (as of upcomming RC-2) seems finally capable of handling zip file passwords. We are investigating this (but it looks very promissing)...


Posted on 22 June 2016

{functionality}Super product with great features{/functionality}\n{ease_of_use}Easy to use{/ease_of_use}\n{support}Excellent support in upgrading to the latest version 3.2.4.

Support was always very quick with the answers and the correct solution.

{/support}\n{documentation}{/documentation}\n{value_for_money}price-performance best note{/value_for_money}\n



Posted on 12 May 2016

{functionality}Brings everything it promises and more. Finally able to give an easy way for non-techies to get data-extractions from database!{/functionality}\n{ease_of_use}Relatively easy to set up and once you get used to the system, really easy to use.{/ease_of_use}\n{support}First class. Had some issues and got always personal and timely support!{/support}\n{documentation}Documentation in the web is easy to understand and covers all the bases. Perhaps a couple of more examples there would be ok but that's all.{/documentation}\n{value_for_money}For this price this is a professional tool and absolute value for money!{/value_for_money}\n

I used this to: Allowing my "non-techies" to extract mailing-files for our organization for printing labels etc.
Have I been pwned - password checker Have I been pwned - password checker
Paid download

Have I been pwned - password checker

By Schultz IT Solutions
User Management
With this plugin, you can notify your users if they intend to use a password that was previously compromised or "pwned" in a data breach. You can even define whether your website allows such passwords or rejects them. To provide this service the plugin refers to the "Have I been pwned" API ( by Troy Hunt). When a new user registers and submits a password (or an existin...
eps Ueberweisung (and giropay) for J2Store eps Ueberweisung (and giropay) for J2Store
Paid download

eps Ueberweisung (and giropay) for J2Store

By Schultz IT Solutions
J2Store extensions
This plugin integrates the austrian "eps Überweisug" and the german "giropay" online payment solutions into your J2Store webshop. It is targeted at webshop owners with an austrian bank account and allows your customers to pay your goods and services by autorising the payment within the online banking application of their own (austrian or german) bank.The plugin builds on the eps XML definition (...
eps Ueberweisung and giropay payments for Joomla! eps Ueberweisung and giropay payments for Joomla!
Paid download

eps Ueberweisung and giropay payments for Joomla!

By Schultz IT Solutions
Payment Gateway
This plugin integrates the austrian "eps Überweisug" and the german "giropay" online payment solutions into your JOOMLA website (if you do not use a webshop software). It is targeted at website owners with an austrian bank account and allows your customers to pay your goods and services by autorising the payment within the online banking application of their own (austrian or german) bank.The plu...


Schultz IT Solutions
Last updated:
Oct 18 2018
Date added:
Jul 07 2012
GPLv2 or later
Paid download
c m p

Uses Joomla! Update System


Write a review