Creating a Dataset Using a Local Text File - Amazon QuickSight

Creating a Dataset Using a Local Text File

To create a dataset using a local text file data source, identify the location of the file, and then upload it. The file data is automatically imported into SPICE as part of creating a dataset.

Use the following procedure to create a dataset based on a local text file.

  1. Check Data Source Limits to make sure that your target file doesn't exceed data source limits.

    Supported file types include .csv, .tsv, .json, .clf, or .elf files.

  2. On the Amazon QuickSight start page, choose Manage data.

  3. On the Your Data Sets page, choose New data set.

  4. In the FROM NEW DATA SOURCES section of the Create a Data Set page, choose Upload a file.

  5. In the Open dialog box, browse to a file, select it, and then choose Open.

    A file must be 1 GB or less to be uploaded to Amazon QuickSight.

  6. To prepare the data before creating the dataset, choose Edit/Preview data. Otherwise, choose Visualize to create an analysis using the data as-is. If you choose the former, you can specify a dataset name as part of preparing the data. If you choose the latter, a dataset with the same name as the source file is created. To learn more about data preparation, see Preparing Data.