ما هو CSV؟ شرح تنسيق قيم المفصولة بفواصل
Quick Answer
CSV = قيم مفصولة بفواصل، كل صف = سجل، علامات اقتباس للقيم الخاصة. استخدم محول CSV JSON المجاني للتحويل بين CSV وJSON في متصفحك — بدون رفع، خاص تماماً.
Introduction
CSV (قيم مفصولة بفواصل) هو تنسيق نصي للبيانات الجدولية حيث كل صف هو سجل والقيم مفصولة بفواصل. علامات الاقتباس تحيط بالقيم التي تحتوي على فواصل أو أسطر جديدة. الصف الأول عادة ما يكون ترويسة بأسماء الأعمدة. CSV شائع لاستيراد/تصدير البيانات.
Step by Step
-
Understand CSV structure
A CSV file has one row per line, with values separated by commas. The first row is often a header row containing column names. Each subsequent row is a data record. Example: 'name,age,city\nAlice,30,NYC\nBob,25,LA'.
-
Learn the quoting rules
Values containing commas, quotes, or newlines must be wrapped in double quotes. A quote inside a quoted value is escaped by doubling it. Example: 'Alice,"Hello, world"' — the comma inside the quotes is part of the value, not a separator.
-
Recognize CSV variations
While commas are the standard delimiter, some files use semicolons (;), tabs (TSV), or pipes (|). European locales often use semicolons because commas are used as decimal separators. Always check the delimiter when parsing.
-
Convert CSV to other formats
CSV has no type information — all values are strings. When converting to JSON or loading into a program, you may need to convert numeric strings to numbers. Use our CSV to JSON Converter for instant conversion.
Examples
Simple CSV with headers
Input: Three columns, two data rows
Output: name,age,city
Alice,30,NYC
Bob,25,LA
CSV with quoted values
Input: Value containing a comma
Output: name,note
Alice,"Hello, world"
TSV (tab-separated)
Input: Same data, tab delimiter
Output: name age city
Alice 30 NYC
Common Problems
- All values are strings —CSV has no type information. Numbers, dates, and booleans are all stored as text and must be parsed by the application.
- Inconsistent delimiters —some files use commas, others semicolons or tabs. Detect the delimiter automatically or let the user specify it.
- Encoding issues —CSV files from Excel may use BOM or Windows-1252 encoding instead of UTF-8. This causes problems with non-ASCII characters.
- Inconsistent row lengths —some rows may have fewer or more columns than the header. Handle missing values as null and extra values by truncating or erroring.
Tips
- CSV is best for tabular data —use JSON for nested or hierarchical data.
- Always quote values containing commas, quotes, or newlines to avoid parsing errors.
- Use UTF-8 encoding without BOM for maximum compatibility.
- Use our CSV to JSON Converter to transform CSV into JSON for use in web applications.