CSV Basics

CSV & Data Import Glossary

Plain-English definitions of the terms you'll meet when preparing, cleaning, and importing CSV files. Each term links to a full guide if you need to fix the problem.

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