# Importing and exporting data

Importing and exporting spreadsheets, binary files, plain-text files, and databases

Converting a text column to a numeric column
Changing a column’s underlying storage format can enable new kinds of analysis

List of supported date formats
Wizard can import dates stored as text in spreadsheets and plain-text files

Importing from a database server
Choose File > Import From MySQL or PostgreSQL Server… to connect to a database

Editing the link between a table and a data source
Specify how columns and rows in a data source will map to the columns and rows of an existing table

Exporting a data table as a binary file for SPSS, Stata, or SAS
Wizard Pro can export data tables in formats suitable for other statistics programs

Exporting a data table as CSV, Excel, RData, SQLite, or JSON
Wizard can export data tables in formats suitable for Excel, R, or the web

Exporting a data table as SQL commands
Wizard can export data tables as SQL commands, suitable for loading into a MySQL or PostgreSQL database

List of supported file formats
Wizard can import and export spreadsheets, binary data sets, and plain-text files

Importing delimiter-separated files
Plain-text files do not indicate their data types, so import them with care

Refreshing a table’s data from a linked data source
Use the Refresh Data button in the toolbar to pull in the latest data from a linked data source

Removing the link between a table and a data source
Use the Table menu to unlink a table from its data source

Back to Wizard Help