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:
Back to Wizard Help