https://community.qlik.com/t5/QlikView/How-to-export-all-rows-data-into-one-sheet/m-p/822780#M1027234 <HTML><HEAD></HEAD><BODY><P>Thanks.</P></BODY></HTML> Wed, 04 Mar 2015 11:04:54 GMT 2015-03-04T11:04:54Z https://community.qlik.com/t5/QlikView/How-to-export-all-rows-data-into-one-sheet/m-p/822776#M1027230 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P> I have table box with rows 290345. when I send export data to excel it is showing only 65536 rows in one sheet and next 65536 in second sheet and so on. Is there any way I can get all data in one sheet. Please can anyone suggest me.</P><P></P><P>Thanks.</P></BODY></HTML> Tue, 03 Mar 2015 16:22:54 GMT https://community.qlik.com/t5/QlikView/How-to-export-all-rows-data-into-one-sheet/m-p/822776#M1027230 2015-03-03T16:22:54Z https://community.qlik.com/t5/QlikView/How-to-export-all-rows-data-into-one-sheet/m-p/822777#M1027231 <HTML><HEAD></HEAD><BODY><P>I have tried to export into csv. it is showing all rows in to one sheet. but the data which as below</P><P></P><P>534783031246360</P><P></P><P>is showing as</P><P></P><P>5.34783E+15</P><P></P><P>how to set this. can anyone suggest me please.</P></BODY></HTML> Tue, 03 Mar 2015 16:55:41 GMT https://community.qlik.com/t5/QlikView/How-to-export-all-rows-data-into-one-sheet/m-p/822777#M1027231 2015-03-03T16:55:41Z https://community.qlik.com/t5/QlikView/How-to-export-all-rows-data-into-one-sheet/m-p/822778#M1027232 <HTML><HEAD></HEAD><BODY><P>Open the csv with something other than excel, e.g notepad or just format the column as NUMBER in excel</P></BODY></HTML> Tue, 03 Mar 2015 17:02:04 GMT https://community.qlik.com/t5/QlikView/How-to-export-all-rows-data-into-one-sheet/m-p/822778#M1027232 awhitfield 2015-03-03T17:02:04Z https://community.qlik.com/t5/QlikView/How-to-export-all-rows-data-into-one-sheet/m-p/822779#M1027233 <HTML><HEAD></HEAD><BODY><P>When you export to Excel, the 15 digit+ number is converted to text to show you all the digits. </P><P></P><P>But when opening from CSV, excel reads it as a number, except that excel can only keep track of 15 digit precision nubmers. </P><P></P><P><A href="https://answers.yahoo.com/question/index?qid=20110401110354AAu4ddO" title="https://answers.yahoo.com/question/index?qid=20110401110354AAu4ddO">Excel Question! I don't want to use "E" or scientific notation?</A></P><P></P><P><A href="https://support.office.com/en-us/article/Excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3?CorrelationId=eea96717-f491-4053-98cd-988d6a815d34&amp;ui=en-US&amp;rs=en-US&amp;ad=US" title="https://support.office.com/en-us/article/Excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3?CorrelationId=eea96717-f491-4053-98cd-988d6a815d34&amp;ui=en-US&amp;rs=en-US&amp;ad=US">Excel specifications and limits</A></P><P><A href="https://support.office.com/en-US/article/Excel-specifications-and-limits-CA36E2DC-1F09-4620-B726-67C00B05040F" title="https://support.office.com/en-US/article/Excel-specifications-and-limits-CA36E2DC-1F09-4620-B726-67C00B05040F">Excel specifications and limits</A></P><P></P><P>... so you convert to a txt and load through the wizard into excel etc... but for excel to keep&nbsp; a number this big it needs to be preserved in 'txt' format&nbsp; (in the cell format options)</P></BODY></HTML> Tue, 03 Mar 2015 17:21:27 GMT https://community.qlik.com/t5/QlikView/How-to-export-all-rows-data-into-one-sheet/m-p/822779#M1027233 JonnyPoole 2015-03-03T17:21:27Z https://community.qlik.com/t5/QlikView/How-to-export-all-rows-data-into-one-sheet/m-p/822780#M1027234 <HTML><HEAD></HEAD><BODY><P>Thanks.</P></BODY></HTML> Wed, 04 Mar 2015 11:04:54 GMT https://community.qlik.com/t5/QlikView/How-to-export-all-rows-data-into-one-sheet/m-p/822780#M1027234 2015-03-04T11:04:54Z