If your Google Sheets file won't upload to Force24, leftover formatting could be the cause. This article shows you how to clear the formatting and how to save your sheet as a compatible .xlsx file.

How do I clear the formatting in Google Sheets?

  1. Select your data. You will usually want to clear the formatting for the whole sheet. To select everything, press Ctrl + A (Windows) or Cmd + A (Mac).All data selected in a Google Sheets document
  2. Clear the formatting. Click Format in the top menu, then choose Clear formatting from the drop-down. This removes things like fonts, colours and text alignment from the selected cells.The Clear formatting option in the Format menu

Good to know

There is also a keyboard shortcut for this. Select your cells and press Ctrl + \ (Windows) or Cmd + \ (Mac).

How do I save my sheet as an .xlsx file?

To make sure your file is in the right format for Force24, download your sheet as a .xlsx file:

  1. Open the File menu in the top left corner.
  2. Go to Download and select Microsoft Excel (.xlsx).

Downloading a Google Sheet as a Microsoft Excel (.xlsx) file

This downloads a compatible version of your file, which you can then upload to Force24 in the Data Upload section of the platform.

Still need help?

If you are still seeing issues or errors when uploading your file, get in touch through the live chat in the bottom right corner of your Force24 platform. Our team will be happy to help.