About

What Import & Export Solution does

Import & Export Solution

The Import & Export Solution module gives users a consistent way to move data in and out of the system — exporting any list or report to Excel, and importing spreadsheet data back in through a reviewable, editable grid before it is saved.

Purpose:
This module is designed to remove the friction of getting data into and out of the system. Any list or report can be exported to a real Excel workbook in a click, and spreadsheet data can be uploaded, reviewed and corrected in an editable grid before it is committed — making bulk data entry and external reporting straightforward without custom development for every screen.

Key Features

  • One-click export of any list or report to a native Excel (.xlsx) workbook.
  • Exports respect the columns and data currently on screen, so what you see is what you get.
  • Upload an Excel file and preview its contents in an editable grid before committing it.
  • Correct or adjust imported data directly in the grid prior to saving.
  • Works as a generic, reusable capability rather than a one-off screen-by-screen export.

Business Benefits

BenefitDescription
Faster ReportingAny screen's data can be exported to Excel instantly for further analysis, sharing or archiving.
Efficient Bulk EntryImporting from a spreadsheet is far quicker than entering large volumes of data by hand.
Reduced Data ErrorsReviewing and correcting imported data in a grid before saving catches mistakes before they reach the system.
Consistency Across ModulesThe same export and import approach works the same way everywhere, so users don't need to relearn it for every screen.

Typical Use Cases

  • Exporting a filtered list or report to Excel for offline analysis or sharing with stakeholders.
  • Bulk-loading reference data or records from a spreadsheet instead of entering them one at a time.
  • Reviewing and correcting uploaded data in the grid before it is committed to the system.
  • Archiving point-in-time snapshots of key lists as Excel workbooks.
  • Feeding exported data into external reporting or analysis tools.

Summary

Overall, the Import & Export Solution module makes moving data in and out of the system fast and reliable — exporting any list to Excel in one click, and bringing spreadsheet data back in through a reviewable grid, so bulk data tasks no longer need custom, one-off tooling.

Comes with

Packages with Import & Export Solution

Included in these packages, or available as an add-on.

Compare packages

Module 13 of 20 · tip: use the ← → keys to turn the page

Keep exploring

More modules

See all modules

Ready to see OnTime working for you?

Start small with the modules you need and add more as you grow.