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   Roger Newson <[email protected]>
To   [email protected]
Subject   Re: st: import .xls data into STATA
Date   Fri, 23 Sep 2011 15:15:13 +0100

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



*   For searches and help try:

*   For searches and help try:

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