How To Convert Excel To Google Sheets With Formulas


Convert Excel To Google Sheets With FormulasPin

Here are a bunch of handy tips and tricks for converting Excel files to Google Sheets, as well as some useful formulas you can use to augment and edit data within your spreadsheets.


Regardless of the fact that you use Google Drive, or specifically Google Sheets, for your spreadsheet files, you will almost certainly still receive an Excel file at some point.

You may choose to preserve it as an XLS document and work with it that way in some instances, especially if whoever you’re sending on to or back to has requested so, or, you might wish to convert an Excel to Google Sheets with all of the formulas included.

Not everybody has made the leap to the cloud just yet. Some companies prefer being offline, some people prefer the familiarity of the software they’ve used since 1987, or more modern versions of it like Microsoft 365, and some people simply don’t know Google Sheets exist.

Why Convert Excel To Sheets?

Convert Excel To Google Sheets With FormulasPin

Google Sheets has a number of benefits over its Microsoft counterpart.

  1. Efficiency

Users may edit, organize, and analyze many types of data using Google Sheets. It supports collaborations, and many users may edit and format files in real-time, with a revision history to monitor any changes made to the spreadsheet.

  1. Tools

Users may utilize the Explore tool to ask questions, generate charts, visualize data, construct pivot tables, and color-code the spreadsheet. For example, if you’re creating a monthly budget and have entered all of your costs into the spreadsheet, you may utilize the Explore tool to find out how much food, travel, and clothing cost.

  1. Offline as well as online

You can still edit your Sheets offline if you’d prefer, however, some of Google’s beneficial tools will not work without being connected to the internet, such as the aforementioned Explore tool.

Offline editing is available in Google Sheets, and users may modify the spreadsheet on their computers or mobile devices. To allow offline editing for Google Sheets and other Google applications on the desktop, users must use the Chrome browser and install the “Google Docs Offline” Chrome extension.

Users must utilize the Google Sheets mobile app for Android and iOS, which supports offline editing while using a mobile device.

  1. Compatibility

Google Sheets accepts a variety of spreadsheet file formats and types, including:

  • .xlsx
  • .xls
  • .xlsm
  • .xlt
  • .xltx
  • .xltxm
  • .ods
  • .csv
  • .tsv

Google Sheets allows users to open, modify, save, and export spreadsheets and document files in all of these different format types.

  1. Integration

Other Google products, such as Google Forms, Google Finance, Google Translate, and Google Drawings, may all be connected with Google Sheets.

If you want to construct a poll or questionnaire, for example, you may enter the questions in Google Forms and then simply and efficiently import the form straight into your Google Sheets file.

How To Convert Excel To Google Sheets

It’s simple to convert an existing Excel spreadsheet to Google Sheets – just take the actions outlined below.

  1. Head to your Drive and create a new Google Sheets files. Open your Sheet, then select File, then Import.
  2. Click Upload and follow the on-screen instructions to upload or drag and drop it. Sheets documents contain two crossed lines, while Excel documents have an x.
  3. Choose the best choice in the Import file box, then click Import data.

Importing your Excel file to Google Sheets this way will include all of the formulas contained in the original Microsoft Excel file.

Handy Google Sheets Formulas

If you’re searching for a Google Sheets cheat sheet to help you ramp up your spreadsheet skills, you’re in luck. We’ve gathered a few common formulas you can use to both speed up your operations and have your documents looking professional. Here are 6 of our favorites:

  1. SUM, COUNT, AVERAGE

SUM allows you to tally any number of columns or rows by selecting or entering them in. For example, =SUM(A2:A9) sums all values between A2 and A9, and so on. 

COUNT is a function that counts the number of cells in an array that contains a number value. This might be useful in detecting whether or not someone has paid a bill, or in other database scenarios. 

AVERAGE does exactly what it says on the tin: it calculates the average of the values you enter.

  1. VLOOKUP

