Sheetgo Blog
Your go-to resource for all things spreadsheet related
Merge Dropbox files: how to combine multiple Excel files
Dropbox allows you to share spreadsheet files with colleagues and clients instantly — and access them from anywhere. And once your files are stored in the cloud, you can simplify and streamline your work even more. Did you know you can connect Excel files stored in...
Project tasks distribution in spreadsheets
As a project manager, you know how hard it is to keep track of multiple projects and team members. The entire project can only be finished on time if your team members reach the deadlines of each task. This is why you need a system that gives you a clear overview of...
Track changes in Excel files: How to record historic values
Values in Excel files change over time depending on the inputs and the formulas used to calculate results. However, in certain cases, it is useful to have a historic record of said values. In this article, we’ll show you how to track changes in Excel files by...
How to seamlessly connect spreadsheets in Dropbox
Dropbox allows you to share Excel and CSV files with clients and colleagues seamlessly. Centralize all your content in one place while keeping your company’s data secure. With Sheetgo Dropbox integration you can take cloud collaboration to another level by automating...
Multiple employee timesheet distributions in spreadsheets
As a Human Resources manager, you manage multiple employees. Not only their careers, health care, days off, but potentially also their timesheets. A timesheet includes not only the time employees start and end work, but sometimes also a detailed breakdown of their...
Control every department budget in spreadsheets
As a financial controller, one of your main tasks is keeping the company budget under control. To do so, it is necessary to set out a maximum budget per department. Every department has its own fixed expenses, and of course some unplanned ones as well. This is why you...
How to split Google Sheet into multiple sheets
As a manager, you are the owner of a lot of different spreadsheets that contain important information to share with your team members. Google Sheets already provided us with a great solution for this: simply share the spreadsheet, and create a collaborative work...
How to split an Excel sheet into multiple worksheets
Even though Excel workbooks are not the most collaborative spreadsheets to work on, there are some great ways to share data across your entire team — without sharing too much information. Keep confidential data to yourself, and only share what's necessary with your...
How to automatically transfer data from one sheet to another in Excel
Automatically transfer Excel data Organizations that need to regularly transfer data between Excel workbooks can find it to be time-consuming and tedious. We are talking specifically about transferring data from one Excel file —or workbook— to another, meaning between...
How to record data in Excel to Google Sheets historically
Storing our data on either internal or external storage devices for backup is now a thing of the past. We are ushered into the era of Cloud computing technology, where we upload the data and access it from any location or device. Without ever having to worry about...
How to convert an Excel File to Google Sheets
Spreadsheets are a versatile tool for both personal and professional use. People can use them for anything, from mass financial accounting to something simple like personal to-do lists. People usually associate spreadsheets with Microsoft Excel, for some they are...
How to connect 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 need any programming knowledge to pull data from...