# CSV Samples

Download CSV samples for UTF-8 imports, empty cells, stock codes, scientific notation and JSON inside quoted fields.

> Canonical page: https://test.elysiatools.com/en/samples/csv-samples

- **Category:** Data

- **Keywords:** csv, data, spreadsheet, table, export, import

## Overview

Use these ten CSV files to check encoding, column alignment and conversion in your spreadsheet, database or application. The samples progress from student records to orders containing JSON objects and arrays, with known results for checking your import.

## Examples

- **Simple Student Data**: Basic student information with name, age, and gender
- **Products with Pricing**: E-commerce product catalog with IDs, names, prices, and inventory
- **Employee Information**: Detailed employee records with contact information and salaries
- **Sales Data Records**: Sales transaction data with dates, amounts, and customer information
- **Web Access Log**: Website access logs with IP addresses, timestamps, and user agents
- **Stock Trading Data**: Stock market trading data with prices, volumes, and technical indicators
- **International Data**: Multi-country dataset with currencies, languages, and regional information
- **E-commerce Orders**: Complex e-commerce order data with products, customers, and shipping information
- **Scientific Data**: Scientific experiment data with measurements, units, and statistical values
- **Complex Mixed Data**: Advanced dataset with nested JSON, null values, special characters, and mixed data types

## How it works

- Import 01-simple-students.csv first: confirm readable Chinese headers, four data records and three columns.
- Import your selected file with the same delimiter and quoting settings; compare its shape with the table.
- Before exporting, compare identifiers, blanks and JSON with the original to catch silent conversions.

## Frequently asked questions

### Why did the whole row land in one column?

Check that your import dialog uses a comma separator; a locale-specific semicolon default will not match these files.

### Does the header count as a data record?

The selection table counts data records only. An importer or file card may also count the header row: the students file has four data records plus one header row, so five rows in total.

### Can I split each line on commas?

That breaks JSON-containing fields in files 08 and 10. Use a CSV parser that understands quoted fields and doubled double quotes.

## Related tools

- [CSV Filter](https://test.elysiatools.com/en/tools/csv-filter): Filter CSV data by column values with multiple conditions and operators. Supports 12 filter operators including equals, contains, greater_than, less_than, and empty value checks. Additional Filters examples: \[{"column": "age", "operator": "greater_than", "value": "25"}\] \[{"column": "status", "operator": "equals", "value": "active"}, {"column": "score", "operator": "greater_equal", "value": "80"}\] \[{"column": "name", "operator": "contains", "value": "john"}, {"column": "email", "operator": "is_not_empty"}\]
- [JSON to CSV Converter](https://test.elysiatools.com/en/tools/json-to-csv): Convert JSON data to CSV format with customizable formatting options
- [CSV to JSON Converter](https://test.elysiatools.com/en/tools/csv-to-json): Convert CSV data to JSON format with customizable parsing options
- [PDF Table Extractor to CSV/JSON](https://test.elysiatools.com/en/tools/pdf-table-extractor-to-csv-json): Extract tables from PDFs with OpenDataLoader and export them as structured JSON, flat CSV, or HTML tables
- [CSV/JSON Data Watermarker](https://test.elysiatools.com/en/tools/csv-json-data-watermarker): Inject visible or signature-style watermark fields into CSV or JSON exports so shared datasets can be traced later
- [CSV to Database Migration Planner](https://test.elysiatools.com/en/tools/csv-to-database-migration-planner): Infer a relational schema from CSV data and generate create-table plus ALTER migration plans for PostgreSQL, MySQL, SQLite, or SQL Server
- [CSV Transformer](https://test.elysiatools.com/en/tools/csv-transformer): Transform and process CSV data with column operations, calculations, and data type conversions. Supports renaming columns, adding calculated columns, removing columns, converting data types, calculating values, and filtering rows. Operation examples: • Rename column: \[{"type": "rename", "column": "old_name", "new_name": "new_name"}\] • Add calculated column: \[{"type": "add_column", "new_column": "total", "formula": "price * quantity"}\] • Remove column: \[{"type": "remove_column", "remove_column": "column_to_remove"}\] • Convert data type: \[{"type": "convert_type", "convert_column": "age", "target_type": "number"}\] • Calculate values: \[{"type": "calculate", "target_column": "total", "expression": "price * tax + shipping"}\] • Filter rows: \[{"type": "filter_values", "filter_column": "status", "operator": "equals", "value": "active"}\]
- [JSON-LD Generator from CSV](https://test.elysiatools.com/en/tools/json-ld-generator-from-csv): Turn CSV or Excel rows into Schema.org JSON-LD for articles, products, or events, with validation-ready output for SEO workflows

## Related content

- [Python Samples](https://test.elysiatools.com/en/samples/python): Essential Python code examples and Hello World demonstrations
- [PDF Samples](https://test.elysiatools.com/en/samples/pdf-samples): Generated PDF samples from tools dated 2026-02-01 to 2026-02-10
- [NDJSON Samples](https://test.elysiatools.com/en/samples/ndjson-samples): Downloadable NDJSON files from simple to complex for ingestion, streaming, and pipeline tests
- [Parquet File Samples](https://test.elysiatools.com/en/samples/parquet-file-samples): Downloadable Parquet sample files from simple to complex for ETL and warehouse pipeline testing
- [Distributed Tracing Samples](https://test.elysiatools.com/en/samples/distributed-tracing-samples): Comprehensive distributed tracing examples using Jaeger, OpenTelemetry, and other modern observability tools for microservices architecture
- [ELK Stack Log Analysis Samples](https://test.elysiatools.com/en/samples/elk-stack-samples): Comprehensive ELK Stack (Elasticsearch, Logstash, Kibana) samples for log aggregation, processing, and visualization in distributed systems