Table Column Splitter - WeAlgorithm Software

Upload a table, combine the first column with each other column to generate independent files and download them as a zip package 🚫 Automatically filters invalid data rows πŸ“Š Each file contains a "Historical Quotes" sub-sheet (first position)

πŸ“
Click or drag to upload a table file
Supports .xlsx .xls .csv formats (CSV automatically detects UTF-8 / GBK encoding)
πŸ’‘ Rules: The first column is used as the common column (time) and is combined with each of the remaining columns to form a new table.
πŸ—‚οΈ Each file contains two worksheets (order adjusted):
  πŸ“Š Historical Quotes: only the current data column (single column, no time column) β€” placed first
  πŸ“„ Sheet1: common column + current data column (two columns) β€” placed second
🚫 Automatically filter invalid data: Rows where the current column value is 0, empty, null, or NaN will be removed; rows with an empty common column will also be filtered.
πŸ” Enhanced data detection (this optimization): No longer relies on the file's built-in dimension markers; directly scans real cells to locate the data area, fixing the issue where columns with data are split out as blank. Also supports merged cell filling, formula cached value fallback, automatic multi-worksheet selection, and GBK encoding for CSV.
πŸ“Œ Format preservation: Date and number formats and column widths are carried into the split files (dates are written as numeric serial numbers uniformly, and Excel / WPS will display them as dates).