Different File Formats and Their Programmes: SPSS SAS Excel STATA R Access Notepad Notes .sav This is It can It can Extra It can be It can be It .sps is SPSS an SPSS be be opened but opened but cannot commands file opened opened required extra cumber-some be .por is SPSS format using using (available for is opened portable SAS Excel free) required in (rarely used) (available for Notepad free) .sas It can This is It can be It can be It can be It be an SAS opened if opened if data opened but cannot opened file data saved in saved in extremely be but format SAS-export format cumbersome opened labels format (.xpt) (.xpt) in go Notepad missing .xls/.xlsx It can It can This is First save as .csv It can be It be be an .csv recommended opened cannot opened opened Excel over .xls be file opened format in Notepad .csv It can It can This is It can be It can be It can be It be be an opened opened opened cannot opened opened Excel be variables file opened format in Notepad .dta It can It can It can This is a It can be It cannot be It .do is STATA be be be STATA file opened opened in cannot commands opened opened opened format Access be opened in Notepad It It can First It cannot be This is an R file It cannot be It .rdata cannot be save it opened in format opened in cannot be opened as .csv Stata Access be opened opened in SPSS in Notepad .acc First First It can It can be It can be This is an MS It .mbd is old save as save as be opened - bit opened - bit Access file cannot Access .xls .xls opened awkward, awkward, first format be extension first save as save as .csv opened .csv in Notepad
Different File Formats and Their Programmes: SPSS SAS Excel STATA R Access Notepad Notes .sav This is an SPSS file format It can be opened using SAS It can be opened using Excel Extra required (available for free) It can be opened but extra is required (available for free) It can be opened but cumber-some It cannot be opened in Notepad .sps is SPSS commands .por is SPSS portable (rarely used) .sas It can be opened but labels go missing This is an SAS file format It can be opened if data saved in SAS-export format (.xpt) It can be opened if data saved in format (.xpt) It can be opened but extremely cumbersome It cannot be opened in Notepad .xls/.xlsx It can be opened It can be opened This is an Excel file format First save as .csv .csv recommended over .xls It can be opened It cannot be opened in Notepad .csv It can be opened It can be opened This is an Excel file format It can be opened It can be opened It can be opened It cannot be opened in Notepad variables .dta It can be opened It can be opened It can be opened This is a STATA file format It can be opened It cannot be opened in Access It cannot be opened in Notepad .do is STATA commands .rdata It cannot be opened in SPSS It can be opened First save it as .csv It cannot be opened in Stata This is an R file format It cannot be opened in Access It cannot be opened in Notepad .acc First save as .xls First save as .xls It can be opened It can be opened - bit awkward, first save as .csv It can be opened - bit awkward, first save as .csv This is an MS Access file format It cannot be opened in Notepad .mbd is old Access extension
Different%20File%20Formats%20and%20Their%20Programmes.docx