Skip to Main Content
George Mason University | University Libraries
See Updates and FAQs for the latest library services updates. Subject Librarians are available for online appointments, and Virtual Reference has extended hours.

Working with Data

What you need to know for Data Management and Data Wrangling

File Formats

File Formats

Common File Types

What kind of file(s) do I have? Look at the file extension. Starting from the top, find the first row that is for any of your files. 

If you have one of these... File Type What to do
.zip, .tar, .gz, .rar Zip File Unzip it, see the tab for instructions
.sav, .por, dta, .xpt, .stc, .sas7bdat Software-specific See the box "Converting Data"
.sps, .do, .dct, .sas, .R Syntax files, used to import See the tab "Setup Files"
.xls, .xlsx, .ods, .mdb, .dbf Spreadsheet or Database Most software can Import these
.csv, .tsv, .tab Delimited Text (ex. ASCII) Most software can Import these
.txt, .dat Other Text (ex. ASCII) Look at the documentation
.xml, .json, .html Structured Text or Markup Look at the documentation

Zip Files

Files are compressed, or zipped, to save storage space and/or to bundle several files together.

  Windows Mac
Do Right click and choose Extract All Double-click the file
Watch Win Video ~1 min  Mac Video ~1 min
Read Win Support Mac Support

Even though you can see what is in the .zip file, you must unzip the file before you can open the individual files in the archive

If the extension is ".tar.gz". You will likely need to use  7-zip or  another program to unzip it. Just unzip it twice (once to get rid of the .gz, and the second time to get rid of the .tar). 

Setup Files

In some cases, you will need to download data in ASCII (text) format and use a setup file (typically .sps, .do or .sas) to get it into your software. 

Many statistical packages will not run a set-up file unless you reset the Windows default setting that hides file extensions.

Comma Separated Values (CSV) is a useful file format for spreadsheets. It can be opened easily in programs like Excel.