What is the CSV File format?

1What is a CSV file?

CSV stands for Comma-Separated Values. It is a plain text file that represents a table: each line is a row, and within each line the values are separated by a character, traditionally a comma. The first line usually contains the column names.

Its great value is simplicity. Any spreadsheet, database, programming language, or online service can read and write CSV, so it became the common language for moving data from one system to another: exporting contacts, downloading bank transactions, importing products into a store, or analyzing survey results.

2Origin and standard: is there an official specification for CSV?

The format was used since the early days of business computing, decades before anyone standardized it. For years every program interpreted it in its own way. In 2005 RFC 4180 was published, documenting common practice and registering the text/csv MIME type, although it is more of a description than a strict standard, and many variants are in use.

The basic rules are few: one row per line, fields separated by a delimiter, and if a field contains the delimiter, line breaks, or quotes, it is enclosed in double quotes, and internal quotes are doubled. Because these rules are applied with different nuances, two programs can read the same file in different ways.

3Why does my CSV show up in one column or with odd separators?

In many countries the comma is used as the decimal separator, for example 3,5. To avoid confusion, versions of Excel set to those languages usually use a semicolon as the column separator. If you open a comma-separated CSV in an Excel that expects semicolons, all the content will appear stacked in a single column, and the reverse is also true.

The solution is to specify the separator when importing. In Excel, the command to import data from text or CSV lets you choose the delimiter and the file encoding. In online spreadsheets and LibreOffice, an import dialog appears that lets you choose comma, semicolon, or tab. That keeps your data from getting mixed up or split in the wrong places.

4Garbled accents and special characters in CSV: how to fix them

A CSV is text, so it depends on encoding. If the file is UTF-8 and the program opens it as Windows-1252, you will see sequences like "ó" instead of "ó". Excel, when you open a file by double-clicking, does not always detect UTF-8, especially if the file lacks the byte order mark, known as the BOM.

There are two reliable fixes. The first is to import the file from the Data menu and explicitly choose UTF-8 encoding. The second is to save the CSV as UTF-8 with BOM, an option several programs offer, which helps Excel recognize the encoding. For data you will share with other systems, UTF-8 is the safest standard.

• If you see strange characters: change the encoding when importing.
• If everything appears in one column: change the delimiter when importing.
• If you lose leading zeros (ZIP codes, ID numbers): import that column as text.
• If dates change: set the column format before opening.

5CSV vs. XLSX, ODS, and PDF

An XLSX stores much more than data: formulas, formatting, colors, multiple sheets, charts, and pivot tables. A CSV keeps only the values of a single table, so it is much smaller and easier to process with other programs, but any formatting or formulas are lost when saving. That is why it is best to keep the XLSX as your working file and export a CSV only when you need to exchange data.

PDF plays a different role: it freezes the look of a table for reading or printing, but extracting its data afterward is awkward. If you need a report to look the same everywhere, use PDF; if you need another system to process the data, use CSV.

6How CSV relates to PDF in Rayo PDF GO

A CSV is not a visual document, so to share it as a report the usual approach is to open it in a spreadsheet, format it, and export it to PDF, or use the Office to PDF tool in Rayo PDF GO with the file already prepared in an office format. All processing happens on your device, which is valuable when the data includes personal or financial information.

In the opposite direction, if you have a table inside a PDF and want to bring it into a spreadsheet, you can extract the text with the Extract text tool, or apply OCR if the PDF is a scan, and then clean up and organize the data. It requires manual review, because the columns in a PDF are not always rebuilt exactly.

One last tip for working with data: never overwrite your only original file. Keep an untouched copy of the downloaded CSV and work on another one, because spreadsheets can reinterpret dates, long numbers, and codes when opening them. That way, if something gets corrupted when saving, you can always go back to the data as it arrived.