Create a connection to a CSV or TXT file

Follow these steps to create a connection to a CSV or TXT file:

  1. Open the Visualization page in the console.

  2. Select your workbook or click Create workbook to make a new one.

  3. In the upper-right corner of your workbook page, click CreateConnection.

  4. Select File.

  5. Configure the connection parameters:

    1. In the left panel, click Upload files to add CSV or TXT files that will later make up a dataset.

      upload-csv

      Connector limitations

      • You can upload no more than 10 files per connection
      • The size of each file shouldn't exceed 200 MB.
    2. Take a look at the preview section. It contains the header row and data rows. The service automatically defines column data types and displays them in the header row.

      In most cases, the service detects these parameters automatically. However, you can specify them manually for each file uploaded:

      • The file's character Encoding.

      • The Separator character.

      • Toggle Yes or No if your table ha or lacks a Columns header.

  6. Click Create connection in the upper-right corner of the page.

  7. Name your connection and click Create.

See also