Elysia Tools

Browse tools, examples, visual explainers, and topic guides from one clear workspace.

Top Categories

Hubs

Language
ZHDERUPTENFRES

Elysia Tools

Navigation

Data

CSV sample files: import, quoting and missing-data guide

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

Samples

Entries inside this sample collection

FileSimple

Simple Student Data

Basic student information with name, age, and gender

Difficulty

1/10

Estimated time

1 min

Tags

students, basic, education, simple

01-simple-students.csv

CSV · 77 B

Download fileOpen in new tab
fileSize
77 B
rowCount
5
columnCount
3
encoding
UTF-8
delimiter
,
hasHeader
true
FileSimple

Products with Pricing

E-commerce product catalog with IDs, names, prices, and inventory

Difficulty

1/10

Estimated time

1 min

Tags

products, pricing, inventory, ecommerce, catalog

02-products-price.csv

CSV · 321 B

Download fileOpen in new tab
fileSize
321 B
rowCount
8
columnCount
5
encoding
UTF-8
delimiter
,
hasHeader
true
hasNumbers
true
hasDecimals
true
FileIntermediate

Employee Information

Detailed employee records with contact information and salaries

Difficulty

2/10

Estimated time

2 min

Tags

employees, hr, contact, salaries, company

03-employees-info.csv

CSV · 593 B

Download fileOpen in new tab
fileSize
593 B
rowCount
7
columnCount
8
encoding
UTF-8
delimiter
,
hasHeader
true
hasNumbers
true
hasDates
true
FileIntermediate

Sales Data Records

Sales transaction data with dates, amounts, and customer information

Difficulty

2/10

Estimated time

2 min

Tags

sales, transactions, revenue, customers, business

04-sales-data.csv

CSV · 639 B

Download fileOpen in new tab
fileSize
639 B
rowCount
8
columnCount
9
encoding
UTF-8
delimiter
,
hasHeader
true
hasNumbers
true
hasDates
true
FileIntermediate

Web Access Log

Website access logs with IP addresses, timestamps, and user agents

Difficulty

2/10

Estimated time

2 min

Tags

logs, web, access, analytics, servers

05-web-access-log.csv

CSV · 757 B

Download fileOpen in new tab
fileSize
757 B
rowCount
7
columnCount
7
encoding
UTF-8
delimiter
,
hasHeader
true
hasDates
true
hasIPs
true
FileIntermediate

Stock Trading Data

Stock market trading data with prices, volumes, and technical indicators

Difficulty

2/10

Estimated time

2 min

Tags

stocks, trading, finance, market, investments

06-stock-trading.csv

CSV · 756 B

Download fileOpen in new tab
fileSize
756 B
rowCount
9
columnCount
10
encoding
UTF-8
delimiter
,
hasHeader
true
hasNumbers
true
hasDates
true
FileIntermediate

International Data

Multi-country dataset with currencies, languages, and regional information

Difficulty

2/10

Estimated time

2 min

Tags

international, countries, currencies, languages, regional

07-international-data.csv

CSV · 999 B

Download fileOpen in new tab
fileSize
999 B
rowCount
11
columnCount
9
encoding
UTF-8
delimiter
,
hasHeader
true
hasNumbers
true
hasUnicode
true
FileComplex

E-commerce Orders

Complex e-commerce order data with products, customers, and shipping information

Difficulty

3/10

Estimated time

3 min

Tags

ecommerce, orders, customers, shipping, complex

08-ecommerce-orders.csv

CSV · 1.4 KB

Download fileOpen in new tab
fileSize
1.4 KB
rowCount
4
columnCount
10
encoding
UTF-8
delimiter
,
hasHeader
true
hasNumbers
true
hasDates
true
FileComplex

Scientific Data

Scientific experiment data with measurements, units, and statistical values

Difficulty

3/10

Estimated time

3 min

Tags

scientific, research, experiments, measurements, statistics

09-scientific-data.csv

CSV · 910 B

Download fileOpen in new tab
fileSize
910 B
rowCount
8
columnCount
14
encoding
UTF-8
delimiter
,
hasHeader
true
hasNumbers
true
hasDecimals
true
FileComplex

Complex Mixed Data

Advanced dataset with nested JSON, null values, special characters, and mixed data types

Difficulty

4/10

Estimated time

5 min

Tags

complex, json, nested, mixed-data, advanced

10-complex-mixed-data.csv

CSV · 2.8 KB

Download fileOpen in new tab
fileSize
2.8 KB
rowCount
5
columnCount
10
encoding
UTF-8
delimiter
,
hasHeader
true
hasNumbers
true
hasDates
true

Tools

Tools frequently paired with this sample

Related

Related sample collections

Related

Related workflows

Tool usage guide

Sample-focused context for search and workflow understanding

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.

Choose the file that tests your problem

Counts are data records × columns, excluding the header. Files use UTF-8 and comma separators. Choose a relevant case, then check a second structure.

Choose the file that tests your problem
FileRecords × columnsBest check
01-simple-students.csv4 × 3Chinese headers and a minimal import baseline
04-sales-data.csv7 × 9Missing cells without shifting later columns
06-stock-trading.csv8 × 10Leading-zero identifiers and percentage text
08-ecommerce-orders.csv3 × 10CSV quoting followed by nested JSON parsing
09-scientific-data.csv7 × 14Scientific notation and units in headers
10-complex-mixed-data.csv4 × 10Empty cells, JSON null, arrays and escaped text

Import without losing information

