Table

Semantic data types

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.

TypeDescriptionExample
firstNameFirst nameJane, Michael
lastNameLast nameSmith, Johnson
fullNameComplete nameJane Smith
namePrefixTitle or honorificDr., Mr., Ms.
nameSuffixName suffixJr., PhD, III
emailEmail addressjane@acme.com
phonePhone number(555) 123-4567
jobTitleJob titleVP of Sales
departmentDepartmentEngineering, Sales
seniorityLevelSeniority rankManager, Director, C-Suite
employmentStatusEmployment typeEmployed, Freelancer
yearsExperienceYears of experience5, 10, 15

Company data

This table scrolls sideways on small screens.

TypeDescriptionExample
companyNameCompany nameAcme Corporation
companyDomainWebsite domainacme.com
companyTaglineSlogan or taglineThink Different
companyDescriptionWhat the company doesLeading cloud infrastructure provider
companyLinkedinUrlCompany LinkedIn pagelinkedin.com/company/acme
crunchbaseUrlCrunchbase profilecrunchbase.com/organization/acme
employeeCountExact employee count250, 1500
employeeRangeEmployee range51-200, 1001-5000
stockTickerStock symbolAAPL, TSLA

Location data

This table scrolls sideways on small screens.

TypeDescriptionExample
countryCountry nameUnited States, Germany
cityCity nameSan Francisco, London
postalCodeZIP or postal code94105, SW1A 1AA

Digital data

This table scrolls sideways on small screens.

TypeDescriptionExample
linkedinProfileUrlPersonal LinkedIn profilelinkedin.com/in/jane-smith
twitterUrlTwitter/X profiletwitter.com/jane_smith
urlAny web URLblog.company.com/article

Financial and numeric data

This table scrolls sideways on small screens.

TypeDescriptionExample
currencyMonetary amount$1,500,000
numberGeneric number42, 3.14

Date data

This table scrolls sideways on small screens.

TypeDescriptionExample
dateCalendar date2026-01-15

Other

This table scrolls sideways on small screens.

TypeDescriptionExample
idUnique identifiercust_12345
textFree-form textAny 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

  1. Click the column header.
  2. Select Edit Column.
  3. Change the data type.
  4. 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