Published 01. February 2019
Updated October 2025
Over the years, KeepTool has built powerful Excel import/export features to make working with Oracle Database and Excel as seamless as possible. Recently, those capabilities have been enhanced further by introducing new, user-friendly functionality. Accordingly, KeepTool now provides even more comprehensive support for Excel-based workflows.
Inside Hora’s interface, users can build custom database queries using SQL, the QueryBuilder, or interactive filters. Then they can organize results with drag & drop grouping. Aggregate functions (such as SUM, COUNT, etc.) work both at the group level and for the overall total.
Once your data is grouped and aggregated, you can export it to Excel with a single click — and the grouping structure and formulas remain intact in the resulting worksheet.
This ensures that your Excel output reflects exactly what you see in Hora, down to aggregated values and grouped rows.
On the import side, KeepTool allows you to load Excel data into an existing Oracle table — but it also goes further: if a target table doesn’t yet exist, KeepTool can automatically create a fitting schema and then import the data into it.
Because KeepTool supports many file formats — including CSV, SQL, KML, XML, HTML, and PDF — Excel becomes just one of many flexible options for data exchange. The integrated reporting tool (based on FastReport) also complements this versatility. For many businesses, Excel remains a primary tool for short-term analysis, so these enhancements bring real value to daily operations.
Explore the updated Excel export/import capabilities within your KeepTool installation. Try building grouped exports, creating new tables on-the-fly, and see how Excel and Oracle stay in sync.
KeepTool's Oracle tools are designed specifically for developers, DBAs, and support teams.
Based on over 25 years of experience, we continuously optimize our software to make your database analysis and documentation faster, more efficient, and clearer.