View source for Supported File Formats

<languages/>


<translate>
<!--T:1-->
The TaticView [[Data Sources]] support the following file formats and types for [[Creating a New Data Source|import]] or [[Import/Update data|update]]:


<!--T:2-->
'''Supported Extensions''': 

<!--T:16-->
* <span style="color: #153c78;">'''XLS'''</span>
* <span style="color: #153c78;">'''XLSX'''</span> 
* <span style="color: #153c78;">'''XLSM'''</span>
* <span style="color: #153c78;">'''CSV'''</span> (or other compatible with CSV)


<!--T:3-->
<span id="limits">'''Limits Supported''':</span> 

<!--T:4-->
* XLS* files size are limited to 100MB (20MB for XLS)
* Files must contain at least one [[Date]], one [[Text]] and one [[Value]] column;
** total columns 256;
** maximum text + date columns 63;
** maximum numeric columns 254
* [[Text]] data type columns have a limit of 255 characters;
* [[Value]] data type columns are limited to 11 integers and 5 decimals;
* Column headings (headers) can contain a maximum of 50 characters;


<!--T:5-->
'''CSV Specific Requirements''': 

<!--T:6-->
* CSV files size are limited to 500MB
* Any field delimiter is supported (with the exception of line breaks);
* Date fields must be in a supported format. Ex.: ''"dd/MM/yyyy"'' = ''31/01/2013'';
* Value (numeric) fields  must use a dot ''"."'' or a comma ''","'' as decimal separator.

<!--T:17-->
Files can also contain formulas and expressions, see [[Expressions|File Formulas]] for more information.


<!--T:13-->
<span style="color: red;">'''Important:'''</span>

<!--T:15-->
If your worksheet is set up properly, but you still can not import, you may have a structural problem. We recommend that you try to save it again using the standard Excel format. [[Save File Supported Format|See how]].


<!--T:14-->
Some settings cannot be modified in the data file or import file during the data import so the dashboards can work properly. For instance:
* You cannot add new columns between already imported columns:
** New columns must be added at the end of the file;
* Columns titles cannot be modified after the first import:
** The columns nicknames can be modified in [[Input Data Format]], but the dashboard's objects created previously will keep the previous nickname;
** You must remove and add the column to update the dashboard's object nickname;
* The columns cannot be removed from the file after the first import;
* The columns position cannot be modified after the first import;
* The columns data type (text, value, date) cannot be modified after the first import;


</translate>