If some column type is detected incorrectly, then you can change it. Detected column types ( string, integer, decimal, date, or datetime) are shown below each column name. You might want to check the heater row before mapping columns, as this reloads the file on the screen.ĮazyBI will try to detect each source file column data type based on the first 100 rows of the source file. For example, specify 0 if you do not have any header row. If eazyBI has detected it incorrectly, you can change the number of header rows. You can also import a new file in the existing data cube to add a new data set or additional data – in this case, select the existing cube name.ĮazyBI detects if a file has a header row with column names. If this is new data set, then enter a new cube name, for example, Sales cube, for importing sales transactions.

Go to the Source Data tab Source Files and choose the source file from the local directory or server for upload.Īfter uploading the file, click Preview to proceed with file column mapping and create the data cube.įirst, enter the data cube name where you would like to import your data.

Import csv file into excel