Pricing

Rating

Developer

Actor stats

Categories

Share

🧩 CSV Combiner

Combine up to three CSV files into one. Columns are matched by their header name, so every value stays under the correct column even when the files list their columns in a different order. You decide the final column order.

📌 What it does

You have two or three CSV exports that hold the same kind of data but do not line up. One file has Name, Email, Domain, another has Domain, Email, Name, a third uses lowercase email. Pasting them together by hand mixes the data under the wrong headers.

This actor:

1. Reads each file by its header names, not by column position.
2. Matches columns across files (matching is not case-sensitive, so Email, EMAIL, and email are the same column).
3. Stacks every row into one combined CSV, each value placed under its correct header.
4. Writes the output in the column order you choose.

No row is removed. Every row from every file ends up in the output.

📥 Input

Input CSV Files

You can run with 1, 2, or 3 files. Files do not need the same columns or the same column order.

🧩 Output Column Order

A single dropdown controls the column order of the combined output:

• 📄 Use CSV 1 / 2 / 3 column order - the output follows that file's header order. Any column that exists only in the other files is added at the end, with an extra_ prefix on its name (for example extra_Phone). Nothing is dropped.
• ✍️ Custom order - you type the exact column order you want in the text box below the dropdown.

✍️ Custom Column Order

Used only when Custom order is selected. Write the column header names you want, one per line (press Enter between each, no commas):

Name
Email
Company
Domain

Rules for custom order:

• Order is exactly what you type, top to bottom.
• Matching is not case-sensitive. Typing email matches a Email column.
• The output keeps the original header casing from the file, not what you typed.
• Any combined column you do not list is dropped from the output.
• Any name you type that matches no column is skipped and reported in the log.

🔗 How columns are matched

Matching is by header name, lowercased and trimmed:

When a file is missing a column that another file has, that cell is left blank for the rows from the file that lacks it.

📊 Log

The log opens with a short summary so you can see what happened before you download anything.

CSV 1 / 2 / 3 order:

📥 Loaded CSVfiles:
CSV1:500 rows,12 columns
CSV2:320 rows,10 columns
CSV3:150 rows,14 columns
🧩 Combined rows:970
📊 Column analysis(across all files):
 Total unique columns:20
 Columns withdata:15
 Empty columns:5
Empty: Fax, Middle Name, Region, Notes, Suffix
📋 Output column order:CSV1
12 columns fromCSV1,in its order
+8 extra column(s) from the other files, appended with the "extra_"prefix:
 extra_Phone, extra_LinkedIn, extra_Title,...

Custom order:

📊 Column analysis(across all files):
 Total unique columns:20
 Columns withdata:15
 Empty columns:5
📋 Output column order:Custom(14 columns)
Order: Domain, Name, Email, Company,...
 ⚠️ 1name(s)in your list matched no column and were skipped: emial
 ❌ 6column(s)dropped(not in your order): Fax, Region, Notes, Phone, Suffix, Middle Name
 Of those,1 held data: Phone

• Total unique columns: how many distinct columns exist once all files are combined.
• Columns with data: how many of those hold at least one non-empty value. The rest are blank in every row.
• Dropped (custom order only): columns not in your list. The log also tells you how many of the dropped columns actually held data, so you know if you lost anything that mattered.

📤 Output

• Dataset: the combined rows, viewable as a table in the Apify console and available through the API.
• Key-value store, key OUTPUT: the combined CSV file, in the exact column order you chose, with original header casing. Download this for the clean file.

The output download link is shown on the run's Output tab.

📋 Example

CSV 1 (Name, Email, Company, Domain)

CSV 2 (Domain, Company, Email, Name, Phone) - different order, extra Phone

CSV 3 (email, name, title) - lowercase headers, extra title, no company or domain

Output column order: CSV 1

Carol's data came in as Domain, Company, Email, Name, Phone but still lands under the right headers. Eve's lowercase email matched Email, and her title was appended as extra_title.

⚠️ Notes

• Matching is case-insensitive and ignores leading and trailing spaces in headers.
• If two columns inside the same file share a header name, only one is kept for that file.
• No rows are removed. Duplicate rows across files are all kept.
• Empty CSVs, or files with no header row, are skipped with a warning. The run continues with the remaining files.