Follow the steps below to add tables from a Microsoft Excel workbook

 

- Navigate to Add Data and select Microsoft Excel.  Then, select the required file.

 

- In the Data Properties window, set required settings.

 

Component	Description
1	Connect to a worksheet or a Named Range
2	The name of the worksheet or Named Range
3	When connecting to a worksheet, import data from the entire sheet
4	When connecting to a worksheet, import data from an explicit range
5	Use the first row in the data as names of fields
6	Preview the data
7	Show\Hide fields from the preview window
8	Define the culture that will be used when parsing dates, numeric values and currencies

 

Before you click ADD to complete the process, make sure field types are set correctly.  The type of a field directly affects the type of Dimensions created on it, and therefore affects the type of analyses it can be used with.  The type of field is indicated by an icon which is placed next to its name in the Preview box:

Icon	Meaning
	Text field
	Numeric field
	Date/Time field

In some scenarios, the automatically assigned type for a field may be incorrect.  If this happens, you can change the field’s type manually by right-clicking the field header and setting the correct field type.