Bookmark and Share

Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: import .xls data into STATA

From   Wu Zhang <[email protected]>
To   "[email protected]" <[email protected]>
Subject   Re: st: import .xls data into STATA
Date   Sat, 24 Sep 2011 15:39:53 -0700 (PDT)

Thank you all!
----- Original Message -----
From: Roger Newson <[email protected]>
To: [email protected]
Sent: Friday, September 23, 2011 10:15 AM
Subject: Re: st: import .xls data into STATA

No, you CANNOT download Stat/Transfer for free, unless you want a trial 
version, which deliberately throws out a few observations in each 
transfer. Stat/Transfer (like Stata) is proprietary software, and the 
company (Circle Systems) has to make a living. So, to use a proper 
Stat/Transfer, which does not throw out observations at random, you have 
to buy it from its authorized distributors.

To read .xls datasets into Stata wirthout Stat/Transfer, either write 
the Excel spreadsheet to a generic format (as suggested), or (if you 
have Stata Version 12) use -import excel-.

Best wishes


Roger B Newson BSc MSc DPhil
Lecturer in Medical Statistics
Respiratory Epidemiology and Public Health Group
National Heart and Lung Institute
Imperial College London
Royal Brompton Campus
Room 33, Emmanuel Kaye Building
1B Manresa Road
London SW3 6LR
Tel: +44 (0)20 7352 8121 ext 3381
Fax: +44 (0)20 7351 8322
Email: [email protected]
Web page:
Departmental Web page:

Opinions expressed are those of the author, not of the institution.

On 23/09/2011 15:08, donsaane wrote:
> I think you can do it with stat transfer (you can download it for free)....
> -----Message d'origine-----
> De : [email protected]
> [mailto:[email protected]] De la part de Muhammad Anees
> Envoyé : vendredi 23 septembre 2011 03:02
> À : [email protected]
> Objet : Re: st: import .xls data into STATA
> Save the xls data with .csv extension from file/save as option. Check
> that your names are in row 1 of the sheet and conform the stata naming
> convention. Then use -insheet using "address of the file on your pc"-
> On Fri, Sep 23, 2011 at 10:42 AM, Wu Zhang<[email protected]>  wrote:
>> Hi, folks,
>>    Could someone help me with importing .xls data into STATA? I tried, but
> failed.
>> Thanks,
>> Wu
>> *
>> *  For searches and help try:
>> *
>> *
>> *
*  For searches and help try:

*   For searches and help try:

© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index