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