🏛️ 列表转多列（把一列数据排成多列表格）Convert a List to Columns

使用说明与常见问题How-to & FAQ

「列表转多列（把一列数据排成多列表格）」是什么？What is the Convert a List to Columns tool?

把一长串列表排成多列：设置列数，可按行（横向依次填充）或按列（竖向依次填充，像报纸和电话簿）排列；输出对齐的纯文本（中文按两个字符宽度对齐）、Tab 分隔（可直接粘贴进 Excel）、CSV 或 Markdown 表格，列间距可调。适合把名单、词表、编号排版成紧凑的表格，数据在本地处理。Lay out a long list in several columns. Choose the number of columns and fill them across (row by row) or down (column by column, like a newspaper or phone book). Output aligned plain text (Chinese characters count as double width), tab-separated text that pastes straight into Excel, CSV or a Markdown table, with adjustable column spacing. Great for turning name lists, word lists and numbers into compact tables. Processed locally.

如何使用「列表转多列（把一列数据排成多列表格）」？How do I use the Convert a List to Columns tool?

在「列表转多列（把一列数据排成多列表格）」中，把内容粘贴或输入到上方输入框，按需设置「输入分隔符」、「自定义」、「列数」、「排列顺序」、「输出」，结果会实时显示在下方，点击「复制结果」即可复制。In the Convert a List to Columns: Paste or type into the input box, adjust "Input separator", "Custom", "Columns", "Order", "Output"; the result appears below instantly — click "Copy result" to copy it.

“按行”和“按列”有什么区别？What's the difference between Across and Down?

按行填充：第一行放第 1、2、3 项，第二行放第 4、5、6 项……阅读顺序是从左到右；按列填充：第一列从上到下放前几项，再到第二列，像报纸分栏或电话簿，竖着读顺序不变。按列时会自动减少多余的空列。Across fills row by row: the first row holds items 1, 2 and 3, the second 4, 5 and 6, and so on, reading left to right. Down fills column by column, top to bottom, like newspaper columns or a phone book, so the order reads downwards. With Down, empty trailing columns are removed automatically.

中文为什么也能对齐？Why does Chinese text line up?

对齐文本按“显示宽度”计算：汉字、全角符号和表情算 2 个字符宽，英文和数字算 1 个，所以在等宽字体（代码编辑器、终端、记事本）中中英文混排也能对齐。粘贴到 Excel 请用 Tab 分隔格式，每项会自动进入单独的单元格。Aligned text uses display width: Chinese characters, full-width symbols and emoji count as two columns and Latin letters and digits as one, so mixed text lines up in a monospace font (code editors, terminals, Notepad). For Excel, use the tab-separated output and each item lands in its own cell.

分隔符是怎么自动识别的？How is the separator detected automatically?

“自动识别”按以下顺序判断：有换行就按行分隔，否则依次检查 Tab、分号、逗号（含中文逗号和顿号）、竖线，最后才是空格。用逗号、分号或 Tab 分隔时支持 CSV 式的双引号，例如 "北京, 中国" 会被当作一项。需要其他符号时选择“自定义”，可用 \n 和 \t 表示换行和 Tab。输出沿用原来的分隔符（包括自定义分隔符和中文逗号），含分隔符的项会重新加上双引号；空行默认忽略，不算作项目。Auto-detect works in this order: if there are line breaks, each line is an item; otherwise it checks for tabs, semicolons, commas (including the Chinese comma and enumeration comma), pipes and finally spaces. With comma, semicolon or tab separators, CSV-style double quotes are honoured, so "Paris, France" counts as one item. Choose Custom for anything else; \n and \t stand for a new line and a tab. The output keeps the original separator (including a custom one or the Chinese comma), items that contain the separator are quoted again, and blank lines are ignored by default.

输入和输出是什么样的？What does the input and output look like?

例如在「列表转多列（把一列数据排成多列表格）」中输入 1 ⏎ 2 ⏎ 3 ⏎ 4 ⏎ 5 ⏎ 6 ⏎ 7，「列数」设为 3，输出为：1 2 3 ⏎ 4 5 6 ⏎ 7（⏎ 表示换行）。For example, the Convert a List to Columns turns the input 1 ⏎ 2 ⏎ 3 ⏎ 4 ⏎ 5 ⏎ 6 ⏎ 7, "Columns" set to 3 into: 1 2 3 ⏎ 4 5 6 ⏎ 7 (⏎ marks a line break).

有哪些选项可以调整？What options can I adjust?

「列表转多列（把一列数据排成多列表格）」的设置：「输入分隔符」可选 自动识别、换行、逗号、分号、Tab、空格等（默认 自动识别）；「自定义」可留空；「列数」默认 3；「排列顺序」可选 按行（横向填充）、按列（竖向填充）（默认 按行（横向填充））；「输出」可选 对齐文本、Tab 分隔（Excel）、CSV、Markdown 表格（默认 对齐文本）；「列间距」默认 2。改动任一选项后结果会按新设置重新生成。Settings in the Convert a List to Columns — "Input separator": Auto-detect, New line, Comma, Semicolon, Tab, Space, etc. (default Auto-detect); "Custom" optional; "Columns" default 3; "Order": Across (row by row), Down (column by column) (default Across (row by row)); "Output": Aligned text, Tab-separated (Excel), CSV, Markdown table (default Aligned text); "Column gap" default 2. Changing any option regenerates the result with the new setting.

处理大段文本会卡吗？Can it handle long text?

「列表转多列（把一列数据排成多列表格）」在浏览器中直接处理，几 MB 以内的文本通常瞬间完成；文本不会离开你的设备。The Convert a List to Columns runs in your browser; text up to a few MB is usually processed instantly and never leaves your device.

「列表转多列（把一列数据排成多列表格）」免费吗？需要注册吗？Is the Convert a List to Columns free? Do I need an account?

「列表转多列（把一列数据排成多列表格）」完全免费，无需注册或安装，打开网页即可使用，手机和电脑都能用；输入的内容只在你的浏览器本地处理。The Convert a List to Columns is completely free with no sign-up or install and works on phones and desktops; what you enter is processed only in your browser.