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
- Make sure row 1 contains column names (Email, Name, Company, etc.).
- Remove completely blank rows between data.
- Remove columns you don't need if you have more than 100.
- 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
- Open your table in TexAu.
- Click the Import button in the table toolbar.
- Upload your CSV file (drag and drop, or browse to select).
- TexAu validates the file —it checks format, encoding, size, and structure.
- Review the column mapping screen and match your CSV columns to table columns.
- 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.
| Problem | Solution |
|---|---|
| File is too large | Split your data into multiple files under 10 MB each. |
| Too many columns | Remove unnecessary columns in your spreadsheet before exporting as CSV. |
| No header row detected | Add column names to the first row of your CSV. |
| Special characters appear garbled | Export your file as UTF-8 CSV from your spreadsheet application. |
| Import seems stuck | Large 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
- Working with rows —manage your imported data
- Understanding columns —refine your table structure
- Running enrichments —find missing information