Supported file formats

Before uploading a table using the 1010data user interface, data from your current system must be exported into a file format that 1010data can read.

The supported file formats vary based on whether you perform a Simple Upload or an Advanced Upload in the 1010data user interface.
Note: Delimited files must contain only printable ASCII characters; UTF-8 strings with multi-byte characters are not allowed.
Compatible file formats include the following:
.csv A comma-separated values file.
.txt A standard comma-, tab-, pipe-, or space-separated text file.

For details about what the text file may contain, see Text file format.

.xml An XML file specifying the table and column attributes using defined XML elements.

For details about what the XML file may contain, see XML file format.

Note: The XML file format is only supported when performing a Simple Upload.
.zip, .7z, .rar, .gz A compressed file containing either a .txt or .csv file.
Note: Compressed file formats are only supported when using the FTP option while performing an Advanced Upload.
Note: Microsoft Excel spreadsheet file formats (e.g., .xls and .xlsx) are not supported for upload in the 1010data user interface. To upload an Excel spreadsheet file, save the file as a comma-, tab-, pipe, or space-separated text file or use the 1010data Excel Add-in to upload the file directly from Excel.