Create a connection to a CSV or TXT file
Follow these steps to create a connection to a CSV
or TXT
file:
-
Open the Visualization
-
Select your workbook or click Create workbook to make a new one.
-
In the upper-right corner of your workbook page, click Create → Connection.
-
Select File.
-
Configure the connection parameters:
-
In the left panel, click Upload files to add
CSV
orTXT
files that will later make up a dataset.Connector limitations
- You can upload no more than 10 files per connection
- The size of each file shouldn't exceed 200 MB.
-
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
orNo
if your table ha or lacks a Columns header.
-
-
-
Click Create connection in the upper-right corner of the page.
-
Name your connection and click Create.