Translate languages in Google Sheets

Tips
Sheets
Translate languages in Google Sheets

Tips

Drive
Gmail
Docs
Overdrive
Calendar
Sheets
Sites
Chrome
- How to remove the Reading list button from Chrome
Contacts
Slides
Chat
Meet
Forms
Keep
More...
- Admin
- Android
- Images
- iOS
- Migration
- Scripts
- Security

Sign in with Google

Or

We won't share your email address with any third-parties.
Please see our Privacy Policy for further information.

About Us

G Suite Tips is provided by the team at Overdrive. We’re passionate about Google Workspace and everything Google, so we’re delighted to share the latest insights, tips and tricks with you.

Latest Tips

How to pre-fill a Google Form

Google Forms is great tool for surveys, quizzes or simple data collection. But did you know that you can share a pre-filled form with others? Here’s how to pre-fill your Google Form with default values: 1. Open the Form you want to pre-fill. 2. Click on the 3 dots on the top right to access the Form menu. 3. Select “Get pre-filled link” 4. Type in the default values in the right fields for example, here, we have set: - Number of licenses to “1” - License type to the 1st choice “GSuite user license” - Comments to “Thanks” 5. Click the Get link buttom form the bottom of the form. 6. Click “Copy link” from the notification pop-up. You will get a URL to the Form to fill including the values you set-up as the default ones. Here’s an example - you can see that some fields are already set. If you need to change the default values, you can log into your Google account and use the same link to edit the form. Tip from Shared Contacts for Gmail®
Enable and use Google Chat from Gmail

Google aims to integrate the most popular Google Workspace productivity apps in the Gmail app for a more uniform user experience. This move will end the need to keep multiple tabs open for different tasks. With Google Chat you can communicate directly with people, create temporary group conversations, or start more formal group chats called Spaces. The latter ones can be used for department communication, project management, event planning, or any other elaborate operation. You can access all these features from within Gmail, without having to keep a separate Chat tab open. To enable Google Chat in Gmail, on the web, go to Settings and then navigate to the Chat and Meet tab. Select Google Chat and click Save Changes. To enable Google Chat in Gmail, on mobile, go to Settings, tap on your work or school account and then switch on the Chat toggle. Now you can access the Google Chat features from within the Gmail app on web and mobile. On the web, you can find chats and spaces in the left side panel but if you prefer a bigger window, go to Settings > Chat and Meet and then select Right Side of the inbox. On mobile, once you’ve enabled Chat, you will see two new tabs at the bottom of the screen for chats and spaces. Now you can save time and stay productive by using only the Gmail app.
How to Convert Excel files to Google Sheets

Google Sheets and Excel are the most popular spreadsheet programs and no matter which one your organisation uses, you will inevitably have to deal with both formats. Fortunately, Google Workspace users can easily edit and even convert Excel spreadsheets. Google Sheets offers support for the following Excel file formats: .xlsx .xls .xlsm .xlt .csv .tab .tsv .ods When you work with a spreadsheet file in Google Drive, it’s a good idea to convert it into a Google Sheet. This will allow you to take advantage of all the features available in Sheets and share the file with your colleagues who are more familiar with the app. Google Sheets can also be easily shared with just the link to anyone to view them or make changes. The easiest way to convert an excel file to Sheets is by enabling automatic conversion. To do this, open Google Drive and go to Settings. Then, check the Convert uploaded files to Google Docs editor format box. If you wish to convert Excel files manually, here are the steps you need to follow: Start by uploading the Excel file (.xlsx, .xls, .csv, etc.) to Google Drive. You can drag and drop the file from your PC or Mac, or click the New button from the top left corner, and then File upload. Once your upload is complete, double click on the file to open it. Notice the Microsoft Excel file format next to the tile. From the menu, go to File and then click on Save as Google Sheets. A copy of your spreadsheet will open in a new tab. This new copy is your Google Sheet version of the original Excel file. The Google Sheet version is saved in the same folder as the Excel file. Once you’ve done a quick check to make sure the conversion didn’t alter the data, you can go ahead and delete the original Excel file from your Drive to avoid confusion.

Powered by Overdrive

Tips
- Drive
- Gmail
- Docs
- Overdrive
- Calendar
- Sheets
- Sites
- Chrome
- Contacts
- Slides
- Chat
- Meet
- Forms
- Keep
- More...
Community
Tools
Services
- Development
- Training
Add-on Apps
Blog

Translate languages in Google Sheets

Translate languages in Google Sheets

How to pre-fill a Google Form

Enable and use Google Chat from Gmail

How to Convert Excel files to Google Sheets