Difference between revisions of "Excel Importing Guide"
| Line 7: | Line 7: | ||
'''Headers''' | '''Headers''' | ||
| − | Headers should be contained in just one row (the first one) and not be merged. | + | Headers are not mandatory, but if present they should be contained in just one row (the first one) and not be in merged cells. |
[[File:headers_wrong.png|link=]] | [[File:headers_wrong.png|link=]] | ||
| + | |||
| + | [[File:headers_right.png|link=]] | ||
| + | |||
| − | [[File: | + | '''Multiple Data Tables''' |
| + | |||
| + | Only one table per spreadsheet can be imported. If the data in two different tables can not be joined, they must be imported as two separated data sources. | ||
| + | |||
| + | [[File:multipletables_wrong.png|link=]] | ||
| + | |||
| + | [[File:multipletables_right.png|link=]] | ||
| + | |||
| + | |||
| + | |||
| + | '''Merged Cells''' | ||
| + | |||
| + | Data should not contain merged cells for repeated values. All cells must be unmerged and values must be repeated for each cell. | ||
| + | |||
| + | [[File:mergedcells_wrong.png|link=]] | ||
| + | |||
| + | [[File:mergedcells_right.png|link=]] | ||
Revision as of 17:35, 26 August 2014
The instructions below will help you make sure your Excel file is formatted correctly to be imported as a TaticView data source.
You can download a sample file here: Sales.xlsx
Headers
Headers are not mandatory, but if present they should be contained in just one row (the first one) and not be in merged cells.
Multiple Data Tables
Only one table per spreadsheet can be imported. If the data in two different tables can not be joined, they must be imported as two separated data sources.
Merged Cells
Data should not contain merged cells for repeated values. All cells must be unmerged and values must be repeated for each cell.
