Valid Labels and Values for Spreadsheet/CSV Mashables
Some labels and data that are valid in CSV files or Excel spreadsheets are not valid or not accessible in Presto. In the following cases, Presto may alter labels or transform or ignore the information:
Formulas in spreadsheets are valid, but the formula itself is not exported to the mashable in
Presto. The result of the calculation (the data) is exported instead.
Column labels:
Are recommended, but optional, for each column that contains data.
If column labels are missing, Presto automatically generates labels in the form Column1, Column2 and so on.
Are limited to letters, numbers and underscores in the ISO-8859-1 character set, also known as Latin 1.
Spaces and most symbols or punctuation characters are either converted to an underscore or ignored.
Must start with a letter (an alphabetical character) although they can contain numbers after that. Column labels that do not start with a letter are altered or overridden.
If a column label starts with a number or is a formatted date,
Presto adds a prefix of
Column_ to the label.
Can only be provided by
one row. For CSV files, this must be the first row.
For spreadsheets you can identify which row supplies the column labels when you register the mashable. If your spreadsheet has column names in two or more rows, you must choose a single row, allow Presto to generate column labels or simplify your worksheet.
Cannot span two or more cells in a spreadsheet.
Presto treats the second and subsequent columns as missing labels. You can allow
Presto to generate column names for the second and subsequent columns or you can update your worksheet.
Charts, images or other objects in spreadsheets are ignored and not saved in mashable data.
