Google Sheets is a spreadsheet, just like Microsoft Excel.

Google表格是一個電子表格，就像Microsoft Excel一樣。

Most people associate it with calculating numbers. But Google Sheets is actually great for organizing your ideas, making lists, even creating a low-fidelity prototype.

大多數人將其與計算數字相關聯。 但是Google表格實際上非常適合組織您的想法，列出清單，甚至創建低保真原型。

When I come up with an idea for a product or a design concept, I want to capture that initial vision in my head by writing it down in text, or visualizing it in sketches.

當我提出有關產品或設計概念的想法時，我想通過將其寫下來以文字或以草圖進行可視化來捕捉最初的想法。

Once my vision is written down as a statement, a sketch, or a description of some sort, I need to further break it down into a set of high-level features in order to turn that vision into an actionable product requirement or a design brief to formulate a project.

一旦將我的愿景記錄為聲明，草圖或某種形式的描述，我就需要將其進一步分解為一系列高級功能，以便將該愿景轉化為可行的產品要求或設計摘要制定一個項目。

I found that this whole initial process, from a vision to a high-level feature set, then to a low-fidelity prototype can be done fairly efficiently in Google Sheets.

我發現從愿景到高級功能集再到低保真原型的整個初始過程可以在Google表格中高效完成。

In this article, I’d like to share this process in Google Sheets with you, taking a portfolio website as an example.

在本文中，我想以一個投資組合網站為例，與您分享Google表格中的此過程。

1.愿景和用戶故事 (1. Vision and user story)

• First I write down my vision in Google Sheets document. Since I’m taking a portfolio website as an example, I start describing what kind of portfolio site that I want to create.
  首先，我在Google表格文檔中寫下我的愿景。 由于我以投??資組合網站為例，因此我開始描述我要創建哪種投資組合網站。
• Because my portfolio website’s users are recruiters and hiring managers, it’s a good idea to put myself in their shoes, and write down a user story from their perspective.
  因為我的投資組合網站的用戶是招聘人員和招聘經理，所以最好讓自己陷入困境，并從他們的角度寫下用戶故事。

2.愿景到功能集 (2. Vision to feature set)

• As soon as I write down my vision and a user story from a user’s perspective, I start generating a feature set — all the things that I need to have in my portfolio website. A spreadsheet structure makes it super-easy to create and edit such a list.
  從用戶的角度寫下我的愿景和用戶故事后，我便開始生成功能集-我的投資組合網站中需要的所有東西。 電子表格結構使創建和編輯這樣的列表變得非常容易。
• Once I write down all the features/content that I can think of, I prioritize those in an order.
  寫下所有可以想到的功能/內容后，便會按順序排列優先級。

3.功能設置到頁面 (3. Feature set to pages)

• As soon as I have a list of features and content, I start thinking how these should be distributed across multiple pages of my portfolio website.
  一旦有了功能和內容列表，我就開始思考如何在我的投資組合網站的多個頁面上分配這些功能和內容。

• I create a new column called Pages, and assign an appropriate page for each feature and content that I listed.

  我創建一個名為Pages的新列，并為列出的每個功能和內容分配一個適當的頁面。

4.頁面到主菜單 (4. Pages to main menu)

• These pages become main menu items.

  這些頁面成為主菜單項。

• I create another column called Main menu, and put pages in an order that I want to have in the main menu of my site.

  我創建另一個稱為“ 主菜單”的列，然后將頁面按順序放置在網站的主菜單中。

At this point I have an overall information architecture of my portfolio website, in forms of a main menu, and a list of features and content with assigned pages for each.

至此，我有了我的投資組合網站的總體信息體系結構，以主菜單的形式顯示，并且列出了功能和內容列表，并為每個功能分配了頁面。

5.創建每個頁面 (5. Creating each page)

