Credentials
Stored encrypted and decrypted only while a job is running. Use an IAM user scoped to the bucket below.
Temporary credentials
Leave empty for a long-lived IAM user key.
Location
Where browsing starts. Leave it empty to start at the top of the bucket. Saved work addresses objects by their full path, so this is a starting point rather than a restriction.
Secure Google OAuth authentication. Your password never reaches DataConverter. Only an encrypted refresh token is stored, and you can revoke access at any time from your Google Account settings.
Opens Google's secure account selection screen
Explicit privacy guarantees
- Load selected spreadsheets only: Read access is granted only to the spreadsheets you explicitly select.
- Every tab included: A picked spreadsheet loads with all of its tabs, and you choose which one to use.
- Zero extra access: Unselected spreadsheets and the rest of your Drive remain completely unreadable.
Waiting for Google… Finish signing in using the Google window that just opened.
Closed the Google window?
Google account
Reconnect if access was revoked or you need a different account.
Secure Google OAuth authentication. Your password never reaches DataConverter. Only an encrypted refresh token is stored, and you can revoke access at any time from your Google Account settings.
Opens Google's secure account selection screen
Explicit privacy guarantees
- Import selected files only: Read access is granted only to files you explicitly select.
- Direct output exports: Save converted files directly into your designated Drive destination.
- Zero extra access: Unselected files and non-target folders remain completely unreadable.
Waiting for Google… Finish signing in using the Google window that just opened.
Closed the Google window?
Google account
Reconnect if access was revoked or you need a different account.
Merge Multiple TSV Exports into One Excel File
Combine monthly or per-channel TSV exports into consolidated files with auto-aligned columns and deduplication.
Three Exports In, One Sheet Out
Upload your first file, then add the rest in Merge Data. Columns align by header name, so reordered or renamed columns never scramble your rows.
orders-2026-07.xlsx
Upload
Merge Data
Merge Data
Merge Data
Remove Duplicates
Sort Columns
| Order ID | Order Date | Customer Email | Product | Qty | Total | Ship ZIP | Discount Code | |
|---|---|---|---|---|---|---|---|---|
| #1043 | 7/28/26 | sam.okafor@example.com | Beeswax Wraps | 3 | 42.75 | 10001 | ||
| #1042 | 7/11/26 | li.wei@example.com | Cast Iron Skillet | 2 | 96.00 | 94107 | ||
| #1041 | 7/3/26 | ana.ruiz@example.com | Linen Apron | 1 | 38.00 | 02139 | ||
| #1046 | 8/31/26 | ana.ruiz@example.com | Beeswax Wraps | 1 | 14.25 | 02139 | ||
| #1045 | 8/19/26 | joao.lima@example.com | Walnut Board | 1 | 64.50 | 60614 | ||
| #1044 | 8/5/26 | mette.koch@example.com | Linen Apron | 2 | 76.00 | 08002 | ||
| #1048 | 9/22/26 | priya.nair@example.com | Cast Iron Skillet | 1 | 48.00 | 07030 | ||
| #1047 | 9/9/26 | li.wei@example.com | Walnut Board | 1 | 58.05 | 94107 | FALL10 | |
| #1046 | 8/31/26 | ana.ruiz@example.com | Beeswax Wraps | 1 | 14.25 | 02139 |
Upload July's file. Its columns establish the sheet headers, and its rows become the first entries.
August lists Total before Qty. Merge Data matches by column name, not index, placing each value under the correct header.
September labels the column Order Number. Map Order Number to Order ID to merge rows into the existing column.
Only September includes Discount Code. It appends as a new column, leaving July and August cells blank.
Order #1046 appears in both August and September. Remove Duplicates on Order ID keeps the original entry and drops the repeat.
Sort Columns on Order Date puts the quarter in chronological order. Download one Excel sheet with all 8 orders.
Align Renamed Columns Without Editing Source Files
Merge Data consolidates every unique column across files into one mapping table. Map renamed fields, uncheck redundant columns, and apply.
Select which source column maps to each unified field, or leave blank. Uncheck a column to omit it from the export.
| Keep | Column | orders-2026-07.tsv | orders-2026-08.tsv | orders-2026-09.tsv |
|---|---|---|---|---|
| Order ID | ||||
| Order Date | ||||
| Customer Email | ||||
| Product | ||||
| Qty | ||||
| Total | ||||
| Ship ZIP | ||||
| Order Number | ||||
| Discount Code |
Matching column names align automatically across files, regardless of their position in each upload.
September has no Order ID column, leaving its mapping blank and ready for assignment.
Choose Order Number from the dropdown to map September orders directly into Order ID.
Uncheck Order Number so it is not appended as a duplicate column. Discount Code remains checked for new data.
Apply mappings to merge 9 rows into 8 columns, ready for deduplication and export as Excel.
Merge Recurring Exports via API
Save mapping and deduplication steps as a template. Post recurring exports directly to the API and receive standardized Excel files automatically.
Explore the APIcurl -X POST "https://dataconverter.io/api/v1/convert/template" \ -H "Authorization: Bearer YOUR_TOKEN_HERE" \ -F "templateId=YOUR_TEMPLATE_ID" \ -F "file=@orders-2026-10.tsv" \ --output orders-2026-10.xlsx✓ 200 OK · orders-2026-10.xlsx
Frequently asked questions
How many exports can I merge at once?
Upload your first file, then add additional files in Merge Data. A free account is required to store uploaded files as datasets according to your plan limits.
What if columns appear in different orders across files?
Columns match automatically by header name rather than position, ensuring fields like Total and Qty always align correctly.
What if a file uses a different column name?
Unmatched headers display as blank. In Match Columns, map the renamed column (such as Order Number to Order ID) and uncheck any leftover fields so they do not append extra columns.
How do I eliminate duplicate records?
Run Remove Duplicate Records on your unique identifier column (like Order ID). The first occurrence is preserved and later duplicates are removed.
Can I track which file each row originated from?
Rows maintain the sequence of your uploads. To arrange combined records chronologically across all files, use Sort Columns on a date or timestamp column.