Column Types

Column Types are autodetected from the spreadsheet data when you import a file or connect a Google Sheet.

A column type is selected for every column in the Sheet.

To make sure your columns are detected correctly, format your data for import first: keep one value type per column and put the column names in the first row.

Note

As much formatting as possible is removed from number types in order to plot a chart.

Column Types

• Text Text or categorical data
• Integer Whole numbers
• Decimal Numbers with fractions
• Percent Numbers
• Currency Numbers
• Date Dates
• Timestamp Dates with hours/min/seconds
• Year Whole numbers

Tip

Formatting can be re-added to chart numbers via the Number Formatting and Locale options in the Chart Text side panel.

Related

• Formatting Data for Import - structure your sheet so types are detected correctly
• Transform Data - pivot, unpivot and clean up your data
• Number Formatting - format numeric columns in the chart
• Filtering - filter rows by text, number or date columns
• Aggregation - summarize the values in a column