有用科技小编2026/10/16
浏览9761
阅读10分钟表格截图想变成能编辑的表格，关键就两步：先把图截正截清（屏幕放大到 150%、水平正对、存 PNG），再用系统自带或轻量工具做一次 OCR，粘到 Excel 后逐格核对数字和小数点。识别串行、丢小数点，多数是图片质量或表格结构造成的，工具本身通常没问题，不必急着重装或换电脑。
这 5 个方法在 Windows 10/11 实测可用：截图拍正放大、OneNote 复制图片中的文本、PowerToys 文本提取器、Excel「来自图片的数据」、分块识别后分列校对。
适用系统：Windows 10/11；最后更新：2026-10-16。
为什么表格截图一识别就串行、漏小数点
常见的现场是：屏幕缩放停在 100%，用 Win+Shift+S 截一张 1280×720 的表格图，存成 JPG 丢进识别工具，出来 `1 234.56` 变 `123456`、`0.05` 变 `005`，相邻两列的数字挤到同一行；粘到 Excel 后整列左对齐，用 SUM 一算结果是 0。
'/%3E%3Crect%20x='28'%20y='64'%20width='544'%20height='42'%20rx='10'%20fill='%23def5ef'%20stroke='%23dbe3ec'%20stroke-width='1'/%3E%3Ccircle%20cx='52'%20cy='85'%20r='12'%20fill='%2315b88a'/%3E%3Cpath%20d='M46%2085%20l4%204%20l8%20-9'%20fill='none'%20stroke='%23ffffff'%20stroke-width='2.4'%20stroke-linecap='round'%20stroke-linejoin='round'/%3E%3Ctext%20x='76'%20y='90.0'%20font-family='Segoe%20UI,Microsoft%20YaHei,PingFang%20SC,sans-serif'%20font-size='14'%20fill='%231f2d3d'%20text-anchor='start'%20font-weight='500'%3E截图是否水平、没有倾斜%3C/text%3E%3Ctext%20x='556'%20y='90.0'%20font-family='Segoe%20UI,Microsoft%20YaHei,PingFang%20SC,sans-serif'%20font-size='13'%20fill='%235b6b7b'%20text-anchor='middle'%20font-weight='400'%3E1%3C/text%3E%3Crect%20x='28'%20y='114'%20width='544'%20height='42'%20rx='10'%20fill='%23ffffff'%20stroke='%23dbe3ec'%20stroke-width='1'/%3E%3Ccircle%20cx='52'%20cy='135'%20r='12'%20fill='%2315b88a'/%3E%3Cpath%20d='M46%20135%20l4%204%20l8%20-9'%20fill='none'%20stroke='%23ffffff'%20stroke-width='2.4'%20stroke-linecap='round'%20stroke-linejoin='round'/%3E%3Ctext%20x='76'%20y='140.0'%20font-family='Segoe%20UI,Microsoft%20YaHei,PingFang%20SC,sans-serif'%20font-size='14'%20fill='%231f2d3d'%20text-anchor='start'%20font-weight='500'%3E分辨率是否够，能否放大到150%25%3C/text%3E%3Ctext%20x='556'%20y='140.0'%20font-family='Segoe%20UI,Microsoft%20YaHei,PingFang%20SC,sans-serif'%20font-size='13'%20fill='%235b6b7b'%20text-anchor='middle'%20font-weight='400'%3E2%3C/text%3E%3Crect%20x='28'%20y='164'%20width='544'%20height='42'%20rx='10'%20fill='%23def5ef'%20stroke='%23dbe3ec'%20stroke-width='1'/%3E%3Ccircle%20cx='52'%20cy='185'%20r='12'%20fill='%2315b88a'/%3E%3Cpath%20d='M46%20185%20l4%204%20l8%20-9'%20fill='none'%20stroke='%23ffffff'%20stroke-width='2.4'%20stroke-linecap='round'%20stroke-linejoin='round'/%3E%3Ctext%20x='76'%20y='190.0'%20font-family='Segoe%20UI,Microsoft%20YaHei,PingFang%20SC,sans-serif'%20font-size='14'%20fill='%231f2d3d'%20text-anchor='start'%20font-weight='500'%3E图片是否存成PNG格式%3C/text%3E%3Ctext%20x='556'%20y='190.0'%20font-family='Segoe%20UI,Microsoft%20YaHei,PingFang%20SC,sans-serif'%20font-size='13'%20fill='%235b6b7b'%20text-anchor='middle'%20font-weight='400'%3E3%3C/text%3E%3Crect%20x='28'%20y='214'%20width='544'%20height='42'%20rx='10'%20fill='%23ffffff'%20stroke='%23dbe3ec'%20stroke-width='1'/%3E%3Ccircle%20cx='52'%20cy='235'%20r='12'%20fill='%2315b88a'/%3E%3Cpath%20d='M46%20235%20l4%204%20l8%20-9'%20fill='none'%20stroke='%23ffffff'%20stroke-width='2.4'%20stroke-linecap='round'%20stroke-linejoin='round'/%3E%3Ctext%20x='76'%20y='240.0'%20font-family='Segoe%20UI,Microsoft%20YaHei,PingFang%20SC,sans-serif'%20font-size='14'%20fill='%231f2d3d'%20text-anchor='start'%20font-weight='500'%3E是否只截了表格区域%3C/text%3E%3Ctext%20x='556'%20y='240.0'%20font-family='Segoe%20UI,Microsoft%20YaHei,PingFang%20SC,sans-serif'%20font-size='13'%20fill='%235b6b7b'%20text-anchor='middle'%20font-weight='400'%3E4%3C/text%3E%3Crect%20x='28'%20y='264'%20width='544'%20height='42'%20rx='10'%20fill='%23def5ef'%20stroke='%23dbe3ec'%20stroke-width='1'/%3E%3Ccircle%20cx='52'%20cy='285'%20r='12'%20fill='%2315b88a'/%3E%3Cpath%20d='M46%20285%20l4%204%20l8%20-9'%20fill='none'%20stroke='%23ffffff'%20stroke-width='2.4'%20stroke-linecap='round'%20stroke-linejoin='round'/%3E%3Ctext%20x='76'%20y='290.0'%20font-family='Segoe%20UI,Microsoft%20YaHei,PingFang%20SC,sans-serif'%20font-size='14'%20fill='%231f2d3d'%20text-anchor='start'%20font-weight='500'%3E表头是否含合并单元格%3C/text%3E%3Ctext%20x='556'%20y='290.0'%20font-family='Segoe%20UI,Microsoft%20YaHei,PingFang%20SC,sans-serif'%20font-size='13'%20fill='%235b6b7b'%20text-anchor='middle'%20font-weight='400'%3E5%3C/text%3E%3C/svg%3E)
先分清是图片本身不够清楚，还是表格结构太密导致串列，再挑对应的方法，能省掉大段重复录入。
方法1 截图拍正并放大再截取
成像质量决定识别率的上限，截图这一步做对了，后面每种方法都会更准。
操作步骤
- 按 Win+Shift+S 调出截图工具栏，只框选表格本体，把表头里的合并单元格和背景色区域留在框外。
- 打开 设置→系统→显示→缩放与布局，把缩放改成 150%，让表格里的字在屏幕上更高更清楚，再重新截图。
- 截图时保持屏幕与表格水平，不要斜着截屏幕，也不要用手机对着屏幕拍。
- 保存时选 PNG。JPG 压缩会产生噪点，笔画细的小数点容易糊成一团。
- 原图分辨率低时，先放大网页或文档再把窗口拉大截图，不要截完再用图片编辑放大位图；截图默认落在 C:\Users\你的用户名\Pictures\屏幕截图。
斜着截、拉低分辨率、存成 JPG，是识别串行最集中的来源。改掉这三样，同一张表换个工具重识一遍，错位往往就少一大半。
'/%3E%3Crect%20x='28'%20y='64'%20width='262'%20height='142'%20rx='12'%20fill='%23fdeeec'%20stroke='%23e8604c'%20stroke-width='1.5'/%3E%3Crect%20x='28'%20y='64'%20width='262'%20height='42'%20rx='12'%20fill='%23e8604c'/%3E%3Crect%20x='28'%20y='94'%20width='262'%20height='12'%20fill='%23e8604c'/%3E%3Cg%20transform='translate(50,85)'%3E%3Ccircle%20r='12'%20fill='%23ffffff'/%3E%3Cpath%20d='M-5%20-5%20l10%2010%20M5%20-5%20l-10%2010'%20fill='none'%20stroke='%23e8604c'%20stroke-width='2.6'%20stroke-linecap='round'%20stroke-linejoin='round'/%3E%3C/g%3E%3Ctext%20x='70'%20y='91'%20font-family='Segoe%20UI,Microsoft%20YaHei,PingFang%20SC,sans-serif'%20font-size='15'%20fill='%23ffffff'%20text-anchor='start'%20font-weight='700'%3E误区%3C/text%3E%3Ccircle%20cx='50'%20cy='126'%20r='3'%20fill='%23e8604c'/%3E%3Ctext%20x='64'%20y='130'%20font-family='Segoe%20UI,Microsoft%20YaHei,PingFang%20SC,sans-serif'%20font-size='13'%20fill='%231f2d3d'%20text-anchor='start'%20font-weight='400'%3E斜着截表格%3C/text%3E%3Ccircle%20cx='50'%20cy='152'%20r='3'%20fill='%23e8604c'/%3E%3Ctext%20x='64'%20y='156'%20font-family='Segoe%20UI,Microsoft%20YaHei,PingFang%20SC,sans-serif'%20font-size='13'%20fill='%231f2d3d'%20text-anchor='start'%20font-weight='400'%3E拉低分辨率截图%3C/text%3E%3Ccircle%20cx='50'%20cy='178'%20r='3'%20fill='%23e8604c'/%3E%3Ctext%20x='64'%20y='182'%20font-family='Segoe%20UI,Microsoft%20YaHei,PingFang%20SC,sans-serif'%20font-size='13'%20fill='%231f2d3d'%20text-anchor='start'%20font-weight='400'%3E存成JPG压缩%3C/text%3E%3Crect%20x='310'%20y='64'%20width='262'%20height='142'%20rx='12'%20fill='%23def5ef'%20stroke='%2315b88a'%20stroke-width='1.5'/%3E%3Crect%20x='310'%20y='64'%20width='262'%20height='42'%20rx='12'%20fill='%2315b88a'/%3E%3Crect%20x='310'%20y='94'%20width='262'%20height='12'%20fill='%2315b88a'/%3E%3Cg%20transform='translate(332,85)'%3E%3Ccircle%20r='12'%20fill='%23ffffff'/%3E%3Cpath%20d='M-5%200%20l4%204%20l7%20-8'%20fill='none'%20stroke='%2315b88a'%20stroke-width='2.6'%20stroke-linecap='round'%20stroke-linejoin='round'/%3E%3C/g%3E%3Ctext%20x='352.0'%20y='91'%20font-family='Segoe%20UI,Microsoft%20YaHei,PingFang%20SC,sans-serif'%20font-size='15'%20fill='%23ffffff'%20text-anchor='start'%20font-weight='700'%3E正确%3C/text%3E%3Ccircle%20cx='332'%20cy='126'%20r='3'%20fill='%2315b88a'/%3E%3Ctext%20x='346.0'%20y='130'%20font-family='Segoe%20UI,Microsoft%20YaHei,PingFang%20SC,sans-serif'%20font-size='13'%20fill='%231f2d3d'%20text-anchor='start'%20font-weight='400'%3E屏幕放大150%25%3C/text%3E%3Ccircle%20cx='332'%20cy='152'%20r='3'%20fill='%2315b88a'/%3E%3Ctext%20x='346.0'%20y='156'%20font-family='Segoe%20UI,Microsoft%20YaHei,PingFang%20SC,sans-serif'%20font-size='13'%20fill='%231f2d3d'%20text-anchor='start'%20font-weight='400'%3E水平正对截图%3C/text%3E%3Ccircle%20cx='332'%20cy='178'%20r='3'%20fill='%2315b88a'/%3E%3Ctext%20x='346.0'%20y='182'%20font-family='Segoe%20UI,Microsoft%20YaHei,PingFang%20SC,sans-serif'%20font-size='13'%20fill='%231f2d3d'%20text-anchor='start'%20font-weight='400'%3E存成PNG无损%3C/text%3E%3C/svg%3E)
方法2 用OneNote复制图片中的文本
OneNote 自带 OCR，右键一次就能把图片里的文字变成可粘贴文本，适合少量表格。
操作步骤
- 打开 OneNote，点 插入→图片，把刚截好的表格图放进来。
- 用鼠标点击选中这张图片。没选中时，右键菜单里不会出现识别项。
- 右键图片→「复制图片中的文本」，文字直接进剪贴板。
- 切到 Excel，按 Ctrl+V 粘贴，再逐格核对数字和小数点。
- 没看到识别结果时，检查图片是不是被裁剪得过小，重新插入一次再试。
它适合十几行以内的小表。行列一多，粘进来的文字会按空格断行，串列的概率明显上升。
用「软领Windows优化大师」更省事
「图片提取文字」解决的是截图、照片里的文字要一个字一个字敲的问题。它把图片中的文字识别出来，提取成可复制的文本，粘到表格里再逐格核对就行，适合把表格截图里的数字和文字一次性转出来，省掉逐字录入。
软领是知名国产软件品牌，20 年技术沉淀、服务千万用户。软领官网 wyouhua.com 直接下载，安装无捆绑勾选项；软件里能点客服按钮联系真人客服，复杂情况有工程师远程协助。
方法3 用PowerToys文本提取器框选
PowerToys 的文本提取器按 Win+Shift+T 直接框选屏幕区域，文字进剪贴板，比截图再识别少一步。
操作步骤
- 安装并打开 PowerToys（默认装在 C:\Program Files\PowerToys），在左侧找到「文本提取器」，确认右侧开关处于启用状态。
- 快捷键默认是 Win+Shift+T。被输入法或截图软件占用时，在同一页面改成别的组合键。
- 把图片打开在屏幕上，按 Win+Shift+T，拖框选中表格区域。
- 松开鼠标，文字自动进剪贴板，切到 Excel 按 Ctrl+V 粘贴。
- 粘贴后点 数据→分列，按制表符拆开，再对照原图逐格校对。
框选范围只盖住表格，别把标题栏、滚动条一起框进去，多出来的字符会挤进第一列。
'/%3E%3Crect%20x='28'%20y='94'%20width='169'%20height='78'%20rx='12'%20fill='%23ffffff'%20stroke='%2315b88a'%20stroke-width='2'/%3E%3Ccircle%20cx='48'%20cy='94'%20r='15'%20fill='%2315b88a'/%3E%3Ctext%20x='48.0'%20y='99'%20font-family='Segoe%20UI,Microsoft%20YaHei,PingFang%20SC,sans-serif'%20font-size='14'%20fill='%23ffffff'%20text-anchor='middle'%20font-weight='700'%3E1%3C/text%3E%3Ctext%20x='112.66666666666667'%20y='138.0'%20font-family='Segoe%20UI,Microsoft%20YaHei,PingFang%20SC,sans-serif'%20font-size='15'%20fill='%231f2d3d'%20text-anchor='middle'%20font-weight='600'%3E框选表格区域%3C/text%3E%3Cpath%20d='M201%20124%20l9%209%20l-9%209'%20fill='none'%20stroke='%2315b88a'%20stroke-width='3'%20stroke-linecap='round'%20stroke-linejoin='round'/%3E%3Crect%20x='215'%20y='94'%20width='169'%20height='78'%20rx='12'%20fill='%23ffffff'%20stroke='%2315b88a'%20stroke-width='2'/%3E%3Ccircle%20cx='235'%20cy='94'%20r='15'%20fill='%2315b88a'/%3E%3Ctext%20x='235.33333333333334'%20y='99'%20font-family='Segoe%20UI,Microsoft%20YaHei,PingFang%20SC,sans-serif'%20font-size='14'%20fill='%23ffffff'%20text-anchor='middle'%20font-weight='700'%3E2%3C/text%3E%3Ctext%20x='300.0'%20y='138.0'%20font-family='Segoe%20UI,Microsoft%20YaHei,PingFang%20SC,sans-serif'%20font-size='15'%20fill='%231f2d3d'%20text-anchor='middle'%20font-weight='600'%3E文字进剪贴板%3C/text%3E%3Cpath%20d='M389%20124%20l9%209%20l-9%209'%20fill='none'%20stroke='%2315b88a'%20stroke-width='3'%20stroke-linecap='round'%20stroke-linejoin='round'/%3E%3Crect%20x='403'%20y='94'%20width='169'%20height='78'%20rx='12'%20fill='%2315b88a'%20stroke='%2315b88a'%20stroke-width='2'/%3E%3Ccircle%20cx='423'%20cy='94'%20r='15'%20fill='%230a9472'/%3E%3Ctext%20x='422.6666666666667'%20y='99'%20font-family='Segoe%20UI,Microsoft%20YaHei,PingFang%20SC,sans-serif'%20font-size='14'%20fill='%23ffffff'%20text-anchor='middle'%20font-weight='700'%3E3%3C/text%3E%3Ctext%20x='487.33333333333337'%20y='138.0'%20font-family='Segoe%20UI,Microsoft%20YaHei,PingFang%20SC,sans-serif'%20font-size='15'%20fill='%23ffffff'%20text-anchor='middle'%20font-weight='600'%3E粘贴到Excel校对%3C/text%3E%3C/svg%3E)
方法4 用Excel「来自图片的数据」直接转表
Excel 自带图片取数功能，能把表格图直接转成单元格，省去手工分列这一步。
操作步骤
- 打开 Excel，点 数据→来自图片的数据→来自文件，选中那张表格截图。
- 等识别跑完，右侧出现预览面板，核对每个单元格的行列位置对不对。
- 点「审阅」，逐格改掉识别错的数字，重点看小数点和千分位。
- 确认无误后点「插入数据」，表格落到当前工作表。
- 该功能需要 Microsoft 365 版本的 Excel。菜单里找不到这一项，说明当前版本不支持，回到方法2或方法3。
它对合并单元格的处理偏弱，表头有跨行跨列时，插进来的数据容易整体错位一行，插入前先在预览面板里核对首行。
方法5 分块识别后分列逐格校对
整张大表一次识别最容易串行。把它切成几块分别识别，再在 Excel 里分列核算，是最后的兜底办法。
操作步骤
- 按行把大表裁成 3 到 5 小块，每块单独识别，减少跨列串行。
- 粘到 Excel 后点 数据→分列，按制表符或空格把内容拆到各列。
- 用查找替换（Ctrl+H）把误认的字母 O 与数字 0、字母 l 与数字 1 分别纠正。
- 数字列设成「数值」格式，看有没有整列左对齐的文本型数字，改完再核对合计。
- 逐格比对原图的小数点位置，缺位的在 设置单元格格式→数值 里把小数位数补成 2 位。
'/%3E%3Crect%20x='28'%20y='64'%20width='544'%20height='52'%20rx='10'%20fill='%23ffffff'%20stroke='%23dbe3ec'%20stroke-width='1.5'/%3E%3Crect%20x='28'%20y='64'%20width='8'%20height='52'%20rx='4'%20fill='%230a9472'/%3E%3Crect%20x='44'%20y='76'%20width='28'%20height='28'%20rx='6'%20fill='%230a9472'%20opacity='0.16'/%3E%3Ctext%20x='58'%20y='95.0'%20font-family='Segoe%20UI,Microsoft%20YaHei,PingFang%20SC,sans-serif'%20font-size='14'%20fill='%230a9472'%20text-anchor='middle'%20font-weight='700'%3E1%3C/text%3E%3Ctext%20x='86'%20y='95.0'%20font-family='Segoe%20UI,Microsoft%20YaHei,PingFang%20SC,sans-serif'%20font-size='15'%20fill='%231f2d3d'%20text-anchor='start'%20font-weight='700'%3E图片层%3C/text%3E%3Ctext%20x='560'%20y='95.0'%20font-family='Segoe%20UI,Microsoft%20YaHei,PingFang%20SC,sans-serif'%20font-size='13'%20fill='%235b6b7b'%20text-anchor='end'%20font-weight='400'%3E重截并去噪点%3C/text%3E%3Cpath%20d='M294%20118%20l6%206%20l6%20-6'%20fill='none'%20stroke='%235b6b7b'%20stroke-width='2'%20stroke-linecap='round'%20stroke-linejoin='round'%20opacity='0.45'/%3E%3Crect%20x='28'%20y='128'%20width='544'%20height='52'%20rx='10'%20fill='%23ffffff'%20stroke='%23dbe3ec'%20stroke-width='1.5'/%3E%3Crect%20x='28'%20y='128'%20width='8'%20height='52'%20rx='4'%20fill='%2315b88a'/%3E%3Crect%20x='44'%20y='140'%20width='28'%20height='28'%20rx='6'%20fill='%2315b88a'%20opacity='0.16'/%3E%3Ctext%20x='58'%20y='159.0'%20font-family='Segoe%20UI,Microsoft%20YaHei,PingFang%20SC,sans-serif'%20font-size='14'%20fill='%2315b88a'%20text-anchor='middle'%20font-weight='700'%3E2%3C/text%3E%3Ctext%20x='86'%20y='159.0'%20font-family='Segoe%20UI,Microsoft%20YaHei,PingFang%20SC,sans-serif'%20font-size='15'%20fill='%231f2d3d'%20text-anchor='start'%20font-weight='700'%3E识别层%3C/text%3E%3Ctext%20x='560'%20y='159.0'%20font-family='Segoe%20UI,Microsoft%20YaHei,PingFang%20SC,sans-serif'%20font-size='13'%20fill='%235b6b7b'%20text-anchor='end'%20font-weight='400'%3E分块逐行提取%3C/text%3E%3Cpath%20d='M294%20182%20l6%206%20l6%20-6'%20fill='none'%20stroke='%235b6b7b'%20stroke-width='2'%20stroke-linecap='round'%20stroke-linejoin='round'%20opacity='0.45'/%3E%3Crect%20x='28'%20y='192'%20width='544'%20height='52'%20rx='10'%20fill='%23ffffff'%20stroke='%23dbe3ec'%20stroke-width='1.5'/%3E%3Crect%20x='28'%20y='192'%20width='8'%20height='52'%20rx='4'%20fill='%2360cfaf'/%3E%3Crect%20x='44'%20y='204'%20width='28'%20height='28'%20rx='6'%20fill='%2360cfaf'%20opacity='0.16'/%3E%3Ctext%20x='58'%20y='223.0'%20font-family='Segoe%20UI,Microsoft%20YaHei,PingFang%20SC,sans-serif'%20font-size='14'%20fill='%2360cfaf'%20text-anchor='middle'%20font-weight='700'%3E3%3C/text%3E%3Ctext%20x='86'%20y='223.0'%20font-family='Segoe%20UI,Microsoft%20YaHei,PingFang%20SC,sans-serif'%20font-size='15'%20fill='%231f2d3d'%20text-anchor='start'%20font-weight='700'%3E校对层%3C/text%3E%3Ctext%20x='560'%20y='223.0'%20font-family='Segoe%20UI,Microsoft%20YaHei,PingFang%20SC,sans-serif'%20font-size='13'%20fill='%235b6b7b'%20text-anchor='end'%20font-weight='400'%3E分列后逐格核对%3C/text%3E%3C/svg%3E)
核对时先看合计。合计对得上，说明小数点大多没错；对不上，从差额反推是哪一格出的问题，比从上往下逐行看快得多。
常见问题
图片文字提取后数字串行、错位到别的列怎么办？
先看粘贴进来的是制表符还是空格。点 数据→分列，按空格或制表符拆开，把错位的那格拖回本列，再核对这一行的合计。
PowerToys 文本提取器快捷键 Win+Shift+T 按了没反应怎么设置？
打开 PowerToys，左侧选「文本提取器」，看开关是不是关着，再看快捷键一栏是否显示为「未分配」。被输入法占用时点一下输入框，按下新的组合键即可生效。
表格截图识别后小数点丢失，Excel 里怎么批量校对回来？
先把数字列设成「数值」格式，位数不对的进 设置单元格格式→数值，把小数位数定成 2 位；再用合计反推，逐个改掉缺位的那几格。
OneNote 右键「复制图片中的文本」是灰色的怎么解决？
这个菜单项只在图片被选中时可用。点一下图片，等四周出现控制点再右键；图片被裁得只剩几个字时，重新插入一张完整截图。
Excel「来自图片的数据」菜单找不到，是哪个版本才支持？
它属于 Microsoft 365 的功能。点 文件→账户，看到「Microsoft 365 应用版」才有这一项；显示 Office 2019 或 2021 的版本没有这个菜单。
推荐阅读
表格图片转文字图片文字提取工具表格OCR识别校对软领Windows优化大师 
提示