#223 · Rows Columns & Cells Tool

Interleave Two Excel Columns

Alternate values from two selected columns into one clean output column, with an option to retain or skip empty cells.

Office File Tool

Choose exactly one file
row
rows
Ad space

How to use this office tool

  1. Select the required spreadsheet file.
  2. Choose the worksheet and adjust the available options.
  3. Select Interleave columns and inspect the bounded preview.
  4. Download the newly generated result file.

What this tool does

Alternate values from two selected columns into one clean output column, with an option to retain or skip empty cells.

Values are emitted A1, B1, A2, B2 and so on from the two chosen source columns. The result is written to a new workbook.

Files remain on this device. Keep a backup of the source file and review generated reports before acting on them.

Supported formats

Reads XLSX, XLS, CSV, and TSV. Select the worksheet, then enter the first source column in the header-row field and the second in the preview-row field.

FormatSupport
XLSX / XLSBrowser parsing with SheetJS CE
CSV / TSVDelimited table input
OutputNew XLSX, CSV, JSON, or YAML report

Tips for better results

  • Use a clear header row and unique column names.
  • Keep identifiers such as postal codes stored as text.
  • Check dates, large integers, and formula results in the preview.
  • For sensitive workbooks, close the tab after downloading the result.

FAQ

Does the interleave two columns upload my file?

No. The selected file is read and processed locally by JavaScript in your browser. This page does not send its contents to a processing server.

What happens to formulas and formatting in this interleave two columns?

Reads XLSX, XLS, CSV, and TSV. Select the worksheet, then enter the first source column in the header-row field and the second in the preview-row field.

How large a file can I process with the interleave two columns?

The page enforces a 50 MB per-file and 1,000,000-cell safety limit. Practical capacity also depends on your device memory and browser.

Can I review the interleave two columns result before downloading?

Yes. A bounded preview and summary statistics appear after processing. The full newly generated result is available from the Download button.

Why might the interleave two columns result differ from Excel?

Browser libraries read stored workbook data but do not reproduce the complete Microsoft Excel calculation and rendering engine, VBA, Power Query, or every advanced workbook object.

Processing notes

AreaBehavior
PrivacyLocal browser processing
PreviewLimited rows and columns
SafetyCSV formula-prefix protection option

Browse more office tools

Office tool hubs