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
Creating a dataset using a Microsoft Excel file
To create a dataset using a Microsoft Excel file data source, upload an .xlsx file from a local or networked drive. The data is imported into SPICE.
For more information about creating new Amazon S3 datasets using Amazon S3 data sources, see Creating a dataset using an existing Amazon S3 data source or Creating a dataset using Amazon S3 files.
To create a dataset based on an excel file
-
Check Data source quotas to make sure that your target file doesn't exceed data source quotas.
-
On the Amazon QuickSight start page, choose Datasets.
-
On the Datasets page, choose New dataset.
-
In the FROM NEW DATA SOURCES section of the Create a Data Set page, choose Upload a file.
-
In the Open dialog box, choose a file, and then choose Open.
A file must be 1 GB or less to be uploaded to Amazon QuickSight.
-
If the Excel file contains multiple sheets, choose the sheet to import. You can change this later by preparing the data.
-
Note
On the following screens, you have multiple chances to prepare the data. Each of these takes you to the Prepare Data screen. This screen is the same one where you can access after the data import is complete. It enables you to change the upload settings even after the upload is complete.
Choose Select to confirm your settings. Or you can choose Edit/Preview data to prepare the data immediately.
A preview of the data appears on the next screen. You can't make changes directly to the data preview.
-
If the data headings and content don't look correct, choose Edit settings and prepare data to correct the file upload settings.
Otherwise, choose Next.
-
On the Data Source Details screen, you can choose Edit/Preview data. You can specify a dataset name in the Prepare Data screen.
If you don't need to prepare the data, you can choose to create an analysis using the data as-is. Choose Visualize. Doing this names the dataset the same as the source file, and takes you to the Analysis screen. To learn more about data preparation and excel upload settings, see Preparing data in Amazon QuickSight.
Note
If at anytime you want to make changes to the file, such as adding a new field,you must make the change in Microsoft Excel and create a new dataset using the updated version in QuickSight. For more information about possible implications of changing datasets, see Changing datasets .