Download a file from its card or open it in a new tab. Import it in your own tool; this page has no spreadsheet editor. Select UTF-8, comma separation, a first-row header and double-quote text quoting. Preview the column count before accepting.

CSV fields are text, without an enforced type schema. Importers may infer numbers or dates; preserve identifiers explicitly as text. In file 06, 000001 must retain six characters. In file 09, 1.25e-3 can become 0.00125; ±0.05 remains text unless you interpret the uncertainty.

Which tools to test with these samples

Use these files with a CSV to JSON Converter, a CSV to Excel Converter, a CSV Splitter for large files, and a CSV File Merger for combining exports. The mixed data types expose delimiter and encoding handling.

The set covers CSV files of different sizes and complexity, including one dataset with nested JSON, null values and special characters — the case that breaks naive parsers and conversion tools.

How it works

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

Edge cases & common failures

  • Quotes do not always mean embedded commas

    03-employees-info.csv quotes names and emails even where those values contain no comma. Use CSV quoting rules rather than stripping every quote manually.

  • Blank, null and [] differ

    In 10-complex-mixed-data.csv, REC004 has an empty 用户信息 cell; REC002 contains JSON null values, and REC003 has an empty error array. Keep those three states distinct.

  • Small files do not test throughput

    These are compact functional fixtures, not a benchmark for large uploads, memory usage or streaming performance.

Examples

1. Establish a UTF-8 baseline

How to use

Import 01-simple-students.csv with a header row. Locate 张三 in the first record.

UTF-8; comma; header enabled

Outcome

Four records remain aligned under 姓名, 年龄 and 性别; Chinese text is readable.

2. Keep missing sales values in place

How to use

Import 04-sales-data.csv. Inspect O003, O004, O007 and the final notes column; count all empty cells.

Preserve empty fields, including trailing fields

Outcome

Seven records occupy nine columns. There are five empty cells in total, with at most one per record; an empty product or salesperson must not shift amounts or dates.

3. Read JSON inside an order

How to use

Read 08-ecommerce-orders.csv with a CSV parser, then parse 客户信息, 商品列表 and 配送地址 as JSON.

CSV parse → selected-cell JSON parse

Outcome

Three records have ten columns. The first 商品列表 becomes a two-item array; CSV doubled quotes have already been removed by the first parsing stage.

FAQ

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.

Hub

Repair a Rejected CSV Import and Load It into Your Database

Diagnose why a CSV import keeps failing, map messy headers onto the target schema, remove duplicates under a stated policy, and emit typed INSERT statements or a bulk-load TSV.

Hub

CSV Cleanup, Reshaping, and Delivery Workflow

Inspect CSV structure, keep the right columns, reshape rows, compare outputs, and split final files for dependable imports or reporting.

Hub

Tabular Data Cleanup, Shaping, and Normalization

Take messy tabular data to analysis-ready — merge source tables into one, strip the byte-order marks that break column matching, keep only the columns you need, fix spellings and formats, handle outliers by policy instead of panic, scale or standardize the numbers, and finish with range limits and a crosstab summary.

Hub

Tabular Data Conversion Workflow

Convert CSV, spreadsheets, JSON, HTML tables, Markdown, XML, and text while checking headers, delimiters, types, and encoding.

Home
Tools3212
Workbench
Samples593
Visualizations471
Viewers103
Hubs239
Tags333
Images, Audio & Video657

Image, audio, and video processing, conversion, and optimization tools

Math, Date & Finance647

Calculators, numerics, date logic, statistics, and finance tools

Design & Color298

Color, layout, graphics, visual styling, and design helper tools

Text & Writing209

Writing, cleanup, formatting, extraction, and text analysis tools

Developer & Web193

Developer utilities, networking, web debugging, and automation helpers

Conversion & Encoding175

Format, file, archive, unit, and encoding conversion tools

Lead Generation Quiz Launch and Contact Handoff
Memorial Drafts: Family Review and Print Handoff
Private Habit Records: Backup, Restore and Sharing Review
Article to X and LinkedIn Drafts: Fact Review and Handoff
Markdown Interactive Deck Review and Offline Handoff

© 2026 Elysia Tools. All rights reserved.

DocsPricingAboutTerms of ServicePrivacy PolicyCookiesContact

Data Processing

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"}]

Format Conversion

JSON to CSV Converter

Convert JSON data to CSV format with customizable formatting options

Format Conversion

CSV to JSON Converter

Convert CSV data to JSON format with customizable parsing options

Data Processing

PDF Table Extractor to CSV/JSON

Extract tables from PDFs with OpenDataLoader and export them as structured JSON, flat CSV, or HTML tables

Security

CSV/JSON Data Watermarker

Inject visible or signature-style watermark fields into CSV or JSON exports so shared datasets can be traced later

Data Processing

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

Data Processing

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"}]

SEO

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

Programming Languages

Python Samples

Essential Python code examples and Hello World demonstrations

Document

PDF Samples

Generated PDF samples from tools dated 2026-02-01 to 2026-02-10

Data

NDJSON Samples

Downloadable NDJSON files from simple to complex for ingestion, streaming, and pipeline tests

Data

Parquet File Samples

Downloadable Parquet sample files from simple to complex for ETL and warehouse pipeline testing

Observability

Distributed Tracing Samples

Comprehensive distributed tracing examples using Jaeger, OpenTelemetry, and other modern observability tools for microservices architecture

DevOps

ELK Stack Log Analysis Samples

Comprehensive ELK Stack (Elasticsearch, Logstash, Kibana) samples for log aggregation, processing, and visualization in distributed systems