You can also export excel data to dbf file (you save the excel sheet as a dbf format). Then you can import directly the dbf file into Epidata using the command "Data\Import" of Epidata. Hopes it can help.

Ndrina

----- Mail original ----- De: epidata-list@lists.umanitoba.ca À: epidata-list@lists.umanitoba.ca Envoyé: Samedi 22 Octobre 2011 14:12:10 Objet: Re: [EpiData-list] importing data to epidata from excel sheet

Format the excel data with valid EpiData variable names in the first row. Select and copy the range of cells In EpiDataStat, the command is

read /cb

Jamie

On 2011-10-22, at 5:47 AM, epidata-list@lists.umanitoba.ca wrote:

Would you please remind me of how to import data from excel sheet into epidata.

_______________________________________________ EpiData-list mailing list EpiData-list@lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list

Another hint for copy paste from spreadsheet as indicated by Hans and Jamie is that sometimes one has a spreadsheet like this (simplified):

visit exposed sex problems surgery 01-01-1990 1 1 1 10-01-2000 01-11-1991 0 1 1 10-01-2000 01-11-1992 0 1 0 01-12-1993 1 1 1 10-01-2000

to read this with copy paste you just add one column on the right to get a "full" square

visit exposed sex problems surgery x 01-01-1990 1 1 1 10-01-2000 x 01-11-1991 0 1 1 10-01-2000 x 01-11-1992 0 1 0 x 01-12-1993 1 1 1 10-01-2000 x

after reading into analysis with "read /cb" you just drop the variable x

Jens Lauritsen EpiData Association