Small files. Clear answers.
Original, fictional examples for checking each import. Nothing to upload and no customer data inside.
Friday dispatch handoff
Two source CSVs, three expected outputs and a README. Start with the orders and scan events.
Text encoding
The same six records in three encodings. Six columns; quantity total: 12. Keep product_code as text.
Read the guide and expected results →
See all six expected records
| record_id | product_code | description | city | quantity | note |
|---|---|---|---|---|---|
| DEMO-001 | 00127 | 蓝色文件夹 | 北京 | 2 | Sample data only |
| DEMO-002 | 00008 | Café notebook | São Paulo | 1 | Contains an accent |
| DEMO-003 | 0127 | Paper clips | München | 3 | Code length differs |
| DEMO-004 | A-004 | Labels, small | London | 4 | Comma stays in one field |
| DEMO-005 | 00000 | Folder "A" | 上海 | 2 | Quotes stay in one field |
| DEMO-006 | 90001 | Archive box | Paris | 0 |
Leading zeros & long IDs
Six records, four columns. Deliberately different code lengths, two similar 18-digit IDs, and blanks. Import both identifier columns as text.
The encoding and identifier samples use comma delimiters. The delimiter exercise also includes semicolon and tab files. The encoding filenames describe their actual encoding. The identifier sample uses UTF-8 with BOM. You may copy and adapt these fictional records for practice.
Fix a CSV that opens in one column
Choose the delimiter from the file, then check field boundaries before loading.
Clean unwanted spaces without changing codes
Distinguish edge spaces, repeated internal spaces and nonbreaking spaces.
Remove duplicates with a clear business key
Separate repeated rows from legitimate repeat orders, and account for blank keys.
Resolve mixed date text without guessing
Use a declared source format and hold ambiguous or impossible dates for review.
Convert text amounts with known separators
Keep zero, missing values and ambiguous amounts distinct while reconciling totals.
Combine CSVs when column order changes
Map columns by exact header name, preserve identifiers and report an absent field before combining exports.
Read CSV fields with commas, quotes and line breaks
Load quoted CSV records in Excel for Mac Power Query and verify the exact multiline note.
Compare two lists using exact identifiers
Find absent keys, case differences and duplicate reference keys in both directions.
Add categories without ambiguous lookups
Return a category only for a unique key with a populated reference label.
Reconcile totals and missing data by group
Keep text amounts, missing regions and real zeros visible in a regional summary.
Check a CSV export before sending it
Reimport the delivered file and verify identifiers, Unicode text and totals.
Split CSV uploads by complete records
Repeat headers, preserve multiline fields and reconcile every part before uploading.
Find field changes between two exports
Match unique identifiers and separate added, removed, changed and unchanged records.
The workflow pack contains 21 delimited files, a manifest and a README. It also includes file-level examples for date, batch and quoted-field exercises; those examples are not a claim that an Excel workflow has been validated. Files named expected are comparison outputs; keep them outside any input folder you combine. All workflow fixtures are UTF-8 with BOM. CSV files use commas except delimiter-semicolon.csv; delimiter-tab.tsv uses tabs.
Date and comparison test pack
Six CSV files cover twelve date cases and two eight-row identifier lists, with expected results for both comparison directions. The pack contains those files, a README and file hashes. The dated notes describe actual Excel formula checks and their limits.