11,856
edits
Changes
Updating to match new version of source page
The instructions below will help you make sure your Excel file is formatted correctly to be imported as a TaticView datasource. '''You can download a sample file here: '''[[httpSpecial://wiki.taticview.com/taticfilesFilePath/Sales.xlsx |Sales.xlsx]]'''
'''If you still have problems importing, try [[Importing Problems]].'''
'''CabeçalhosHeaders'''
Headers are not mandatory, but if present they should be contained in just one row (the first one) and not be in merged cells.
'''Evite Múltiplas TabelasAvoid Multiple Data Tables'''
Only one table by spreadsheet can be imported. If the data in two different tables can not be joined, they must be imported as two separated data sourcesdatasources.
'''CorrijaFix/Remova LinhasRemove Empty Rows/Colunas VaziasColumns'''
Remove or Fix (by adding at least a header) to full empty rows and columns.
'''Remove Merged Cells'''
'''Remove All Table External Items'''
'''Normalize seus Dadosyour Data'''
Normalization of data (where column headers can be converted into attribute values) will result in better analysis. To do this, first convert metric names to represent attribute values, and then consolidate all metric columns into a single column of data.
[[File:normalization_wrong.png|link=]] [[File:normalization_right.png|link=]]
'''Check the order of the worksheet'''
If the file (XLS or XLSX) has more than one worksheet (tab), make sure that the worksheet to be imported is the first one in the file. TaticView considers only the first worksheet (tab) of the file, ignoring the others. In the example below, we show how the order of the worksheets should be, so that we can import the '''Sales''' worksheet.
[[File:spreadsheet_order_wrong.png|link=]] [[File:spreadsheet_order_right.png|link=]]