New data export features in Database Workbench 7

2026-06-12

Database Workbench 7 offers many new features, including data export functions. Read this summary of the new functionality and changes.

Exporting data is one of the most common tasks in database development and administration. Whether data needs to be shared with colleagues, imported into another application, analyzed in a spreadsheet, or integrated with external systems, having the right export options can make all the difference.

Database Workbench 7 significantly enhances data export by introducing support for modern file formats and a new Export Templates feature that simplifies recurring export tasks.

One Flexible Export Wizard

Database Workbench 7 provides a single Data Export Wizard capable of exporting one or more tables and views in a single operation. This is a usability improvement over previous versions.

Users can start exports directly from the Database Navigator or export data from query result sets in the SQL Editor. The wizard makes it easy to select the desired tables, configure export options, and generate output in a variety of formats.

This unified approach simplifies the export process while providing the flexibility needed for both simple and complex export scenarios.

Export to Modern Data Formats

Database Workbench 7 supports export to a wide range of file formats:

These formats cover a broad range of use cases, from database migrations and system integrations to reporting and spreadsheet-based analysis.

JSON Export

JSON has become one of the most widely used data exchange formats in modern software development.

With native JSON export support, Database Workbench 7 makes it easy to generate data for:

Data can be exported directly in a format that is readily consumed by modern applications, eliminating the need for additional conversion steps. Both array-based JSON and JSON-lines are support.

XLSX Export

Support for Microsoft Excel's XLSX format allows users to create spreadsheet files that are fully compatible with current versions of Excel.

This is particularly useful when sharing data with business users, analysts, or customers who prefer working with spreadsheets. Exporting directly to XLSX streamlines reporting and data analysis workflows.

ODS Export

Database Workbench 7 also supports the OpenDocument Spreadsheet (ODS) format.

This provides compatibility with LibreOffice Calc, Apache OpenOffice, and other office suites that support the OpenDocument standard, giving users greater flexibility in their choice of productivity software.

Export Templates: Save Time on Recurring Exports

One of the most requested features, is the new Export Templates feature.

Many database professionals perform the same exports repeatedly. For example, a team may regularly export reporting tables to Excel, generate CSV files for data exchange, or create JSON exports for integration purposes. Reconfiguring the export settings each time can be inefficient and increases the chance of mistakes.

Export Templates allow these settings to be saved and reused.

A template can store information such as:

Once a template has been created, the same export can be executed again without having to manually configure every setting.

Consistent Results

Templates help ensure that recurring exports are generated using the same settings every time.

This is particularly valuable when data is regularly delivered to customers, business users, reporting systems, or integration processes. By reusing a template, users can be confident that the export is generated exactly as intended.

Faster Export Workflows

For frequently performed exports, templates can significantly reduce the amount of time spent configuring export settings.

Instead of repeatedly selecting tables, choosing formats, specifying filenames, and adjusting options, users can simply select a saved template and run the export.

The result is a faster, more efficient workflow that reduces repetitive work and minimizes the risk of configuration errors.

Built for Modern Data Exchange

The combination of expanded format support and Export Templates makes Database Workbench 7 a powerful tool for data exchange.

Users can:

These capabilities make it easier to move data between databases, applications, reporting tools, and business users.

Conclusion

Database Workbench 7 delivers a significant upgrade to data export functionality. Support for modern formats such as JSON, XLSX, and ODS improves compatibility with today's applications and productivity tools, while the streamlined export wizard makes it easy to export one or multiple tables.

The introduction of Export Templates further enhances productivity by allowing users to save and reuse export configurations. For organizations that perform recurring exports, this means less repetitive work, more consistent results, and a more efficient workflow.

Together, these enhancements make Database Workbench 7 a versatile solution for modern data export and data exchange requirements.