Create and load CSV Files

The simplest way to load data is to upload a CSV or Excel file from the ThoughtSpot Web interface.

Loading data through the Web browser is recommended for smaller tables (under 50MB) with simple relationships between them. This method is recommended for small, one time data loads. Using this method, the data schema is created for you automatically.

Any user who belongs to a group that has the privilege Has administration privileges or Can upload user data can upload their own data from the browser. To load the CSV or Excel file into ThoughtSpot:

  1. Log in to ThoughtSpot from a browser.

  2. Click Data, on the top navigation bar.

  3. Click the More icon more options menu icon in the upper right corner, and select Upload Data.

    new imported data
  4. Upload the CSV or Excel file by doing one of these options:

    1. Click Browse your files and select the file.

    2. Drag and drop the file into the drop area.

  5. Answer the question Are the column names already defined in the file header?

  6. Answer the question Are the fields separated by? Click Next.

  7. Click the column header names to change them to more useful names, if you’d like. Click Next.

  8. Review the automatically generated data types for each column, and make any changes you want.

    There are four data types: Text, Integer, Decimal, and Date.

  9. Click Import.

    When an upload is complete, the system reports the results and offers you some further actions.

    spotiq upload
    • Click Link to Existing Data if you want to link the data you uploaded to the data in another table or worksheet.

    • Click Search if you want to begin a new search.

    • Click Auto analyze if you want to use the SpotIQ feature to find insights in your new data.

Was this page helpful?