🔍

首页Home › 开发工具Developer Tools

🔓 CSV URL 解码(解码单元格)URL-Decode CSV

对 CSV/TSV 指定列(或全部)做 URL 解码,识别 %XX 和 + 空格,解码失败的单元格保留原文并计数。URL-decode chosen CSV/TSV columns (or all of them), recognising %XX and + as space. Cells that fail to decode are left unchanged and counted.

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

「CSV URL 解码(解码单元格)」是什么?What is the URL-Decode CSV tool?

对 CSV/TSV 指定列(或全部)做 URL 解码,识别 %XX 和 + 空格,解码失败的单元格保留原文并计数。URL-decode chosen CSV/TSV columns (or all of them), recognising %XX and + as space. Cells that fail to decode are left unchanged and counted.

如何使用「CSV URL 解码(解码单元格)」?How do I use the URL-Decode CSV tool?

在「CSV URL 解码(解码单元格)」中,把内容粘贴或输入到上方输入框,按需设置「列(留空 = 全部)」,结果会实时显示在下方,点击「复制结果」即可复制。Paste your CSV and, if needed, list the columns to decode (leave it blank to decode every column). Leave "Treat + as space" on for form-encoded data, or turn it off to keep + as a plus sign. Click "Copy result" to copy the decoded CSV.

非法的 % 序列会怎样?What about invalid % sequences?

该单元格保持原文,并在结果说明里计入“无法解码”的数量。That cell is left as it was and counted under 'could not be decoded' in the status line.

+ 号会被当成空格吗?Is + treated as a space?

由「把 + 当作空格」选项决定(默认勾选):勾选时按表单编码(application/x-www-form-urlencoded)的习惯,先把 + 换成空格再解码;取消勾选时 + 原样保留为加号,只解码 %XX。%2B 无论哪种设置都解码为加号。That depends on the "Treat + as space" option, which is on by default. When it is on, + becomes a space before decoding, as in form encoding (application/x-www-form-urlencoded). Turn it off to keep + as a literal plus sign and decode only %XX sequences. %2B always decodes to a plus sign.

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

例如在「CSV URL 解码(解码单元格)」中输入 a,b ⏎ hello%20world,x,「列(留空 = 全部)」设为 1,输出为:a,b ⏎ hello world,x(⏎ 表示换行)。With "Columns (blank = all)" set to 1, the input a,b ⏎ hello%20world,x becomes a,b ⏎ hello world,x (⏎ marks a line break).

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

「CSV URL 解码(解码单元格)」的设置:「列(留空 = 全部)」可留空;可勾选:「把 + 当作空格」(默认勾选)、「第一行是表头」(默认勾选)、「也解码表头」。改动任一选项后结果会按新设置重新生成。You can adjust "Columns (blank = all)" (optional); and the "Treat + as space" (on by default), "First row is a header" (on by default) and "Also decode the header" checkboxes. The result updates as soon as you change a setting.

行长度不一致(有的行字段多、有的行字段少)时会怎样?What happens when rows have different numbers of fields?

不会凭空补字段,也不会删掉字段:操作只作用于每行实际存在的字段,每行保持自己原来的长度。比如某行没有要处理的那一列,这一行就原样保留。检测到这种行时,结果下方会有一行提示说明有几行。需要统一列数时,请用“CSV 补齐不完整行”。No fields are invented or dropped: the operation only touches the fields each row actually has, and every row keeps its own length. If a row does not have the column being changed, that row is left as it is. When such rows are found, a one-line note below the result says how many. To give every row the same number of fields, use Fill Incomplete CSV Records.

代码或数据会被上传吗?Is my code or data uploaded?

不会。「CSV URL 解码(解码单元格)」完全用 JavaScript 在本地运行,适合处理含有密钥、内部接口等敏感内容的数据。No. The URL-Decode CSV tool runs entirely in local JavaScript, so it is safe for data containing keys or internal endpoints.

「CSV URL 解码(解码单元格)」免费吗?需要注册吗?Is the URL-Decode CSV tool free? Do I need an account?

「CSV URL 解码(解码单元格)」完全免费,无需注册或安装,打开网页即可使用,手机和电脑都能用;输入的内容只在你的浏览器本地处理。The URL-Decode CSV tool is completely free with no sign-up or install and works on phones and desktops; what you enter is processed only in your browser.

相关工具Related tools

🔗 CSV URL 编码(编码单元格)URL-Encode CSV🌐 URL 编码解码URL Encode / Decode🔀 十六进制 OR 运算(按位或)OR Hex Numbers⊼ 十六进制 NAND 运算(与非)NAND Hex Numbers⊕ 十六进制 XOR 运算(按位异或)XOR Hex Numbers🔁 反转十六进制数字Reverse Hex Digits🔄 循环移动十六进制数字Rotate Hex Digits🔀 打乱十六进制数字(可复现种子)Shuffle Hex Digits🎲 随机十六进制数生成器Generate Random Hexadecimal Numbers🚫 JSON 打码(隐藏敏感字段)Censor JSON🔑 提取 JSON 键名Extract JSON Keys📦 提取 JSON 值Extract JSON Values

← 全部工具All tools