8,981
edits
Changes
Marked this version for translation
<translate>
<!--T:1-->
The instructions below will help you make sure your CSV or Text file is formatted correctly to be imported as a TaticView data source.
<!--T:2-->
'''You can download a sample file here: [http://wiki.taticview.com/taticfiles/Sales.csv Sales.csv]'''
<!--T:3-->
'''If you still have problems importing, try [[Importing Problems]].'''
==== Headers ====<!--T:4-->
<!--T:5-->
Headers are not mandatory, but if present they should be contained in just one row (the first one). For example:
<!--T:6-->
[[File:Header csv.png|link=]]
==== Expressions ====<!--T:7-->
<!--T:8-->
When importing CSV or text files, we also support creating [[Expressions]] as well as Excel files.
<!--T:9-->
To consider expressions in CSV files, the composition of the expression must be in the header line of the data.
<!--T:10-->
Below is an example of a spreadsheet containing two expressions (''Avg Price'' and ''% Profit''):
<!--T:11-->
[[File:Expression header csv.png|link=]]
<!--T:12-->
To create expressions in CSV files the following rules must be observed:
* The expression must begin with the character '''equal''' and be enclosed in '''parentheses'''. Examples: ''=(Price/Quantity)'', ''=((Profit*100)/Price)''