Choosing file upload settings - Amazon QuickSight

Important: We've redesigned the Amazon QuickSight analysis workspace. You might encounter screenshots or procedural text that doesn't reflect the new look in the QuickSight console. We're in the process of updating screenshots and procedural text.

To find a feature or item, use the Quick search bar.

For more information on QuickSight's new look, see Introducing new analysis experience on Amazon QuickSight.

Choosing file upload settings

If you are using a file data source, confirm the upload settings, and correct them if necessary.

Important

If it's necessary to change upload settings, make these changes before you make any other changes to the dataset. Changing upload settings causes Amazon QuickSight to reimport the file. This process overwrites any changes you have made so far.

Changing text file upload settings

Text file upload settings include the file header indicator, file format, text delimiter, text qualifier, and start row. If you are working with an Amazon S3 data source, the upload settings you select are applied to all files you choose to use in this dataset.

Use the following procedure to change text file upload settings.

  1. On the data preparation page, open the Upload Settings pane by choosing the expand icon.

  2. In File format, choose the file format type.

  3. If you chose the custom separated (CUSTOM) format, specify the separating character in Delimiter.

  4. If the file doesn't contain a header row, deselect the Files include headers check box.

  5. If you want to start from a row other than the first row, specify the row number in Start from row. If the Files include headers check box is selected, the new starting row is treated as the header row. If the Files include headers check box is not selected, the new starting row is treated as the first data row.

  6. In Text qualifier, choose the text qualifier, either single quotes (') or double quotes (").

Changing Microsoft Excel file upload settings

Microsoft Excel file upload settings include the range header indicator and whole worksheet selector.

Use the following procedure to change Microsoft Excel file upload settings.

  1. On the data preparation page, open the Upload Settings pane by choosing the expand icon.

  2. Leave Upload whole sheet selected.

  3. If the file doesn't contain a header row, deselect the Range contains headers check box.