> ## Documentation Index
> Fetch the complete documentation index at: https://kb.snagr.co.uk/llms.txt
> Use this file to discover all available pages before exploring further.

# 如何從模板導出資料？

### 從模板導出資料

<img src="https://mintcdn.com/snagr/cq3DLfKmhQlF8uo8/images/direct/1521433586616-Screen-Shot-2018-03-19-at-12.26.03-PM.png?fit=max&auto=format&n=cq3DLfKmhQlF8uo8&q=85&s=7223586c2abfeba683e22b965a94728d" alt="從模板" width="132" height="173" data-path="images/direct/1521433586616-Screen-Shot-2018-03-19-at-12.26.03-PM.png" />

此功能要求管理員提前設置導出模板。 該模板以Excel格式提取所需的表單域和映射到所需的列。

創建模板時，請按照以下步驟操作。

<img src="https://mintcdn.com/snagr/Fc-Qgss-VatVIL0b/images/uploads/123693-if_ic_tv_48px_352186.png?fit=max&auto=format&n=Fc-Qgss-VatVIL0b&q=85&s=06b23e0223986004fba7bbb6aa8febb3" alt="if ic tv 48px 352186" width="20" data-path="images/uploads/123693-if_ic_tv_48px_352186.png" /> **電腦版**

點擊 檢查 ＞ 搜索檢查項目 ＞ 批量下載 ＞ 從模板

<img src="https://mintcdn.com/snagr/cq3DLfKmhQlF8uo8/images/direct/1521436445874-electric-light-bulb_1f4a1.png?fit=max&auto=format&n=cq3DLfKmhQlF8uo8&q=85&s=c8c0f922694296671395e06c06f3db9d" alt="electric light bulb 1f4a1" width="24" data-path="images/direct/1521436445874-electric-light-bulb_1f4a1.png" />如有需要可先利用搜索特定表格來縮細導出範圍！

<img src="https://mintcdn.com/snagr/cq3DLfKmhQlF8uo8/images/direct/1521442366975-Website-Form-Mode_Tra.001.jpeg?fit=max&auto=format&n=cq3DLfKmhQlF8uo8&q=85&s=43543ff5ee7c00b52bbb5229723a340d" alt="Website Form Mode Tra.001" width="1024" height="768" data-path="images/direct/1521442366975-Website-Form-Mode_Tra.001.jpeg" />

選擇所需的模板，然後按**匯出**。

<img src="https://mintcdn.com/snagr/cq3DLfKmhQlF8uo8/images/direct/1521442567442-Website-Form-Mode_Tra.002.jpeg?fit=max&auto=format&n=cq3DLfKmhQlF8uo8&q=85&s=a36c5a6029d440546a3ef92dc2faa309" alt="Website Form Mode Tra.002" width="1024" height="768" data-path="images/direct/1521442567442-Website-Form-Mode_Tra.002.jpeg" />

<img src="https://mintcdn.com/snagr/cq3DLfKmhQlF8uo8/images/direct/1521443022200-Website-Form-Mode_Tra.003.jpeg?fit=max&auto=format&n=cq3DLfKmhQlF8uo8&q=85&s=1e68a9377a0c1ee03b75457b91ed6ce6" alt="Website Form Mode Tra.003" width="1024" height="768" data-path="images/direct/1521443022200-Website-Form-Mode_Tra.003.jpeg" />

成功下載Excel CSV檔案了！

***

<u>**- 上一個版本 -**</u>

但還沒結束喔，需要把**CSV檔轉成EXL檔**才行。

<img src="https://mintcdn.com/snagr/cq3DLfKmhQlF8uo8/images/direct/1521443343223-Mar-19-2018-14-22-36.gif?s=32d9e31b6b7ce0f6a8783415236c4605" alt="helpjuice production/uploads/upload/image/3577/direct/1521443343223 Mar 19 2018 14 22 36" width="1260" height="710" data-path="images/direct/1521443343223-Mar-19-2018-14-22-36.gif" />

開啟新Excel ＞ Data ＞ From Text，然後選取你剛剛下載的CSV檔。

<img src="https://mintcdn.com/snagr/cq3DLfKmhQlF8uo8/images/direct/1521443424032-Website-Form-Mode_Tra.004.jpeg?fit=max&auto=format&n=cq3DLfKmhQlF8uo8&q=85&s=1ca5982959a6a4ff026ef2f9b668a3b7" alt="Website Form Mode Tra.004" width="1024" height="768" data-path="images/direct/1521443424032-Website-Form-Mode_Tra.004.jpeg" />