• Now it’s time to create each page of my site using a tab feature. Tabs are perfect for creating separate pages of my prototype still within the same Google Sheets document.
  現在是時候使用選項卡功能創建網站的每個頁面了。 選項卡非常適合在同一Google表格文檔中創建原型的單獨頁面。
• I copy and paste corresponding elements for each page from feature/content list, which I already created and organized in the first tab of Google Sheets document. Below screenshots shows a sequence of creating new pages in new tabs.
  我從功能/內容列表中復制并粘貼了每個頁面的相應元素，該列表已經在Google表格文檔的第一個標簽中創建和組織。 以下屏幕截圖顯示了在新選項卡中創建新頁面的順序。

6.鏈接頁面 (6. Linking pages)

• Once all the pages are created as separate tabs within the Google Sheets document, I copy and paste the main menu to the home page.
  在Google表格文檔中將所有頁面創建為單獨的標簽后，我將主菜單復制并粘貼到首頁。
• I insert a link to each main menu item by grabbing a URL of each page, which is a different tab in the same document.
  我通過獲取每個頁面的URL插入到每個主菜單項的鏈接，該URL是同一文檔中的不同選項卡。
• I copy and paste the main menu with all the inserted links to other pages.
  我復制并粘貼主菜單，并插入所有指向其他頁面的鏈接。
• I add a highlight to a corresponding main menu item in each page to represent the selected status.
  我在每個頁面中的相應主菜單項上添加了一個突出顯示，以代表所選狀態。

Now I have a clickable low-fidelity prototype so that I can test and evaluate the overall structure of my portfolio website, before moving forward with creating a high-fidelity design or building the actual portfolio site on a website-building platform such as Wordpress.

現在，我有了一個可點擊的低保真原型，以便在繼續進行高保真設計或在諸如Wordpress之類的網站構建平臺上構建實際的投資組合站點之前，可以測試和評估投資組合網站的整體結構。

The beauty of this prototype is that it’s fast, and I can stay razor-focused on my very vision without being distracted by all the visual treatments.

該原型的優點在于速度快，而且我可以保持剃須刀專注于自己的視野，而不會被所有的視覺處理所干擾。

Before jumping into UX design/prototyping tools or a site-building platform to start building a website, it’s probably a better idea to focus on my vision and high-level idea first to see if it makes sense overall.

在進入UX設計/原型工具或網站構建平臺以開始構建網站之前，最好先關注我的視野和高層次的想法，看看它在總體上是否有意義。

Because, as soon as I start diving deep into a UX design tool, my attention could easily be taken away by all the user interface details that I can play around with, such as colors, sizes, typography, white spaces, iconography, images, videos and so on.

因為，一旦我開始深入研究UX設計工具，我的注意力就可以很容易地被我可以使用的所有用戶界面細節所吸引，例如顏色，大小，版式，空白，圖標，圖像，視頻等。

The fact that it’s a spreadsheet meant for numbers somehow seems to offload my desire and obligation to make it look good as I would when using any design/prototyping tools. It’s an interesting psychological effect.

它是電子表格的意思，實際上以某種方式似乎減輕了我的欲望和義務，使它看起來像使用任何設計/原型工具時一樣。 這是一種有趣的心理作用。

This approach works great even for non-designers too, such as product managers, product owners, business owners, entrepreneurs, and engineers.

即使對于非設計人員，例如產品經理，產品所有者，企業所有者，企業家和工程師，這種方法也適用。

Because Google Sheets is a simple spreadsheet, most people know how to use it. And it’s free.

由于Google表格是一個簡單的電子表格，因此大多數人都知道如何使用它。 而且是免費的。

Google Sheets allows anyone to freely mock up their ideas into a simple low-fidelity prototype without visual distractions and having to worry about learning how to use fancier UX prototyping tools. I found it quite useful.

Google表格可以讓任何人將他們的想法自由地模擬成一個簡單的低保真原型，而不會造成視覺干擾，也不必擔心學習如何使用更高級的UX原型制作工具。 我發現它非常有用。