Sheetgo Blog

Your go-to resource for all things spreadsheet related

Merge Dropbox files: how to combine multiple Excel files

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...

read more
Project tasks distribution in spreadsheets

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...

read more
Track changes in Excel files: How to record historic values

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...

read more
How to seamlessly connect spreadsheets in Dropbox

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...

read more
Multiple employee timesheet distributions in spreadsheets

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...

read more
Control every department budget in spreadsheets

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...

read more
How to split Google Sheet into multiple sheets

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...

read more
How to split an Excel sheet into multiple worksheets

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...

read more
How to record data in Excel to Google Sheets historically

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...

read more
How to convert an Excel File to Google Sheets

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...

read more
How to connect Excel to Google Data Studio

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...

read more

Subscribe to Sheetgo Blog