A
- Allowed values (enum)
- A fixed list of values a column can accept, such as Active, Paused, or Closed. Anything outside the list is rejected. In Excel this is usually done with a data validation dropdown.How to enforce dropdowns in Excel
B
- Blank cell
- A cell with no value. A blank cell in a required column is one of the most common reasons an import fails or creates incomplete records.Handling blank cells in CSV
- BOM (byte order mark)
- An invisible character some programs add to the very start of a UTF-8 file. Excel uses it to detect encoding, but some importers read it as part of the first header, so a column called "email" isn't recognized.Fix invisible characters in CSV
- Bulk import
- Loading many records into a system at once from a file, rather than entering them one by one. Most CRMs, e-commerce platforms, and accounting tools support bulk import from CSV.CSV import guide
C
- Column mapping
- Matching each column in your file to a field in the system you're importing into, for example mapping "E-mail Address" to the Email field. Consistent header names make mapping faster and less error-prone.CSV header naming best practices
- CSV (comma-separated values)
- A plain-text file format where each line is a row and each value is separated by a delimiter, usually a comma. CSV is the most widely supported format for moving data between systems.What is a CSV file?
- Currency formatting
- Symbols, thousands separators, and text such as "$1,200.00 USD" in a price column. Most importers expect a plain number like 1200.00, so formatted values are rejected or misread.Strip currency symbols from CSV
D
- Data cleansing
- Fixing problems in a dataset before it's used: trimming spaces, standardizing formats, removing duplicates, and filling or flagging missing values.CSV whitespace and trailing spaces
- Data validation
- Checking that each value meets a rule before it's accepted, such as a valid email, a number within a range, or a value from an allowed list. Validating at the point of entry is far cheaper than fixing data after import.Data validation software
- Date format
- The order and separators used to write a date, such as DD/MM/YYYY or MM/DD/YYYY. Mixed formats are a leading cause of import errors, because 03/04/2026 means different dates in different countries.CSV date formatting guide
- Deduplication
- Finding and removing rows that describe the same record, usually by comparing a unique field such as email address, SKU, or account number.CSV duplicate row detection
- Delimiter
- The character that separates values in a row. Commas are standard, but tabs, semicolons, and pipes are also common. If a file's delimiter doesn't match what the importer expects, every row lands in a single column.CSV delimiter guide
E
- E.164
- The international standard format for phone numbers: a plus sign, country code, and number with no spaces or punctuation, such as +12125550123. Many CRMs and SMS tools require it.CSV phone number standardization
- Encoding
- The rules used to store characters as bytes. If a file is saved in one encoding and read in another, accented letters and symbols turn into garbled text such as "José" instead of "José".CSV special characters and encoding
- Escaping (quoting)
- Wrapping a value in double quotes so that commas, line breaks, or quotes inside it aren't treated as delimiters. For example, "Smith, John" stays in one column. A quote inside a quoted value is written twice.CSV comma escaping guide
F
- Field
- A single piece of information in a record, such as first name or price. In a CSV, each field is a column and its name is given in the header row.
H
- Header row
- The first row of a CSV, containing the column names. Importers use the header row to map columns to fields, so renamed or misspelled headers often cause failed imports.CSV header naming best practices
I
- Import template
- A predefined set of columns, formats, and rules that a file must follow to import cleanly into a particular system, such as a Shopify product template or a HubSpot contacts template.Browse import templates
- Invisible characters
- Characters that don't show on screen but still change the data, such as non-breaking spaces, zero-width spaces, and byte order marks. They make identical-looking values fail to match.Fix invisible characters in CSV
- ISO 3166
- The international standard for country codes: two letters such as US, GB and AU, or three such as USA and GBR. Shopify, Shippo and many other importers want the 2-letter code and reject country names. The United Kingdom's code is GB, not UK.Shipping label CSV errors
- ISO 8601
- The international date format YYYY-MM-DD, for example 2026-03-04. It's unambiguous across countries and sorts correctly as text, which makes it the safest choice for CSV dates.CSV date formatting guide
L
- Leading zeros
- Zeros at the start of a value, as in ZIP codes, account numbers, and part numbers like 00471. Excel treats these values as numbers and removes the zeros unless the column is formatted as text.Excel leading zeros guide
- Line ending
- The invisible character or characters that mark the end of a row: CRLF on Windows and LF on macOS and Linux. Most importers handle both, but mixed line endings in one file can create blank or broken rows.
N
- Non-breaking space
- A space character that looks identical to a normal space but has a different code. It's often pasted in from web pages or Word and stops values like "New York" matching.Fix invisible characters in CSV
P
- Pipe-delimited file
- A text file that uses the | character to separate values. It's common in banking and legacy systems because pipes rarely appear inside real data.CSV delimiter guide
R
- Required field
- A column that must have a value in every row. Imports often reject rows with a missing required field, such as an email address for a contact or a SKU for a product.Make a column required in Excel
- Row limit
- The maximum number of rows a file or form accepts. Excel stops at 1,048,576 rows, and many importers set much lower limits per upload.Excel row limit guide
S
- Sample row
- An example row of correctly formatted data included in a template, showing people exactly how each column should be filled in.CSV sample row templates
- Schema
- The full definition of a dataset's structure: which columns exist, their types, which are required, and what values they allow. An import template is a schema that people can fill in.CSV form builder
- Scientific notation
- A way of writing very large numbers such as 8.47E+09. Excel switches long numbers like barcodes and HS codes into this format, and saving to CSV can permanently lose digits.Excel scientific notation issue
- Semicolon-separated file
- A CSV that uses semicolons instead of commas. Excel produces these in countries that use a comma as the decimal separator, such as much of Europe, which can break imports expecting commas.CSV delimiter guide
T
- Text qualifier
- The character used to wrap values that contain delimiters, almost always a double quote. Also called quoting.CSV comma escaping guide
- TSV (tab-separated values)
- A text file that uses tabs as the delimiter. It's what you get when copying cells from a spreadsheet, and it avoids most comma escaping problems.CSV delimiter guide
- Trailing whitespace
- Spaces or tabs at the end of a value. They're invisible in a spreadsheet but make "London " and "London" count as different values.CSV whitespace guide
U
- Unique column
- A column where no two rows can share the same value, such as an email address, SKU, or invoice number. Enforcing uniqueness prevents duplicate records on import.Enforce unique values in Excel
- UTF-8
- The most widely used text encoding. It supports every language and symbol, and it's the encoding most modern importers expect.CSV special characters and encoding
X
- XLSX
- Excel's workbook format. Unlike CSV it stores formatting, formulas, and multiple sheets, but many systems only import CSV, so XLSX files must be converted first.Excel to CSV conversion guide
Skip the cleanup entirely
Import Builder validates dates, emails, web addresses, phone numbers, country codes, numbers and required fields as people enter data, so you get a clean CSV without fixing delimiters, encoding, or formatting afterwards.
Start building free