[EpiData-list] Problem with export to Excel

epidata-list at lists.umanitoba.ca epidata-list at lists.umanitoba.ca
Fri Nov 29 12:37:18 CST 2013

Dear Sabine, please also note language: you are from Basel, and I can 
see that you use a German version of Excel, thus presumably your Windows 
is also German. Both have their own ways of interpreting CSV files and 
you have to be explicit in telling step by step what you tell Excel... 
As Torsten and Jamie say, this is not an EpiData issue, it is an Excel 


On 29-Nov-13 13:56, epidata-list at lists.umanitoba.ca wrote:
> Does the file name end in .csv? Excel should recognize that. In any case, there is a simple way to convert your single column data to table form.
> Select all the data in the first column
> On the menu bar: Data, Text to Columns
> Choose delimited
> Make sure comma is the delimiter
> That’s it - and you get to see what is happening as you go along.
> Jamie

Hans L Rieder, MD, MPH
Jetzikofenstr 12
3038 Kirchlindach

Tel: +41 31 829 4577
Mob: +41 79 321 9122
Web: http://www.tbrieder.org

More information about the EpiData-list mailing list