Skip to main content

Upload a CSV File

You can upload a CSV or TSV file that contains a header row with the column names, and ClickHouse will preprocess a batch of rows to infer the data types of the columns, then insert the rows into a new table.

  1. Start by going to the Details page of your ClickHouse Cloud service:

Details page

  1. Select Load data from the Actions dropdown menu:

File upload

  1. Click the File upload button in the Load data dialog window that appears. Enter your database user credentials, drag-and-drop (or click the + to browse for) your file into the File upload section, then click the Upload file button:

Select the file to upload

  1. ClickHouse shows you the data types that it inferred. Enter a new table name to insert the data into, then click the Create table button.

Select the file to upload

  1. Connect to your ClickHouse service, verify the table was created successfully, and your data is ready to go! If you want to visualize your data, check out some of the BI tools that can easily connect to ClickHouse.