Data & CSV
CSV side-by-side combiner
Combine tables by row position with strict or blank-padded alignment.
A clear answer. Here’s how.
Aligns first data row with first data row and so on, without matching keys. Requires equal row counts by default; padding mode retains the longer table. Right headings keep their name when free, otherwise receive a collision-safe Right. prefix and suffix. Original cells stay text; output is capped at 200 columns and 2 million cells.
See a worked example
Worked example
A fixed demonstration, separate from the values you enter above.
- Original / left CSV
ID,Name 001,Ada 002,Sam
- Left separator
- Comma
- Updated / right CSV
ID,Name 001,Ada 002,Samuel 003,Jo
- Right separator
- Comma
- Unequal row counts
- Pad missing rows with blanks
Example result
| ID | Name | Right.ID.2 | Right.Name.2 |
|---|---|---|---|
| 001 | Ada | 001 | Ada |
| 002 | Sam | 002 | Samuel |
| 003 | Jo |
Rows are aligned by position, without key matching. Pad mode adds empty cells for missing rows.