topic Re: Export to excel changes the date to text format in QlikView

Export to excel changes the date to text format

vivek_niti — Mon, 26 Jan 2026 18:19:17 GMT

Hi,

Having an issue with send to excel option.

The date column in report is in the format (DD-MM-YYYY), but when the data is being exported to excel the all the dates get converted to text. This is not limited to any one report or application, it is happening to all the applications and has started happening from yesterday and no settings has been changed on the server.

Even when exporting the date values of a list box the data is getting converted to text format.

Woking on QV11 SR2.

Early response is appreciated!

Regards,

Re: Export to excel changes the date to text format

francoiscave — Wed, 24 Dec 2014 09:59:07 GMT

Hi Vivek,

Find some help with the link below:

http://community.qlik.com/message/346454#346454

Have fun with QV,

François

Re: Export to excel changes the date to text format

SunilChauhan — Wed, 24 Dec 2014 10:01:04 GMT

chart properties-> caption->Copy Data

then at right corner of chart click on copy to clipboard and then paste to excel

hope this helps

Re: Export to excel changes the date to text format

vivek_niti — Wed, 24 Dec 2014 10:52:40 GMT

thanks for the reply but this wont work as the data is being exported from access point and the size of the data is over 10 Lac.

Re: Export to excel changes the date to text format

amit_saini — Wed, 24 Dec 2014 10:56:54 GMT

Hi,

Check this:

http://community.qlik.com/message/333595#333595

Thanks,
AS

Re: Export to excel changes the date to text format

amit_saini — Wed, 24 Dec 2014 10:58:02 GMT

Also.

http://community.qlik.com/message/261296#261296

Thanks,
AS

Re: Export to excel changes the date to text format

francoiscave — Wed, 24 Dec 2014 12:31:16 GMT

Hi Vivek,

Please close this thread by making appropriate answer if you are satisfied...

François

Re: Export to excel changes the date to text format

alkesh_sharma — Sat, 27 Dec 2014 06:22:20 GMT

HI Vivek,

This is a bug, tested and confirmed. upgrade to SR8 and this would be resolved.

Regards,

Alkesh

Re: Export to excel changes the date to text format

Anonymous — Wed, 22 Jun 2016 16:11:38 GMT

We have QlikView version 11.2 SR10 but still Date does not export as date. It is getting exported either as a text or number. Any solutions?

Re: Export to excel changes the date to text format

alkesh_sharma — Thu, 23 Jun 2016 01:08:15 GMT

Go to document properties - Numbers.

You will find all the dimentiones listed on the left.

Select your required dimention from the left. And give it the desired

format from the right.

This should solve your problem.

Thanks,

Alkesh Sharma

#+91 99 58 458381

sent from mobile device.

Re: Export to excel changes the date to text format

amit_saini — Thu, 23 Jun 2016 06:03:09 GMT

Hi,

Try below:

go to properties of table -> Number->Select the particular field which comes in text->select date and give required format.

=date#(<date filed>,'DD/MM/YYYY')

=date(date#(<date filed>,'DD/MM/YYYY'),<Formt code>)

copy Full Table option and paste it excel

Thanks,

Re: Export to excel changes the date to text format

Anonymous — Thu, 23 Jun 2016 14:50:50 GMT

Awesome! This Works. Sometimes I struggle to find the options!

Re: Export to excel changes the date to text format

FakeJupiter — Thu, 15 Apr 2021 06:27:00 GMT

This is a really good answer, been using qlikview for some time know, didn't even think of looking in document properties for fixing that.