Arrow left
Back to guides
Google Sheets Tips

How to Open an XLSX File in Google Sheets

How to Open an XLSX File in Google Sheets

This article will teach you how to open an XLSX file in Google Sheets. This will allow you to open an Excel spreadsheet file in your Google Sheets workbook for use. 

The first step in opening an XLSX file in Google Sheets is to open your Google Sheets workbook and locate the “File” tab at the top of your spreadsheet. 

File Tab Google Sheets

Once you have clicked “File”, you will select “Import” from the resulting drop down menu. 

Import File in Google Sheets

This will allow you to select your desired XLSX file and import it into your Google Sheets workbook. You must then decide where to put your spreadsheet data.

Your next financial spreadsheet could be right here!
100+ spreadsheet templates, from FP&A to tax planning.
Free Spreadsheet Templates

You can either create an entirely new spreadsheet for the data, insert a new sheet that will be populated with the data, or replace all the data on the sheet you are currently on with the data from your XLSX file. Since we are using a blank workbook in this example, we will select “Replace spreadsheet” and click “Import data”. 

Import XLSX File in Google Sheets

The resulting sheet should include all of your XLSX file data which you can now freely edit and use in Google Sheets. 

XLSX File Imported into Google Sheets

Level up your Google Sheets skills with our FREE LiveFlow Academy
Basic and intermediate classes live now! Earn your certificate today.
Enroll in LiveFlow Academy

Other Ways to View Data in Google Sheets

There are many different types of files you are able to open and view in Google Sheets. This is a great way to use stored data and create visuals and deliverables from large data sets.

One of the best ways to create deliverables from large data sets is to use LiveFlow to import your financial data from QuickBooks! In addition to QuickBooks automation, we offer numerous financial templates to help you effortlessly display and use financial data. To learn more, book a demo.

The world's top businesses trust LiveFlow to automate their financial reporting
We turn Quickbooks Online data into a live FP&A dashboard in Sheets FAST!
Book a Demo

Learn how to do this step-by-step in the video below 👇

Automate financial reporting with LiveFlow

Want to eliminate manual updates of your Excel & Google Sheets models?

Yes, show me how

Need help?

Our team is here to help you any time between 9am and 10pm EST.
Check Icon
Email us at:

Liked this article? Then you'll love the ones below