[EpiData-list] Export EpiData to Excel - is there a solution/analternative?

epidata-list at lists.umanitoba.ca epidata-list at lists.umanitoba.ca
Thu Aug 11 10:44:14 CDT 2011


The limit of 256 columns is in Excel 2003 xls files, not EpiData.  If
you have a more recent version of Excel, you can export from EpiData to
a text file, then import that text file into an Excel xlsx file (which
allows for more than 256 columns).

-----Original Message-----
From: epidata-list-bounces at lists.umanitoba.ca
[mailto:epidata-list-bounces at lists.umanitoba.ca] On Behalf Of
epidata-list at lists.umanitoba.ca
Sent: Thursday, August 11, 2011 11:16 AM
To: epidata-list at lists.umanitoba.ca
Subject: Re: [EpiData-list] Export EpiData to Excel - is there a
solution/analternative?

Hey Jamie,

thank you very much! I tried to suggest that to my boss but she is not 
convinced yet. Are there any other possibilities available?

Thanks and greetings,
Nina

Am 11.08.2011 16:49, schrieb epidata-list at lists.umanitoba.ca:
> Go ahead and export the data. EpiData will make a spreadsheet with
more than 256 columns. I just exported one with 501 columns. You can
open it in OpenOffice (www.openoffice.org). OpenOffice allows 1024
columns.
>
> Jamie
>
> On 2011-08-11, Nina-Claire wrote:
>
>> The data I want to export to Excel consists of approximately 960
lines in Epidata formats (= 960 colums in .xls). As I understand EpiData
(and as the test with the used data showed) it is impossible to export
more than 256 lines to Excel (version 2003) because of the Excel 2003
column limit . Is there any way to export the 960 lines to Excel? Or is
there another alternative I should consider?
>
> _______________________________________________
> EpiData-list mailing list
> EpiData-list at lists.umanitoba.ca
> http://lists.umanitoba.ca/mailman/listinfo/epidata-list
_______________________________________________
EpiData-list mailing list
EpiData-list at lists.umanitoba.ca
http://lists.umanitoba.ca/mailman/listinfo/epidata-list


More information about the EpiData-list mailing list