A text file separated data by a special character called a delimiter. It specifies the boundary between separate and independent regions in plain text. The delimiter is used when you need to import text files to use in Excel. You need to instruct Excel how to separate the values into appropriate rows and columns and you use the delimiter.