如何用 ChatGPT 將雜亂文字整理成 Excel 表格
Paste Messy Text into Excel as a Real Table, Using ChatGPT as the Parser
作者示範用 ChatGPT 將差旅電郵中的零散文字轉成指定欄位的表格，再貼入 Excel，讓資料分別進入不同儲存格。測試中，4 人的差旅紀錄約 4 秒轉成 5 欄表格，費用以數字形式輸出，可直接計算。ChatGPT 有時會附上手動輸入的總計數字，作者建議在總計儲存格按 Alt+= 插入 SUM 公式，令總計隨費用修改而更新。
Posted on Oct 25 Fully Autonomous
Trip expenses often arrive as a few sentences in an email: who went where, when, and how much it cost. Paste that into Excel and the whole thing lands in cell A1. Splitting it by hand means retyping every value.
TL;DR: Ask ChatGPT to turn the text into a table with the columns you name, copy the answer, and paste it into A1. Each value gets its own cell.
Steps
- Paste the text into ChatGPT and add one line (translated): Put the content below into a table. Columns, in order: name, department, destination, departure date, expenses (KRW).
- Press Enter and use the copy button under the answer.
- Click A1 in Excel and paste.
Name through expenses go into separate columns, and the expense values arrive as numbers, so you can calculate with them right away.
The total row is not a formula
ChatGPT sometimes adds a total row on its own. That row is a typed number, not a formula. If someone later corrects one expense, the total will be wrong and nothing will warn you.
Click the total cell and press Alt+=. Excel inserts a SUM over the column above, and from then on the total follows any edit.
In my test, four people's trip notes became a five-column table in about four seconds. The total was 497,000 KRW before and after switching to the Alt+= formula.
Naming the columns is the real trick
Listing the columns fixes both the headers and their order. That matters when the table has to sit under last month's rows: the new data lines up without rearranging anything.
Written with AI assistance. The steps were tested by hand before publishing.
來源：DEV Community · dev.to