2026-06-24r/excel1 赞 · 2 评论1uerwtl
How to automate importing data from XML file?
用 Garmin 手表的 XML 轨迹文件，每次手工把几列数据抄进新工作簿，试过两种办法都不成。
「Currently, I manually import several columns of data (trackpoints) into a new Excel workbook.」
2026-06-26r/excel0 赞 · 9 评论1ug3n85
Manually reconciling bank statements with Excel?
银行对账：手工把流水和 Excel 逐笔勾对，金额、日期、摘要对不上时最耗时间。
「I'm curious how many people here still manually match bank statements against Excel to check if expected payments have come in?」
2026-06-27r/excel12 赞 · 20 评论1uh71l1
Better way to update Excel workbook with many sheets
结构动不了的主工作簿里有 30 个工作表，每次都要逐个滚一遍更新。
「I have a master workbook that I cannot modify structurally. It contains around 30 worksheets (one for each product segment), and each worksheet has a large table with three sections.」
2026-06-29r/excel2 赞 · 5 评论1uiv0rs
Is there an easier way to repeat the same Excel cleanup every month?
每月收到同一套系统的 CSV 导出，重复做去重、去空格、拆列、合并、统一日期格式。
「Every month I receive CSV exports from the same system. I always end up doing the same steps.」
2026-07-08r/excel5 赞 · 16 评论1uqr7qu
Get data from file name text string?
别的办公室每月更新一张表，想用 Get Data 自动导入，但对方文件名里带着日期。
「I am trying to use the Get Data feature to automatically import data from a worksheet another office updates monthly.」
2026-07-13r/excel3 赞 · 6 评论1uv67k4
Pulling data from two files in the same folder, the source files have multiple tabs and naming conventions that float with the date. Each source tab has up to 380 rows, I just need three datapoints from the row listing a specified date.
每天要从两个源文件里取三个数据点，源文件名和文件夹路径都随日期滚动。
「I need to pull data off two source files to the rec file on a daily basis.」
2026-07-13r/excel5 赞 · 4 评论1uvlflj
How do I use the Data>From Web>URL function or an easy copy-paste to get this into XLS?
想把行情网站的表弄进 Excel，粘贴后 15 列挤成一列，直接抓也抓不下来。
「Every time I try and copying and pasting to a spreadsheet from here, it all goes on 1 column instead of the 15 that I need it to go on. I'm also unable to scrape this.」
2026-07-28r/excel2 赞 · 8 评论1v8ri4u
How to compare two ERP export pick lists in Excel 2010 when items are added, reduced, or cancelled?
ERP 导出的拣货单每天两版，要手工比对新增、减少和取消的条目。
「I need some advice on handling inventory pick lists exported from our ERP system in Excel 2010.」
2026-08-05r/excel5 赞 · 4 评论1vg34zs
Collating multiple pdfs data into one excel sheet
多个 PDF 要汇总进一个总表，希望按一下按钮就更新，现在用 VBA 硬撑。
「I need to collate multiple pdfs into one master excel sheet for data collection. It needs to be automated in a way that the master excel sheet is updated by just pressing a button.」
2026-08-06r/excel5 赞 · 11 评论1vhdpyf
Can this task be made easier or automated?
新岗位做数据协调：数据不干净，要人工清洗后逐条录进 CRM，还得自己判断该进哪个位置。
「My first tasks are basically data cleaning and data entering into a CRM. The problem is that the data isnt very clean.」
2026-08-11r/googlesheets0 赞 · 5 评论1vldlxs
Help automating stock tracker (excel to sheets)
每周收到约 60 份送货单，手工复制粘贴进库存跟踪表，既有耗时也有录入错误。
「They are then sent to me and i have to manually enter (copy paste) them into my stock tracker sheet. I receive around 60 a week so can be time consuming sometimes as well as mistakes that happen sometimes.」
2026-08-19r/excel9 赞 · 33 评论1vssvam
Word tables to Excel
SharePoint 上 60 个格式相近的 Word 表格，粘进 Excel 会散成多列，要一个个处理。
「I have about 60 word files on a SharePoint site. Each of the word files is a table, similarly formatted, with similar columns. My goal is to get the data within the columns into an excel file.」
2026-08-24r/excel1 赞 · 15 评论1vx3r3h
Can excel take out data from every file in a folder even tho the files aren't the same template?
想从文件夹里每一份人工填写的文件里捞出指定数据，合并到另一个工作簿。
「Im wondering if excel can read and take out data and paste it in a seperate excel workbook. The files are not the same template because they are made manually.」
2026-08-26r/excel3 赞 · 8 评论1vz28vq
Should I import monthly reports into my tracker workbook, or leave the reports separate?
月度报表用 XLOOKUP 和 SUMIFS 拉进跟踪表，最后还得手工粘贴成数值。
「I use XLOOKUP and SUMIFS in my month-to-month tracker workbook to pull data from monthly reports. I paste values at the end to keep things clean.」
2026-08-28r/excel2 赞 · 5 评论1w0t79e
How do I Save a Sheet as Excel or TSV for Amazon Inventory?
每天更新总库存后，要逐个工作表另存为 Amazon 后台要的 TSV 格式。
「At the end of each day, I update the master and do Save As for each sheet so I can update our storefronts with the new numbers.」
2026-08-29r/excel55 赞 · 54 评论1w1otwg
I want to know the best way to convert my credit card statement into an Excel
信用卡账单 PDF 手工抄进 Excel，页数多时最费时间——本清单里热度第三的帖。
「The problem is that manually copying the transactions from the PDF into Excel takes a lot of time, especially when the statement has multiple pages.」
2026-09-09r/excel45 赞 · 16 评论1wberau
How can I automate this daily Excel workflow? I’m fairly new to Excel and Power Query.
每天中午前要出的报表，大部分仍靠手工，问怎么用 Power Query 拆解——45 赞。
「I have a daily report that I need to complete before noon, and a large part of the process is currently manual.」
2026-09-13r/excel58 赞 · 39 评论1wevq9i
Need to parse a mountain of tariff PDFs in 2 weeks and IT blocked SQL. Power Query or Python?
两周内解析一大堆关税 PDF，IT 还把 SQL 封了，只能二选一硬扛——58 赞、39 评论，本清单热度第一。
「I am tasked with creating costing for a new product. To do this, I have to extract rate tables from what can only be described as a mountain of tariffs.」
2026-09-14r/googlesheets10 赞 · 19 评论1wfwem2
How are you pulling competitor prices into Google Sheets every week from sites with no API?
每周一花约三小时手工抄竞品价格和商品清单，多数站点没有公开 API，小错字还会搞坏报表。
「Every Monday I spend about three hours manually copying competitor prices and product listings into a Google Sheet. Most of the sites have no public API, so I'm stuck opening pages one by one and pasting the data by hand.」
2026-09-14r/excel4 赞 · 8 评论1wg5yo7
Pulling Latest Data from One Workbook to a Master Workbook
从线上系统导出的生产报表 CSV，每天一行一站，要手工并进保存历史的总表。
「I pull a production report from an online resource. It exports a csv file with a row for each site, each day.」
2026-09-19r/excel12 赞 · 15 评论1wku6z2
Identifying New and Removed Item Numbers from Updated List
每周更新清单要和总表比对，找出新增和移除的料号并留档。
「Goal: Identify new and removed item numbers to update a master list, while keeping a record of new and removed items.」