‘Vertical Lookup’ is what it means. It’s a function in Sheets that allows you to search for a certain value in a column in order to retrieve a value from another column in the same row. =VLOOKUP is the syntax for this formula.

  1. MAX & MIN

These functions are very simple to use; simply write in the column or row of numbers you wish to search, then follow the function’s instructions, and it will return the MAX or MIN value, depending on the function. =MAX(A1:A10), for example, returns the highest numerical value within these rows.

  1. IF STATEMENTS

IF statements come in handy in a variety of scenarios. If a case is valid or false, you may use this method to output text. =IF(B1>D2, “GOOD”, “BAD”), for example, where B1>D2 is the case, “GOOD” if the output is true, and “BAD” if the output is false. 

Alternatively, =IF(C4>B4, “Over Budget,” “Within Budget”); where the IF function says IF (C4 Is Greater Than B4, return “Over Budget,” else return “Within Budget.”

  1. SUMIF, COUNTIF, AVERAGEIF

These Spreadsheet functions are a mixture of the SUM, COUNT, AVERAGE, and IF functions and statements.

So you could type =SUM into SUM (A1:A15, “GOOD”, B1:B13). If the values of A1 through A15 were all GOOD, this would add B1 through B13. You may have noticed that many of these formulae may be stacked on top of one another to build more complicated spreadsheets and actions.

  1. PROPER

PROPER can particularly handy when your database has a lot of strangely formatted text that seems muddled, such as capitalizations in incorrect places. If cell E1 stated “wE lOve spreAdsheets,” you could enter =PROPER(E1) to get “We Love Spreadsheets,” which doesn’t sound quite as sarcastic.


How To Delete Files From Google DrivePin

Google Drive Resource Hub: Learn All The Basics + Pro-Level Tips For Drive

Learn More About Google Drive ↗


Essential Remote Work Gear

External SSD – Regardless of what computer you use, having external storage is essential, especially if you work on the move. With an SSD, you can store and keep all your most important documents in one place and take it with you when you’re on the move. Our current favorite right now is the 2TB OWC Envoy Pro EX. It is outstanding.

Mechanical Keyboard – If you’ve never used a mechanical keyboard before, there’s a bit of a learning curve. But once you’ve gotten used to using one, you’ll never go back to flat, lifeless keyboards like the one on your iMac or MacBook. Our top picks right now are the Keychron C1 ($59) and the VISSLESS V84 ($99); they’re both wireless and feature RGB lighting.

Mouse – A good mouse will last you years at a time. It’ll also stop you from getting RSI on your wrist. I have used a bunch of third-party mouses in the past 24 months but my absolute favorite right now has to be the Logitech MX Master 3. Oh, and it is fully compatible with iOS too, so it’ll work fine on your iPad too.

Latest Smartphone Releases


  • Xiaomi 15S Pro

    The Xiaomi 15S Pro didn’t come with a flashy launch, but it brings some seriously heavy hardware to the table. A custom 10-core chip, Leica-engineered cameras, and one of the brightest displays on the market

  • Samsung Galaxy S25 Edge

    At just 5.8mm thick, it’s one of the thinnest Android phones ever made—but don’t let the slim profile fool you. This phone is all flagship under the hood.

  • Nothing Phone (3a) Pro

    It’s got the same slick design and OLED display, but adds a periscope zoom camera and a 50MP front-facing shooter.

  • Nothing Phone (3a)

    The Nothing Phone (3a) nails the formula: give people what they actually want, keep the price low, and make it look cooler than anything else in its class.

  • Motorola EDGE 60 Pro

    With a bold design, flagship-like display, and surprisingly refined camera system, it’s one of the most interesting mid-range phones of 2025.

  • Google Pixel 9

    I’ve been using the Pixel 9 for a few weeks now, and honestly? It nails all the basics—and a bit more. Killer stuff all round!

  • Google Pixel 9 Pro

    I’ve used the Pixel 9 Pro as my daily device, and it’s hands-down the best balance of power, practicality, and photography you’ll find on Android right now.

  • OnePlus 13

    I’ve been using the OnePlus 13 as my daily driver for a few months now—and I’ve got to say, it’s easily one of the best Android phones I’ve tested this year.

  • Xiaomi 15 Ultra

    After using the Xiaomi 15 Ultra for over a week, I can confidently say: this phone is an absolute beast. It’s made for camera nerds, power users, and creators.

  • iPhone 16 Pro Max

    If you’ve been holding out for a truly complete iPhone, the 16 Pro Max delivers—hard. After using it daily, I won't be going back…

  • Google Pixel 9 Pro XL

    Big screen, big battery, and even bigger brains—this is the Pixel to get if you want Google’s best hardware and longest support.

  • Google Pixel 9a

    The Pixel 9a brings Google’s flagship-level smarts to a budget-friendly package, and it’s easily one of the best-value Android phones of 2025.

Best SIM-Only Plans & Deals


  • iD Mobile 1 Month SIM-Only: 108GB

    Another high-data, low-cost option with no contract. 108GB for just £9, full 5G access, and the same goodies you get with 12-month deals.

    +

    Data: 108GB

  • iD Mobile 1 Month SIM-Only: 20GB

    The lowest price option. 20GB for £6 with all the same perks as pricier plans. Great if you don’t use much data and want to save every penny.

    +

    Data: 20GB

  • iD Mobile 1 Month SIM-Only: 110GB

    This plan gives you big data and zero commitment. 110GB for just £10 with all perks intact. If you need more data but want the freedom to cancel, this is the one.

    +

    Data: 110GB

  • iD Mobile 1 Month SIM-Only: 60GB

    More data, same price. For just £8/month, you get 60GB on a no-strings 1-month rolling plan. Ideal for users who stream often but don’t want long commitments.

    +

    Data: 60GB

  • iD Mobile 1 Month SIM-Only: 40GB

    Perfect if you want full flexibility. You get 40GB and all of iD Mobile's perks with no lock-in, annual increases, or setup fees. Great for short-term users.

    +

    Data: 40GB

  • iD Mobile 12 Month SIM-Only: 60GB

    One of the best pound-per-GB plans around. You get 60GB for £8 with £25 cashback, which means you’re effectively paying closer to £6/month. Includes roaming and data rollover.

    +

    Data: 60GB

  • iD Mobile 12 Month SIM-Only: 108GB

    This deal gets you a healthy 108GB of 5G data for less than a tenner, with no upfront costs and £24 cashback. All the perks are included too: data rollover, roaming, and loyalty rewards.

    +

    Data: 108GB

  • iD Mobile 12 Month SIM-Only: Unlimited Data

    This iD Mobile plan doesn’t just compete on price, it’s up there with the best of them. Unlimited everything, a year-long lock-in with no price rises, and £42 cashback straight to your pocket. It’s like getting nearly 3 months free.

    +

    Data: Unlimited, No Speed Caps

  • Mint Mobile 20GB Plan

    If you're looking to save some cash on your bills, this plan is an awesome option. You'll get 20GB of data per month and 20GB hotspot data allowance. For moderate to heavy users, that should be more than enough. I seldom use more than 10GB of data a month, and I'm always using my phone

    +

    Data: 20GB

  • Mint Mobile 15GB Plan

    If you don't use a lot of data, this plan is a great option. You'll get 15GB of data per month and 5GB hotspot data allowance. It's not a lot but for light users, it is likely more than you'll ever need

    +

    Data: 15GB

  • Visible+ Pro Plan

    Visible+ Pro is built for heavy users who want it all: 4K streaming, ultra-fast hotspot speeds, and premium 5G access on Verizon’s best network. No throttling. No compromises. Just pure, high-performance mobile.

    +

    Data: Unlimited

  • Visible+ Plan

    If you’re tired of overpaying for unlimited data, Visible is one of the best alternatives out there—especially right now. For a limited time, you can get Visible’s unlimited plan for just $20/month, and that price is locked in for an entire year when you use code SAVE5 at checkout.

    +

    Data: Unlimited