By clicking on the ‘ETFs’ icon located in the Lists section you can pull in Barchart.com ETF lists directly into Excel.
Once selected, the ETFs dialogue will display where you can select a list you wish to insert.
Depending on the list selected, the dialogue will update and provide different filtering options like Leverage, Data Type and Periods.
Once the list and filters are selected, apply any fields (or Custom View through the 'View' menu) and click Insert to pull the list into your Excel sheet.
ETF List Removal
ETF Lists inserted into a worksheet can be quickly removed by highlighting the ETF List anchor cell, Clicking on the ETFs icon and selecting the Clear button.