點擊選擇 Delimited ＞ Next

<img src="https://mintcdn.com/snagr/5Ct0kGva8U2RUSvy/images/direct/1521443446468-Website-Form-Mode_Tra.005.jpeg?fit=max&auto=format&n=5Ct0kGva8U2RUSvy&q=85&s=dd119cffa7a5d56e7ced5229006a8410" alt="Website Form Mode Tra.005" width="1024" height="768" data-path="images/direct/1521443446468-Website-Form-Mode_Tra.005.jpeg" />

取消選取 Tab，選擇 Other，然後輸入 "|"（垂直線）

<img src="https://mintcdn.com/snagr/cq3DLfKmhQlF8uo8/images/direct/1521436445874-electric-light-bulb_1f4a1.png?fit=max&auto=format&n=cq3DLfKmhQlF8uo8&q=85&s=c8c0f922694296671395e06c06f3db9d" alt="electric light bulb 1f4a1" width="24" data-path="images/direct/1521436445874-electric-light-bulb_1f4a1.png" />注意| 是一個垂直條，它在鍵盤上看起來像這樣：

<img src="https://mintcdn.com/snagr/5Ct0kGva8U2RUSvy/images/direct/1521444271954-Screen-Shot-2018-03-19-at-3.24.16-PM.png?fit=max&auto=format&n=5Ct0kGva8U2RUSvy&q=85&s=14024bfb78eb0c29e1df4ded0337f1dd" alt="Screen Shot 2018 03 19 at 3.24.16 PM" width="147" height="126" data-path="images/direct/1521444271954-Screen-Shot-2018-03-19-at-3.24.16-PM.png" />

按 Finish > OK。

<img src="https://mintcdn.com/snagr/5Ct0kGva8U2RUSvy/images/direct/1521443618692-Website-Form-Mode_Tra.006.jpeg?fit=max&auto=format&n=5Ct0kGva8U2RUSvy&q=85&s=d74b03e5c5894ee60ff98c45e5df0d76" alt="Website Form Mode Tra.006" width="1024" height="768" data-path="images/direct/1521443618692-Website-Form-Mode_Tra.006.jpeg" />

<img src="https://mintcdn.com/snagr/5Ct0kGva8U2RUSvy/images/direct/1521443641672-Website-Form-Mode_Tra.007.jpeg?fit=max&auto=format&n=5Ct0kGva8U2RUSvy&q=85&s=3280cdafec35e9dac566f5b8b99d8e74" alt="Website Form Mode Tra.007" width="1024" height="768" data-path="images/direct/1521443641672-Website-Form-Mode_Tra.007.jpeg" />

完成！你現在已經轉換了文件。

從

<img src="https://mintcdn.com/snagr/5Ct0kGva8U2RUSvy/images/direct/1521443795789-Screen-Shot-2018-03-19-at-3.16.20-PM.png?fit=max&auto=format&n=5Ct0kGva8U2RUSvy&q=85&s=bf596273f7ee2839e7b793bbc271daf8" alt="Screen Shot 2018 03 19 at 3.16.20 PM" width="426" height="316" data-path="images/direct/1521443795789-Screen-Shot-2018-03-19-at-3.16.20-PM.png" />

轉成＞

<img src="https://mintcdn.com/snagr/5Ct0kGva8U2RUSvy/images/direct/1521443821871-Screen-Shot-2018-03-19-at-3.16.08-PM.png?fit=max&auto=format&n=5Ct0kGva8U2RUSvy&q=85&s=3c4b6194d824700b6323df6ef79e0ee3" alt="Screen Shot 2018 03 19 at 3.16.08 PM" width="483" height="297" data-path="images/direct/1521443821871-Screen-Shot-2018-03-19-at-3.16.08-PM.png" />

了！

<img src="https://mintcdn.com/snagr/lG5zeW-JZpPjZFoL/images/uploads/127041-Red_Flag_Emoji.png?fit=max&auto=format&n=lG5zeW-JZpPjZFoL&q=85&s=122220a995f6a719dddaffb5de76ce80" alt="Red Flag Emoji" width="20" data-path="images/uploads/127041-Red_Flag_Emoji.png" /> 了解更多 [如何設置以Excel導出表格資料（模板）？](/zh-hant/forms/export-forms/excel).