ExcelIt is an innovate tool that enables you export/import data to/from Excel spreadsheets automatically. It acts as a server that periodically runs predefined Excel task files. The Excel task file (in XML format) determines all the actions to be performed upon execution. ExcelIt is fully automated and does not require any programming skills. ExcelIt is a cross-platform product (build on Java technology) that you can install on Windows system or legacy systems such as IBM AS/400.

When should I use ExcelIt?
If you use Excel spreadsheets to distribute data from your legacy DB systems to users inside and outside the organization, ExcelIt is the right tool for you.
If you use Excel spreadsheets to collect data inside and outside your organization, must upload the data to your legacy DB systems, ExcelIt is the right tool for you.

What can ExcelIt do for me?
- Export your legacy DB data to an Excel spreadsheet. ExcelIt creates native Excel files (not CSV), so there is no need to convert the files into XLS format.
- Export your legacy DB data to predefine Excel templates that include graphic definitions such as bar diagrams.
- Import data from Excel spreadsheets into your legacy DB systems.
- Fully automate Excel tasks:
- Determine the frequency of imports/exports (once, every day, every week, at specific times, etc).
- Define the subset of data to be imported into Excel spreadsheets via SQL.
- Automatically import Excel files from a PC directory into the DB (Simply drop the file into the directory; no programming is needed.)
- Pull data files from CyberArk and insert them to AS/400.
- Retrieve data from AS/400 and push it to CyberArk.
- Much more…

Why should I use ExcelIt?

Security
FAQ: Excel users are using ODBC/JDBC to download data directly from the company database to their Excel.
Through the ODBC/JDBC interface they can address tables, rows, record sets, and even perform SQL statements like DELETE, UPDATE etc.
How can I provide my users with the necessary Excel data without jeopardizing the integrity and the security of the company database?
Answer: ExcelIt acts as a server that sets up Excel for your users based on a predefined and approved SQL statement.
The end user never accesses the database via ODBC/JDBC directly. The end user receives an Excel file that has already been downloaded via ExcelIt, so there is no exposure of the company database.

Database load reduced by automated tasks
FAQ: Excel users are using ODBC to download data directly from the company database, often utilizing the database to its maximum capability.
As a result, the other users and applications experience poor response time. How can I prevent my Excel users to run ODBC queries during the busy hours?
Answer:ExcelIt acts as a server that prepares Excel files for your users based on a predefined script. The script enables you to schedule the time when the Excel files are created to make sure that your database resources are not overloaded.

Processing of Excel forms
FAQ: Some of the data exchange in my company is performed by means of Excel forms. Customers and suppliers send records of data in Excel format.I waste a great deal of time processing and uploading the data to the data base. Can I automate this process and upload the Excel data directly to the database?
Answer: Yes. ExcelIt can monitor a directory. Any Excel file that is placed in this directory is automatically routed automatically to its proper database.