Every column in TexAu has a semantic data type that tells the system what kind of information it holds. Setting the right type gets you better formatting, validation, and enrichment matching.
Why data types matter
- Formatting —phone numbers, dates, and currencies display consistently.
- Validation —TexAu checks that data matches the expected format.
- Enrichment matching —TexAu knows which providers can work with each data type.
- Import detection —auto-detect picks types based on your actual data.
All 32 semantic data types
People data
This table scrolls sideways on small screens.
| Type | Description | Example |
|---|---|---|
| firstName | First name | Jane, Michael |
| lastName | Last name | Smith, Johnson |
| fullName | Complete name | Jane Smith |
| namePrefix | Title or honorific | Dr., Mr., Ms. |
| nameSuffix | Name suffix | Jr., PhD, III |
| Email address | jane@acme.com | |
| phone | Phone number | (555) 123-4567 |
| jobTitle | Job title | VP of Sales |
| department | Department | Engineering, Sales |
| seniorityLevel | Seniority rank | Manager, Director, C-Suite |
| employmentStatus | Employment type | Employed, Freelancer |
| yearsExperience | Years of experience | 5, 10, 15 |
Company data
This table scrolls sideways on small screens.
| Type | Description | Example |
|---|---|---|
| companyName | Company name | Acme Corporation |
| companyDomain | Website domain | acme.com |
| companyTagline | Slogan or tagline | Think Different |
| companyDescription | What the company does | Leading cloud infrastructure provider |
| companyLinkedinUrl | Company LinkedIn page | linkedin.com/company/acme |
| crunchbaseUrl | Crunchbase profile | crunchbase.com/organization/acme |
| employeeCount | Exact employee count | 250, 1500 |
| employeeRange | Employee range | 51-200, 1001-5000 |
| stockTicker | Stock symbol | AAPL, TSLA |
Location data
This table scrolls sideways on small screens.
| Type | Description | Example |
|---|---|---|
| country | Country name | United States, Germany |
| city | City name | San Francisco, London |
| postalCode | ZIP or postal code | 94105, SW1A 1AA |
Digital data
This table scrolls sideways on small screens.
| Type | Description | Example |
|---|---|---|
| linkedinProfileUrl | Personal LinkedIn profile | linkedin.com/in/jane-smith |
| twitterUrl | Twitter/X profile | twitter.com/jane_smith |
| url | Any web URL | blog.company.com/article |
Financial and numeric data
This table scrolls sideways on small screens.
| Type | Description | Example |
|---|---|---|
| currency | Monetary amount | $1,500,000 |
| number | Generic number | 42, 3.14 |
Date data
This table scrolls sideways on small screens.
| Type | Description | Example |
|---|---|---|
| date | Calendar date | 2026-01-15 |
Other
This table scrolls sideways on small screens.
| Type | Description | Example |
|---|---|---|
| id | Unique identifier | cust_12345 |
| text | Free-form text | Any text content |
Setting data types
During import
When you import a CSV, TexAu analyzes your data and suggests types automatically. Review each column and confirm or change the suggestion.
When adding a column
When you create a new column, pick the data type from the dropdown. Go with the most specific type available.
Changing later
- Click the column header.
- Select Edit Column.
- Change the data type.
- Save.
TexAu reformats existing data to match the new type where possible.
Tips for choosing types
- Be specific. Use "email" instead of "text" for email columns. Specific types enable enrichment and validation.
- One type per column. If a column has both phones and emails, split it into two columns.
- Review after import. Auto-detection is accurate most of the time, but a quick check catches edge cases.
Next steps
- Understanding columns —learn about column types
- Running enrichments —use data types for enrichment matching
- Importing data —import and auto-detect types