Data & CSV
Combine CSV tables
Append two tables with matching headings or align a union of their columns.
A clear answer. Here’s how.
Appends rows from the second CSV after the first, aligning exact heading names rather than positions. Strict mode requires the same heading set but permits different order. Union mode keeps first-table order and appends new second-table headings. Output is limited to 50,000 rows and 200 columns; values remain text.
See a worked example
Worked example
A fixed demonstration, separate from the values you enter above.
- First CSV
ID,Name 001,Ada 002,Sam
- First separator
- Comma
- Second CSV
Name,ID Jo,003 Lee,004
- Second separator
- Comma
- Column alignment
- Same heading set required
Example result
| ID | Name |
|---|---|
| 001 | Ada |
| 002 | Sam |
| 003 | Jo |
| 004 | Lee |