Tips and Timesavers: Export ERP data to Excel®

This is a “tips and time savers” blog – highlighting handy features you might not be aware of that can help in your day-to-day use of Abel.

Sometimes it may be helpful to export data from Abel’s Tables to Excel, for example when you want to analyze the data for your own purposes. Most Abel screens that have tables have this capability.

To export a Table to Excel you need to: 

  1. On the Abel table you want to export data from press Ctr + T.Abel opens the Report Launch screen.
  2. Select Export to File
  3. Set the Orientation and Stretch settings
  4. Click Run Report
  5. Abel exports the table data to an Excel file. When done, the File name turns blue. Double-click the File Name to open the file in Excel…

Abel opens the file in Excel.

Stay up to date with us

Explore our feature insights, practical tips, and company news.

Stay up to date with us

Explore our latest resources and expert insights and industry news.

jane

To celebrate the start of Abel’s 30th year, we tried something different by bringing together…

rik

The Navigator in Abel Version 7 is designed to bring relevant functions and actions into view…

jane

To celebrate the start of Abel’s 30th year, we tried something different by bringing together…

rik

The Navigator in Abel Version 7 is designed to bring relevant functions and actions into view…

rik

Abel’s Global Search is about to become your new best friend. Available in Abel Version…

jane

To celebrate the start of Abel’s 30th year, we tried something different by bringing together…

rik

The Navigator in Abel Version 7 is designed to bring relevant functions and actions into view…

rik

Abel’s Global Search is about to become your new best friend. Available in Abel Version…

jane

Abel is celebrating 30 years in business, and the continued growth of Abel®, our flagship…

Find out how Abel® can benefit your business

Search