Table

Importing data

Importing is the fastest way to get existing data into your tables. TexAu supports CSV uploads with automatic column mapping and type detection.


Before you upload

File requirements

  • Format: CSV (Comma-Separated Values) only
  • Max file size: 10 MB
  • Max columns: 100 per import
  • Header row required: the first row must contain column names

A 10 MB CSV file typically holds 50,000-100,000 rows of standard business data.

Preparing your file

  1. Make sure row 1 contains column names (Email, Name, Company, etc.).
  2. Remove completely blank rows between data.
  3. Remove columns you don't need if you have more than 100.
  4. Close the file in any spreadsheet application before uploading.

Supported encodings

TexAu automatically detects file encoding:

  • UTF-8 —most common (default for modern tools)
  • Windows-1252 —common on Windows and older files
  • ISO-8859-1 —used in some European datasets

If your file came from Excel or Google Sheets, encoding is handled automatically.


The import process

  1. Open your table in TexAu.
  2. Click the Import button in the table toolbar.
  3. Upload your CSV file (drag and drop, or browse to select).
  4. TexAu validates the file —it checks format, encoding, size, and structure.
  5. Review the column mapping screen and match your CSV columns to table columns.
  6. Click Import to load the data.

Column mapping

After uploading, TexAu shows a mapping screen:

  • Auto-matched columns —TexAu matches CSV headers to table columns with similar names.
  • New columns —if your CSV has columns that don't exist in the table yet, TexAu offers to create them.
  • Skipped columns —leave any column unmapped to exclude it from import.

Review each mapping to make sure data goes to the right place.


Type detection

TexAu looks at your data and suggests data types automatically:

  • Email addresses get tagged as "Email" type
  • Phone numbers as "Phone" type
  • URLs as the appropriate URL type
  • Company names as "Company Name" type

Setting the correct type gives you better formatting, validation, and enrichment matching.


After import

Once the import finishes, you'll see:

  • An import summary showing how many rows were imported, with any warnings
  • New rows in your table, visible immediately with all data populated
  • Empty cells preserved —if a cell was empty in your CSV, it stays empty (ready for enrichment)

Common import issues

This table scrolls sideways on small screens.

ProblemSolution
File is too largeSplit your data into multiple files under 10 MB each.
Too many columnsRemove unnecessary columns in your spreadsheet before exporting as CSV.
No header row detectedAdd column names to the first row of your CSV.
Special characters appear garbledExport your file as UTF-8 CSV from your spreadsheet application.
Import seems stuckLarge files (50,000+ rows) take longer. Let it run —usually completes within 1-2 minutes.

Tips

  • Clean before importing. A few minutes of cleanup prevents data quality issues later.
  • Use consistent headers. Same column names across imports makes mapping faster.
  • Start with a small batch. Import a few hundred rows first to verify everything looks right.
  • Review the mapping. Even if you're in a hurry, check that columns matched correctly.

Next steps