Export EpiData to Excel - is there a solution/an alternative?
Dear member of the team, dear all,
I am having the following problem and would be very grateful if there was a solution (or alternative) to it:
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?
Thank you very much in advance! Greetings, Nina-Claire Himpe
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?
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@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@lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list
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@lists.umanitoba.ca [mailto:epidata-list-bounces@lists.umanitoba.ca] On Behalf Of epidata-list@lists.umanitoba.ca Sent: Thursday, August 11, 2011 11:16 AM To: epidata-list@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@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@lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list
_______________________________________________ EpiData-list mailing list EpiData-list@lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list
Not convinced of what?
--Chris
Christopher W. Ryan, MD SUNY Upstate Medical University Clinical Campus at Binghamton 425 Robinson Street, Binghamton, NY 13904 cryanatbinghamtondotedu
"Observation is a more powerful force than you could possibly reckon. The invisible, the overlooked, and the unobserved are the most in danger of reaching the end of the spectrum. They lose the last of their light. From there, anything can happen . . ." [God, in "Joan of Arcadia," episode entitled, "The Uncertainty Principle."]
epidata-list@lists.umanitoba.ca wrote:
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@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@lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list
EpiData-list mailing list EpiData-list@lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list
I suppose the starting point really is to answer the question, "What do I want to do with the data in Excel?"
? look at it in a spreadsheet view? - EpiData Analysis can do this (Browse) ? do some simple calculations on some fields? - EpiData Analysis can do this ? do some really complicated calculations on some fields? - just export some key identifying fields and the fields you need into Excel and merge the results back into your EpiData file ? do some special analysis that is only available in Excel? - same idea, but I can't think of any that would use very many fields ? create a database that will support mail-merge ? - you won't need many fields for this
If your boss has a fixation on an old version of Excel, then you are limited to exporting 256 fields (columns). Excel 2010 or newer can handle over 16,000 columns
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?
Hey everybody,
thank your so much for your efforts and the enormous help! I need some time to consider your proposals and the next steps now :-)
My boss has done a lot of work with Excel and she is just worried 1. that we have to adapt to a new system and 2. that we can't combine the data from the Open Office sheets with already existing Excel sheets.
Thanks again and greetings, Nina
Am 11.08.2011 17:45, schrieb epidata-list@lists.umanitoba.ca:
I suppose the starting point really is to answer the question, "What do I want to do with the data in Excel?"
? look at it in a spreadsheet view? - EpiData Analysis can do this (Browse) ? do some simple calculations on some fields? - EpiData Analysis can do this ? do some really complicated calculations on some fields? - just export some key identifying fields and the fields you need into Excel and merge the results back into your EpiData file ? do some special analysis that is only available in Excel? - same idea, but I can't think of any that would use very many fields ? create a database that will support mail-merge ? - you won't need many fields for this
If your boss has a fixation on an old version of Excel, then you are limited to exporting 256 fields (columns). Excel 2010 or newer can handle over 16,000 columns
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?
EpiData-list mailing list EpiData-list@lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list
participants (1)
-
epidata-list＠lists.umanitoba.ca