Open the full cell value
UsefulDockCSV workspace
Files stay on this device简体中文

FROM FILE TO VERIFIED RESULT

Stack CSV exports into one reviewed table

Stack CSV exports into one table, align their columns and review missing fields. Keep source labels when useful and export the result.

Free · No account
or drop files · 10 MB per file

Import settings apply only to files opened next; existing datasets stay unchanged. No-header files receive column_1, column_2, and so on while keeping the first record. Exports include those column names.

Append

Stack tables after confirming column mappings and missing values.

Interactive example · fictional data

Stack exports with different column order

Example input · batch-a.csv
skuname
00123Blue·mug
Example input · batch-b.csv
namesku
Red·cap00456

Dots show spaces; ∅ means empty. Swipe tables to see all columns.

Ready to play

This small example does not change your open files.

Or open your own files. Data is processed in this browser.

See the result, then try it

Append

Interactive example · fictional data

Stack exports with different column order

Example input · batch-a.csv
skuname
00123Blue·mug
Example input · batch-b.csv
namesku
Red·cap00456

Dots show spaces; ∅ means empty. Swipe tables to see all columns.

Ready to play

This small example does not change your open files.

Rules, limits and questions

Append is useful for monthly exports, regional lists or batches that represent the same kind of record. Establish an output schema, map each input column to it, and make missing fields visible before combining the rows.

Your result: One combined dataset that can continue through filtering, cleanup or deduplication.

Steps

  1. Open the two supplier examples or your own compatible batches. Choose Append rather than Join when records should be stacked vertically.
  2. Confirm output columns and each input's mapping. Leave an explicit blank for a missing source field and optionally add a source-label column.
  3. Preview the output row count and schema, retain the appended result, and inspect duplicates before deciding whether any should be removed.

Download example CSVs

These files contain fictional data. You can also close help and choose “Try sample files” in the toolbar.

Expected example result

  • Appending the two three-record examples produces 6 records before any deduplication.
  • The repeated SKUs are retained because append combines observations rather than deciding which version is correct.
  • An optional source label distinguishes the earlier and updated batches.

Scope and limits

  • Appending updates is an example of mechanics, not a claim that both versions belong in a current catalog.
  • Column mapping must be explicit; missing fields are not inferred from another record.
  • Input and output limits are checked before retaining a combined result.

Questions

What is the difference between append and join?

Append stacks records under an output set of columns. Join matches records by a key and places selected information from two tables side by side.

Will append automatically remove repeated records?

No. Keep the appended result, then apply a separate reviewed deduplication rule if repetition is unwanted.

Related tool instructions

Close help and use the workspace tools to continue with your current files. The links below open in a new tab.

Full cell value

Review input record

No files open. Refreshing clears the session.

Session limits: 8 source files, 30 MB combined input and 16 retained datasets. Output is limited to 250,000 rows and 2,000,000 cells.

Data stays in this page's memory. Original files are never overwritten. A download action starts the browser download; confirm the saved file yourself.