# List of supported file formats

## Binary import formats

Wizard can import spreadsheets, workspaces, and database files in the following data formats:

- Microsoft Excel spreadsheets with extension `.xls` or `.xlsx`
- Apple Numbers documents (Numbers ’09 and later) with extension `.numbers`
- R workspace files with extension `.rdata`
- R single object files with extension `.rds`
- DBF database files with extension `.dbf`
- SQLite database files with extension `.sqlite`
- Microsoft Access database files with extension `.mdb`, `.accdb`, or `.accdc`

Wizard Pro can additionally import from:

- Stata binary files with extension `.dta`
- SPSS binary files with extension `.sav` or `.zsav`
- SPSS portable files with extension `.por`
- SAS binary files with extensions `.sas7bdat` and `.sas7bcat`
- SAS transport files with extension `.xpt` or `.ssp`

## Plain-text import format

Wizard can import files in the following plain-text formats:

- Comma-separated values (CSV) with extension `.csv`
- Tab-delimited files with extension `.tab` or `.txt`
- Text files with a custom field delimiter
- JavaScript Object Notation (JSON) with extension `.json`

Wizard Pro can also import plain-text files whose variables are described by the following kinds of files:

- Stata dictionary files with extension `.dct`
- SPSS command files with extension `.sps`
- SAS command files with extension `.sas`

## Export formats

Wizard can export data in the following formats:

- Comma-separated values (CSV)
- JavaScript Object Notation (JSON)
- Microsoft Excel spreadsheet files with extension `.xlsx`
- R workspace files with extension `.rdata`
- SQLite database files with extension `.sqlite`
- SQL command files with extension `.sql`

Wizard Pro can additionally export data in the following formats:

- Stata binary files with extension `.dta`
- SPSS binary files with extension `.sav`
- SAS transport files with extension `.xpt`

See also:

- Importing delimiter-separated files
- Importing from a database server
- Refreshing a table’s data from a linked data source
- Converting a text column to a numeric column
- List of supported date formats
- Exporting a data table as CSV, Excel, RData, SQLite, or JSON
- Exporting a data table as SQL commands
- Exporting a data table as a binary file for SPSS, Stata, or SAS
- Copying column data to the clipboard

Back to Wizard Help