Permissible data format for import

Mathematica allows the importing of hundreds of data formats, but we only need some of them: those that are amenable to mathematical processing and analysis.

The main data formats can be divided into the following groups:

• Tabular Text Formats: This includes general text format data (*.dat), comma-separated (*.csv), or tab-separated (*.tsv)

• Spreadsheet Formats: This includes office programs data working with documents, such as Excel (*.xls and *.xlsx), Open Office (*.odc, and *.sxc), and even the first spreadsheet VisiCalc data (*.di f)

• Data Interchange Formats: This includes the JSON format

• Database Formats: This includes MS Access (*.mdb) and dBase (*.dbf)

• Compression and Archive Formats: This includes the files created by archivers, such as Windows ZIP (*.zip), Unix GZIP (*.gz), Unix TAR (*.tar), and BZIP2 (*.bz2)

• XML/HTML Formats: This includes extensions such as .xml, .xhtml, .html, and .rss

Note

Here, you may find the complete list of all the data formats...