Skip to main content
Version: 0.20.7

Files

File Types​

DataChat supports the following file types:

  • Comma-separated values (.csv)
  • Tab-separated values (.tsv)
  • Excel (.xlsx)
  • JavaScript Object Notation (.json)
  • ZIP archives (.zip)
  • TAR archives (.tar)
note

Datasets can contain at most 1600 columns.

Upload Files​

Uploading a file into DataChat is the easiest way to get started and is a better option when working with small, static, or one-off datasets.

Load Button​

To upload files from within a DataChat session:

  1. Select Load > Load Data in the sidebar. The Load Data form appears.

    Load Data form, Files

  2. Once you've started using DataChat, the Files section populates with your commonly used files. Click on any file to load the file into the session. If your file isn't listed, click load data from my files. The Load a File dialog appears.

    Load a File form, Files

  3. Click the Upload a new file button. Your machine's file browser opens. Select the file you want to upload – it will show as being uploaded in the Drag and Drop page of Settings > File Manager. The file is now uploaded into your DataChat app.

  4. For all files except .zip and .tar.gz archives, DataChat prompts you to load the file into the current session.

    File Manager Upload within a session

    For archive files, exit Settings to return to the Load a File form, select the file you downloaded from the dropdown, and click Submit.

My Files​

To upload your files into DataChat from inside or outside a session:

  1. Click your user icon and click My Files. The File Manager, in Settings > Files appears.

    File Manager Existing Files

  2. Click the Upload button. The Drag and Drop page of the File Manager appears.

    File Manager Upload

  3. Either drag and drop your file or click Browse to open your file manager and select the file to upload into DataChat.

  4. For all files except .zip and .tar.gz archives, DataChat prompts you to load the file into the current session. For archive files, exit Settings to return to the Load a File form, select the file you downloaded from the dropdown, and click Submit.

Load Data from Files​

If you've already uploaded your files into DataChat, click Load in the sidebar. If your file is recently accessed, it appears as a card in the Load Data form. If your file isn't listed, click load data from my files to open the Load a File form. Select your file from the dropdown.

Load Data form

You can also enter the following DataChat sentence in the chat box: Load data from the file <file name>.

note

For .xslx files that include sheets, you can limit imported data by excluding sheets or specifying cell ranges. See Load for details.

Load Data From a URL​

note

Loading data from a URL also uploads those files to DataChat, so you can easily load them again in other sessions.

To load data from a URL:

  1. Click the Load button.
  2. Enter the URL to load.
  3. Click Submit.

the URL form

For example, to upload the "Titanic" dataset from https://github.com/awesomedata/awesome-public-datasets/blob/HEAD/Datasets/titanic.csv.zip, you can enter https://github.com/awesomedata/awesome-public-datasets/blob/HEAD/Datasets/titanic.csv.zip in the Enter a URL field.

You can also enter the following DataChat sentence in the chat box: Load data from the URL <url>

Load Data From Google Drive​

note

Loading data from Google Drive also uploads those files to DataChat, so you can easily load them again in other sessions.

You can allow DataChat to load data from your Google Drive by authenticating it with Google and then loading data from the Google Drive URL.

In the chat box:

  1. Enter Authenticate with Google Drive. This opens a new browser tab.
  2. Select the Google account to use.
  3. Click Allow to let DataChat access your Google Drive files. You're then redirected back to your session in DataChat.
  4. Enter in the chat box: Load data from the URL <URL>, where <URL> is the URL of your file in Google Drive. Note that you must the use the URL you receive after clicking the Share button in Google Drive, but you do not need to share the file with any other accounts.

You can also enter the following DataChat sentence in the chat box: Load data from the database <connection name> where <connection name> is the name you specified in step 4.

Give us feedback