Every industry has tools of its trade. Rembrandt had brushes, Mario Batali has spatulas, and You (an Every industry has tools of its trade. Rembrandt had brushes, Mario Batali has spatulas, and You have Google spreadsheets. Spreadsheets aren’t just for accountants; they do vastly more than mathematics. Just like sitemaps and wireframes, spreadsheets are a type of data strategy. A well-designed spreadsheet can help you manage teams, define goals, and even map out complicated processes.
Find more and more time for play in your day by learning these 10 practical Google Spreadsheet uses for your next marketing and web project.
Read Also: WordPress As A SaaS Application Platform
10 Ways We Use Google Spreadsheets at RoosBix
My coworkers often laugh at me for my reliance on spreadsheets, but the design is about solving Your colleagues can laugh at you for your reliance on spreadsheets, but the design is about solving issues! Google spreadsheets are cruelly customizable, hosted in the cloud for easy entry by anyone, and can be designed to solve almost any trouble. From content brainstorming to scheduling to data visualization, spreadsheets mean business.
1. Scheduling – To ensure that we give each client the time they deserve, we carve our days into “blocks.” Each person is assigned one client for the morning and one client for the afternoon. We try to schedule client meetings into their coordinating blocks and identify clear objectives for each work block to keep productivity as high as possible.
2. Gantt Charts – There’s no more useful tool than a Gantt chart to demonstrate how tasks overlap. Spreadsheets make it easy to visualize how resources are assigned and with a small in-line commenting you can change a Gantt chart into a status report.
3. Approvals – We iterate, a lot. Spreadsheets help us organize client approvals when there are multiple versions from which to choose. For example, when we designed Adventure.com, we created over 60 PSDs over the span of 12 weeks of design. We used a spreadsheet to document client approvals and link back to the correct version so our developers knew which file to reference.
4. Goal Definition – Defining clear goals is perhaps one of the toughest parts of a project. Completing a spreadsheet of the HEART Framework with Goals-Signals-Metrics articulates better objectives that are meaningful and user-centered.
5. Content Audit – Content is king. When conducting a content audit it’s essential to consider the target persona, which stage of the funnel (or user’s journey) the content is for, the content format, and the effectiveness of each piece of content. Using a well-formatted content audit sheet can make this important task a breeze and help you achieve even greater results with your next revision.
6. Content Preparation – It can take a long time for a design PSD to be built into a Content Management System. Use a spreadsheet to create a form that will help your copywriter understand how a design comp is transformed into CMS fields like Headlines, Subheadlines, Description, CTA, etc. Trust me, this will exponentially speed content entry when the system is finally ready. Finally, once the CMS is available… use color-coding to indicate which entries have been transferred.
7. Dashboard Reports – Everyone loves data visualization. Turn data extracts into a wealth of data with beautiful charts and graphs for your executives. Designing data visualizations can also help to develop meaningful insights from a load of hard-to-handle data.
8. Feedback Forms – Garnering meaningful feedback can be a challenge. For example, you may be interested in how someone feels when looking at a site or if they were able to achieve a specific task. A form (made from a spreadsheet) can help steer people in the right direction and prevent comments like “make it pop.”
9. Calendar / Planner – Keeping track of campaigns can be a daunting task. We use a spreadsheet to plan and track our activities. One especially useful tab in our free marketing calendar template organizes UTM tags to increase the fidelity of our marketing attribution to ensure we do more of what works, and less of what doesn’t.
10. Competitive Assessment – Using a spreadsheet can help you cite specific examples of strengths, weaknesses, and other notes. Divide and conquer to quickly review an entire website or marketing campaign.
8 Google Spreadsheet Features
If you’re feeling nerdy, inspired, or empowered… make your next spreadsheet even better by using some of these features.
1. Data Validation – This handy feature allows you to create a dropdown list inside of a cell. Depending on the complexity of your data, you can set this in-line or in a separate worksheet. You can also decide whether you want to allow users to freestyle (and flag it) or simply reject data that isn’t in the list of choices.
2. Conditional Formatting – On our Marketing Calendar we highlight things that “Need Review” or are “Ready for Assets”. This is a great feature for calling out important items to a team that may only be concerned with a few things in your spreadsheet.
3. Concatenation – Have you ever wanted to splice two things together? Concatenation is exactly what you need; it takes two fields and combines them into one. You might use this to convert First_Name and Last_Name into Full_Name. A prime example of how we append UTM tags to shorter and easier-to-understand base URLs to create trackable URLs that we use in our social status updates and marketing campaigns.
4. Comments, especially +mentions – You can tag someone by adding +email_address into the comment. This will notify them of the fact that you need their eyes on your comment. Once they’ve responded you can just mark the comment as resolved to clean up the interface. Don’t worry, the comment history is still accessible!
5. Make a Copy – There’s no need to start from scratch. If you’re planning to reuse a document, just make a copy and you can adjust permissions, keep or change the content, and modify it as you see fit. This is a great way to share a template without worrying about compromising the sanctity of the original.
6. Charts and Graphs – It’s all too easy to become overwhelmed by rows and rows of data. Converting stats into charts and graphs can help you make a more convincing argument to up the budget and it makes it easier to spot changes in trends.
7. Functions – Admittedly, functions are for the brave (and technical) at heart – but they’re also really powerful. Functions afford savvy marketers an opportunity to perform on par with software developers by manipulating data and performing calculations.
8. Protected Sheets – Sharing is caring. But opening up your spreadsheet could result in someone accidentally deleting an important formula or critical pieces of data. Protecting a range of cells, or an entire sheet will help you sleep better at night because your hard work can’t be compromised.
5 Design Tips for Your Next Google Spreadsheet
Hopefully, by now you’re convinced that spreadsheets are a valuable marketing tool. But that still leaves the challenge of getting people to actually pay attention to them! A great-looking document may help.
Here are a few tips to create an eye-catching spreadsheet:
1. Middle alignment – Aligning text to the middle (vertical) of the cells helps greatly improve the overall readability of the spreadsheet by separating the text from the gridline. This is a simple step. Do this before you start entering any content.
2. Consistent cell width and row height – Most of our sheets are designed at 35px tall rows, with Arial 10pt font. This is flexible and requires very little effort to maintain. Cell width depends on the content but you can use the “wrap text” button to prevent text from bleeding outside of the visible cells.
3. Removal of excess rows and columns – Spreadsheets can get unwieldy. Help your users out by removing the unnecessary rows and columns. Once your content is loaded, delete the empty cells. (MAC HINT: Highlight the cell or row label then CMD+SHIFT+ARROW to highlight all remaining rows then right-click to delete.)
4. Choose a good color scheme – Color palettes are important. Try to use one row from the color picker to maintain consistency. Personally, I like the 4th row down.
5. Freeze rows and columns – Sometimes spreadsheets get unwieldy! Freezing rows and/or columns can keep headers in view and allow a user to scroll through the rest of the sheet without losing important context.