SQL Spreadsheets online help Prev Page Prev Page
About SQL Spreadsheets
Version history
Contact us
Supported database engines
Using SQL Spreadsheets
Home page
SQL workbench
Command selection
Data sets
Exporting data sets
Exporting to text files
Exporting to Excel
Define column formats
Task settings
DATETIME tag formatting options
Connect to database
Conecting to databases directly without client libraries installed
Connecting to an Oracle database
SQL scripts
SQL tags
Image and file options
Define column formats
Delivery channels
Logging options
Run task
Scheduling a task

Define column formats

SQL Spreadsheets uses the default Excel formatting type for all columns, except for date/time data, where it uses the yyyy-mm-dd hh:mm:ss format.

Note that for numbers, you must use , as the thousands separator, and . as the decimal separator, when defining the column formats in SQL Spreadsheets. Excel will use the correct separators based on your regional settings, but the format type you enter in SQL Spreadsheets must use , and . as the thousands and decimal separators respectively.

If you want to define a different format for your columns, click on the Column formats


Enter the format type you want to use. If you want to use the General
Excel format type, leave the format value blank. In the example below, we want to use the #.##0,00 € format type for the UnitPrice and LineTotal columns.


To find out the Excel format type, you can use Excel to first enter some test values, then select the Format Cells


Select the format type you want to use.


Click on the Custom
option to see how the format type is defined. Use this same value in SQL Spreadsheets, except for numbers, where you must use , as the thousands separator and . as the decimal separator.