SQL 2 Excel

Serving 3666 extensions to the community

Directory Menu

Login or Register

Home

Core Enhancements

Data Reports

SQL 2 Excel is a Component which enables you to deliver data from your database directly to your users as downloadable Excel files. Write any valid SQL query in the Component backend. The query is run when a user clicks the link and the current information in the database is delivered to the users browser as an Excel file. Multiple worksheets (e.g. different queries) can be compiled into one single Workbook. The spreadsheets are compatible with Microsoft Excel as well as OpenOffice Calc.

You can publish your reports in three different ways:

- Download them in the Joomla Administrator backend
- Publish the SQL 2 Excel Module to one or more pages and let users download the spreadsheets through the module links
- Publish the Sections / Categories list view to a menu and let users browse your sections/categories to locate desired report(s)

Use SQL 2 Excel for all your reporting needs. Deliver dynamic reports to your users, export table data from Joomla, get usage statistics or just a quick data dump for debugging purpose etc.

Sample reports for many popular extensions, such as Acajoom News, BookLibrary, Communicator, Community Builder, DOCman, EasyBook, EventList, Kunena Forum, Jx Jambook, JCollection, JomSocial, Joom!Fish, !JoomlaComment, Jom Comment, Lyften Bloggie, Media Library, Phoca Download, Phoca Gallery, Qcontacts, RD Autos, RokDownloads, RSMonials, SimpleCaddy, SOBI2, Teamlog, Virtuemart, WebAmoeba Tickets System, as well as for the standard Joomla content and users.

v1.8.1 : Nov 9 2009 : Bug fix: Substitution variables in Worksheet Names

Images

Reviews (10)

Great enhancement... upgrade it's worth the price

byswilliford on August 22, 2009

I started with the standard and quickly upgraded. Both work great but for the price an upgrade is well worth the additional features.

Great product, Superior support!!!

bykasnoff on May 5, 2009

Needed a soulution for an export of new users from Community Builder. Every email with issues (some his, mostly mine) was handled promptly, friendly and included information and suggestions well beyond my problem. He and his products will be around for a long time.

Thanks Mats!!!

Great life !

bycigo on April 23, 2009

I believe this component and its pro version will have both a long life. It is indeed an intelligent work ! Cong.

Good business oriented component

byprofinvent on April 14, 2009

Joomla core components as well as many available 1.5 extensions are missing one key feature = export. SQL2Excel fills the gap, as you can define your own queries and export any data you would like from your Joomla database.
It is very user friendly and intuitive. Great work.

Fantastic !

byilanb on March 26, 2009

Fantastic component, easy to use and clean worsheet.
Maybe add a module on backend to download worsheet.

I waiting for pro version...

Thanks

Ilan

Owner's reply

Thanks for the nice feedback!

SQL 2 Excel Pro comes with a cPanel module which provides easy access to your favorite reports in the Joomla backend.

Great Extension & Great Support

byimscoop22 on March 10, 2009

This extension offers a world of possibilities for accessing data in your data for reports, etc. The author provides great support and has been adding functionality at an impressive rate.

Really! a Must Have Add-On!

byGammX1 on March 9, 2009

Excellent Work!... helps a lot for dummping down any info from the MySQL DB to an Excel workbook with just a "click and save" from the Frontend.
Keep up this good work!
Rgrds,
GammX1

Works well.

byschipper on March 5, 2009

Very useful extension especially to export data from filled forms from the frontend. Easy to install.

Fantastic!

byscandalousrumor on March 4, 2009

The really satisfied a need for my users. Easy to use right out of the box - just paste in your SQL code. And the developer has been really quick and accommodating for addition of suggested new features.

VERY GOOD MODULE

byGrandcru on February 21, 2009

The module I was looking for to allow extracting some table-contents in the frontend as an excel sheet!
Easy to use. You only need some SQL-Knowhow, that's all!
Seems not te be the final version, can be improved, but makes what you want it to do!

THANKS FOR THE GOOD MODULE!
... and for the very quick support via the forum!