What Is a CSV Export
A CSV export saves table data as a plain text file with comma-separated values. Learn how a delimiter works and what to expect when opening CSV in Excel.
Contents
- How commas and delimiters separate values
- What a CSV export does not keep
- Opening a CSV export in a spreadsheet
- Questions About CSV Export Files
- Is a CSV export the same as an Excel file?
- What is comma-separated values in simple terms?
- Why does my CSV export open with all data in one column?
- Can I edit a CSV export before saving it?
A CSV export is a file that saves the rows and columns of a table as plain text, with each value separated by a delimiter such as a comma. The format stands for comma-separated values, and it exists so that data from one program can be read by another. A CSV export keeps the numbers and words of a record but drops formatting, formulas and colors. Understanding the file helps you move service notes, dates and costs between tools without losing them.
How commas and delimiters separate values
A delimiter is the character placed between values in a CSV export, and the comma is the one the format is named after. Each line in the file becomes one row, and each delimiter marks the boundary between columns. Some exports use a semicolon or a tab instead, which matters when a program reads the file. The delimiter tells the reading program where one field ends and the next begins.
What a CSV export does not keep
A CSV export stores values only, so cell colors, bold text, formulas and merged cells do not carry over. The plain text spreadsheet file holds the result of a formula as a number, not the formula itself. Charts, images and column widths are also lost when a table is saved this way. Knowing this helps you decide which details must be written as explicit values before you export.
Opening a CSV export in a spreadsheet
Opening CSV in Excel or another spreadsheet program shows the values in a grid, but the program applies its own guesses about data types. A date may be read in a different order, and a leading zero on a number may disappear. Checking the delimiter and the column types during import keeps the record accurate. Save the file in the native format of your spreadsheet after checking it.
Questions About CSV Export Files
Is a CSV export the same as an Excel file?
No, a CSV export is not the same as an Excel file. A CSV export is plain text that any program can open, while an Excel workbook is a binary or packaged format that holds formatting and formulas. A CSV export carries values only and loses the layout of the original table.
What is comma-separated values in simple terms?
Comma-separated values means a text file where a comma sits between each value in a row. Each line of the file represents one record, and the commas split that record into fields. The format is readable in a text editor and importable into a spreadsheet.
Why does my CSV export open with all data in one column?
A CSV export opens in one column when the spreadsheet does not recognize the delimiter used in the file. The file may use a semicolon, a tab or another character instead of a comma. Set the delimiter in the import step, and the values will split into separate columns.
Can I edit a CSV export before saving it?
Yes, you can edit a CSV export in a text editor or a spreadsheet before saving it again. Keep the delimiter consistent and avoid adding extra commas inside a value without quoting it. Check the file after saving so the columns still line up.