How to export all fields into excel from a list view with out personalizing list

Ansuha Chipuri
Kilo Guru

Hi,

How to export all fields into excel from a list view with out configuring  personalizing list

Thanks in Advance

5 REPLIES 5

JC Moller
Giga Sage

Hi,

 

One way is to utilize the Easy Import's excel template creation. I use this a lot eg. when I quickly need to export sys_id's from a list of data

 

First make your query in the form's filter.

Select the Import option from any column:

find_real_file.png

Select:

Update

Do you want to create an Excel template to enter data? Yes

Include all fields in the template? Yes

Press Create Excel template -button.

The data for your query will be exported as a excel file with all the table's columns included.

find_real_file.png

In this case you will not use the template for importing data back to the system, so you can delete the first Directions tab in the excel sheet and make your required changes to the columns.


A quick and handy way to get the needed data exported. This feature requires admin rights.

BR,

Jan