Sheetgo Blog

Your go-to resource for all things spreadsheet related

How to connect Excel to Google Data Studio

How to connect Excel to Google Data Studio

How to import data from Excel to Google Data Studio Google Data Studio is a powerful visual reporting tool that allows you to transform a sea of raw data into engaging and interactive dashboards and charts. The user-friendly pre-built data connectors mean you don't...

read more
How to upload Excel to Google Sheets

How to upload Excel to Google Sheets

Microsoft Excel has dominated the spreadsheet world for decades, but many users are now moving to Google Sheets. Sheets is great for collaboration. As it’s an online application, anyone can access a spreadsheet via their browser, multiple users can work in the same...

read more
How to convert Google Sheets to Excel automatically

How to convert Google Sheets to Excel automatically

Do you frequently need to convert Google Sheets spreadsheets to Excel format? When it comes to spreadsheet software, opinion is fairly divided on which option is best. Google Sheets is rapidly growing in popularity. Because it's online, Sheets is incredibly flexible,...

read more
How to create a Pivot table in Google Sheets

How to create a Pivot table in Google Sheets

What are pivot tables? Pivot tables are a powerful tool to help you extract and analyze the information you need from a large data set. They're an easy way to "slice and dice" data in spreadsheets: in other words, to filter and then group that data. For example, you...

read more
How to create a dashboard in Google Sheets

How to create a dashboard in Google Sheets

Get actionable insights with a data dashboard Think of the last time you needed to check a KPI or another important metric for a report. Searching through a sea of raw data in multiple tabs and multiple spreadsheets is incredibly frustrating. Especially when you need...

read more
Top 5 free Google Sheets inventory templates

Top 5 free Google Sheets inventory templates

Whether you are a small eCommerce business or a major warehouse, inventory matters. You need to have accurate inventory information to make sure you are making the right top-level business decisions. Too much inventory can lead to profit loss, while not enough can...

read more
Inventory lending template in Google Sheets

Inventory lending template in Google Sheets

Does a department in your company lend items internally? Perhaps you have a library in your school that lends books to students. Or an IT department that lends computer equipment to employees. Maybe you run a hire business where you rent items to customers, such as...

read more
Inventory management template in Google Sheets

Inventory management template in Google Sheets

What is inventory management? Inventory management means tracking your stock levels in real-time. The process involves monitoring every item that either comes in or goes out of your inventory. An inventory is essentially a list of all the items, goods, merchandise and...

read more
Expense tracker template in Google Sheets

Expense tracker template in Google Sheets

Why track expenses? Keeping on top of your team's spending is a key part of budgeting for your business. Rather than waiting to collect a pile of receipts at the end of the month (and possibly getting a nasty shock at how much your team have spent) it's good to be...

read more
Gradebook template in Google Sheets

Gradebook template in Google Sheets

If you're a teacher, the time-consuming task of monitoring student grades can be very overwhelming, especially when you've got multiple classes and you're grading students on multiple assignments. Many teachers rely on manual systems (and their excellent memory!) to...

read more
Top 5 free Google Sheets sales templates

Top 5 free Google Sheets sales templates

We all know that that making spreadsheets look nice can be a tedious task. On top of that, it’s difficult to come up with big-picture ideas to figure out how the entire spreadsheet should function, what you want it to do, and what you want it to show. Fortunately, we...

read more
Business unit plan template in Google Sheets

Business unit plan template in Google Sheets

All companies encompass several business units, such as accounting, sales, marketing, R&D, production and HR. When you want to measure your company's overall performance, it's important to analyze the performance of each individual business unit separately. Two of...

read more

Subscribe to Sheetgo Blog