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.

rik

User Access Becomes More Complex: You may find that managing user access across your organisation…

rik

Navigating Complex Foreign Exchange and Intercompany Processes: Organisations operating across multiple currencies and entities may…

rik

User Access Becomes More Complex: You may find that managing user access across your organisation…

rik

Navigating Complex Foreign Exchange and Intercompany Processes: Organisations operating across multiple currencies and entities may…

rik

Keeping BOM changes controlled while production keeps moving: In manufacturing, engineering, electronics, and food manufacturing,…

rik

User Access Becomes More Complex: You may find that managing user access across your organisation…

rik

Navigating Complex Foreign Exchange and Intercompany Processes: Organisations operating across multiple currencies and entities may…

rik

Keeping BOM changes controlled while production keeps moving: In manufacturing, engineering, electronics, and food manufacturing,…

rik

If you find yourself opening the same screens or reports again and again in Abel,…

Find out how Abel® can benefit your business

Search