Open an XLSX File in Google Sheets

Choose this method when the XLSX file is already in Drive or when you want to edit it in Google Sheets while keeping it in Microsoft Office format.

1. Open Google Drive.
2. If necessary, upload the XLSX file by selecting New > File upload. Google provides separate instructions for uploading files to Drive.
3. Wait for the upload to finish.
4. Right-click the XLSX file.
5. Select Open with > Google Sheets.

The workbook may open in Office editing mode. When it does, you’re editing the XLSX file rather than a native Google Sheets file.

If you’re already working in Google Sheets, you can import the XLSX from a blank spreadsheet:

1. Open a blank Google spreadsheet.
2. Select File > Import.
3. Open the Upload tab.
4. Select the XLSX file or drag it into the dialog.
5. Follow the import prompts to place the workbook in the intended spreadsheet.

Before confirming the import, review the destination carefully. Replacing a spreadsheet isn’t the same as inserting imported sheets into an existing file. Google describes the available options in its spreadsheet import documentation.

If the workbook opens in Office editing mode and you want a native file, select:

File > Save as Google Sheets

A native copy is useful when you need Google Sheets-specific sharing or editing features. Because conversion creates a separate file, changes to the Google Sheets copy won’t automatically synchronize with the original XLSX.

Keep the original workbook until you’ve completed the checks below. If Excel-specific behavior is essential, retain the XLSX as the control file.

Before using the workbook for reporting, forecasting, or reconciliation, confirm that its structure, calculations, and data are intact.

Confirm its structure and presentation

Compare the opened file with the source XLSX:

• Confirm that every expected sheet is present and named correctly.
• Inspect merged cells, number formats, conditional formatting, charts, and print-related layouts.
• Check that dates represent the intended dates rather than text or shifted values.
• Make sure currencies, percentages, and decimals retain the correct units.
• Select representative formula cells and inspect the formula bar. Verify that they contain formulas rather than pasted values or errors.
• Recalculate critical totals independently. A matching grand total alone doesn’t prove that every row or formula is correct.

If dates were interpreted using the wrong regional convention, review File > Settings > Locale. Changing the locale can affect the entire spreadsheet, so compare the results with the source workbook afterward.

Reproduce the template control check

In the supplied Open & Verify sheet:

• Set the review date in H8.
• Use A11:I20 for the record ID, date, supplier, item, category, quantity, unit price, discount, and decimal tax rate.
• Enter the totals displayed in the opened XLSX in K11:K20.
• Add explanations or follow-up actions in N11:N20.
• Preserve the prefilled calculations and statuses in columns J, L, and M.

The verified baseline contains six synthetic purchase records. Its expected totals are:

378.88 + 180.00 + 648.00 + 133.88 + 304.56 + 178.00
= 1,823.32

The totals copied from the XLSX are:

378.88 + 180.00 + 648.00 + 133.87 + 304.56 + 180.00
= 1,825.31

The batch difference is therefore:

1,825.31 - 1,823.32 = 1.99

The focused check is record PO-1006:

Quantity:       2
Unit price:    $89.00
Discount:       $0.00
Tax rate:        0%
Expected total: 2 × $89.00 = $178.00
Imported total: $180.00
Difference:     $2.00
Status:         Review

This verified result contains five Match rows and one Review row, while Ready to use? displays No. Record PO-1004 differs by -$0.01 but remains Match under the template’s one-cent tolerance.

Unused rows don’t produce blank calculation results. J17:J20 and L17:L20 return 0, while M17:M20 returns Unused. These results distinguish unused capacity from missing inputs.

After you correct K16 from 180 to 178, that row’s difference changes to 0 and its status becomes Match. The batch then shows six matches, no exception rows, and a Ready to use? value of Yes. Its imported total becomes $1,823.31, leaving a -$0.01 aggregate difference caused by the accepted one-cent variance on PO-1004.

If Open with > Google Sheets is unavailable, first confirm that the upload has finished and that you have permission to access the file. You can also try File > Import > Upload.

When formulas are missing or display errors:

1. Compare the affected cells with the original XLSX.
2. Inspect the formula bar to determine whether the formula changed or became a static value.
3. Check named ranges and references to other sheets or workbooks.
4. Keep the calculation in Excel if it relies on an Excel-specific feature that hasn’t been validated in Google Sheets.

If formatting changes, correct it in the native copy and keep the original XLSX as a reference. Pay particular attention to currency formats, decimal precision, dates, merged ranges, conditional formatting, and charts.

When you can’t save the workbook, verify its ownership, your editing permission, and your access to Drive. Request access from the owner if necessary.

Once the workbook is open in Google Sheets, ModelMonkey can use the active spreadsheet, sheet, and range context to read ranges, search content, inspect formula errors, and help analyze or organize the data.

For this example, select Open & Verify!A4:N20 and request:

Check this range for formula errors and summarize rows marked Review, Needs input, or Invalid source. Do not change any cells.

ModelMonkey can assist with the review, but it doesn’t open or convert the XLSX automatically. Check its output against the source workbook. If you later request an edit and the workflow presents a preview, review the proposed cells before proceeding.

For further cleanup after conversion, see Google Sheets Data Cleaning for Finance.