article Exporting lists from QMC to Excel in Qlik Sense Documents

Exporting lists from QMC to Excel

shaun_lombard — Tue, 26 Jul 2016 00:39:42 GMT

I stumbled upon this feature while trying desperately to simply get a list of items displayed in the QMC exported into an Excel spreadsheet. If there are other simpler methods, please let me know.

The tip requires OneNote and Excel and Internet Explorer (Other browsers not tested)

If you have any questions let me know.

Shaun

Re: Exporting lists from QMC to Excel

william_fu — Fri, 06 Apr 2018 20:13:18 GMT

You're a legend!

Re: Exporting lists from QMC to Excel

NZFei — Sun, 08 Apr 2018 20:50:12 GMT

Don't know why can reply to Shaun directly hence do it here.

This doesn't work for me?

And if I use print, it print the screenshot as an image to OneNote...

Any idea?

Thanks

Fei

Re: Exporting lists from QMC to Excel

shaun_lombard — Tue, 10 Apr 2018 04:54:01 GMT

I am using IE 11 and OneNote 2016, are you using the same versions?

Re: Exporting lists from QMC to Excel

NZFei — Tue, 10 Apr 2018 20:20:09 GMT

Yes, I am using IE 11.64.16299.0 and OneNote 2016.

Re: Exporting lists from QMC to Excel

shaun_lombard — Tue, 10 Apr 2018 22:45:39 GMT

I have seen a recommendation to change the value of the following registry key from 1 to 0

HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\User Settings\OneNoteToIEAddin

Change "Count" from 1 to 0 and then restart the machine.

Mine is currently set to 1 and is working fine.

Re: Exporting lists from QMC to Excel

NZFei — Tue, 10 Apr 2018 22:57:40 GMT

Thank you for your effort Shaun.

I have made this change and restarted my PC but still have the same error.

Cheers.

Fei

Re: Exporting lists from QMC to Excel

jeremy_fourman — Thu, 13 Sep 2018 14:17:19 GMT

Thank you, this worked well for me today.

Re: Exporting lists from QMC to Excel

nilekp2019 — Wed, 19 Feb 2020 06:30:34 GMT

Hi everyone, It's easy to use you can do it via monitoring app as provided by Qlik.

Re: Exporting lists from QMC to Excel

nilekp2019 — Wed, 19 Feb 2020 06:31:46 GMT

In monitoring app relevant fields and then export it as excel.

Re: Exporting lists from QMC to Excel

Shisho_Karsenty — Mon, 09 Aug 2021 21:19:42 GMT

Another "quick and dirty" way is to "print"(right-click -->"print") your QMC list and save it as a PDF.
Then you can copy-paste text from PDF to excel.
As I mentioned dirty but quick (:

Re: Exporting lists from QMC to Excel

shaun_lombard — Thu, 02 Jun 2022 00:54:20 GMT

I should provide an update and say that this is sooooo much easier now in Edge browser.

Just use CTRL + SHIFT + X then copy and paste to excel.

Re: Exporting lists from QMC to Excel

saso70 — Mon, 06 Jun 2022 07:35:55 GMT

Another simple way is to install google chrome extension https://chrome.google.com/webstore/detail/export-qlik-sense-qmc-tab/dbnjjihpapafmihpnionckfipbmalhko?hl=en-GB

Re: Exporting lists from QMC to Excel

tnorville — Thu, 09 Jan 2025 18:34:24 GMT

Yet another way is to open Dev tools on the browser. Select the element with the table/grid - select copy Outer HTML. Paste into Excel. It handles HTML tables quite well.