How to Convert Numbers File to Google Sheets with CloudConvert
If you use Numbers as well as Google Sheets, you might find yourself in a situation where you need to convert a Numbers file into a Google Sheets document. Whether the Numbers file originated in Numbers on a Mac, iPhone, iPad, or iCloud does not matter, as they’re all the same and you can get them into Google Sheets with a few steps.
Numbers is the Apple spreadsheet app akin to Microsoft Excel and Google Sheets. The default Numbers file format differs from Google Sheets and Microsoft Excel, and if you receive the file as an attachment or on a PC, you might see a .numbers file extension rather than something like a more familiar XLS. Because of this, you may run into some compatibility issues if you get a Numbers file that you need to access elsewhere. But not to worry, as we’ll walk you through steps to convert a Numbers file to a format supported by Google Sheets by using something called CloudConvert.
How to Convert a Numbers File to Google Sheets
You will need to upload the Numbers file to Googleâs servers using Google Drive, so we’ll start there.
- Head over to drive.google.com on your web browser and sign in with your Google account. Once youâre in the Google Drive home page, click on âNewâ located in the left pane.
- Next, choose âFile uploadâ from the dropdown menu and find the Numbers file stored on your computer to upload it.
- Now, the file you uploaded will show up in Google Drive, as shown here. Right-click on the document, click on âOpen withâ in the dropdown menu, and choose âCloudConvertâ. CloudConverter is an online file conversion service thatâs integrated into Google Drive. When you choose CloudConvert, youâll be asked to sign in with your account before youâre able to convert the file.
- Once youâve logged in, youâll be taken to the conversion page. Here, use the dropdown as shown in the screenshot below and choose a file format thatâs compatible with Google Sheets like âXLSâ or âXLSXâ. Make sure youâve checked the option to âSave output files to Google Driveâ too and click on âConvertâ.
- The file you converted will immediately show up in Google Drive. Youâll also have the option to download the file directly from CloudConvert, but since youâre working on Google Sheets, you donât need to. In Google Drive, right-click on the converted document, click on âOpen withâ in the dropdown menu, and choose âGoogle Sheetsâ.
That’s about it, you have converted a Numbers spreadsheet file to a Google Sheets-supported format using CloudConvert.
For what it’s worth, XLS and XLSX are the file formats used by Microsoft Excel, and since those files are supported by Google Sheets, so you’ll be able to share those back and forth easily – and Numbers can open XLS files too.
Another option is available if you have an Apple account, where you can use iCloud.com to convert a Numbers file to XLS or XLSX file formats too. If you don’t happen to have an Apple account, it is pretty easy to create a new Apple ID regardless of what device you use, and it’s basically the login necessary to access the Apple world. But for spreadsheet purposes, you can also use iCloud to quickly open and view the contents of a Numbers spreadsheet from a Windows PC.
To avoid running into platform compatibility issues in the future, you could request your colleagues who use Mac to export the file as an Excel spreadsheet within the Numbers app, and the same can be done via Numbers on iPad and iPhone too.
What do you think of this handy conversion capability in Google Sheets? Did you find another solution? Let us know in the comments what your experiences and thoughts are.
SUPER helpful. Thank you!!!
Thank you so much! Your article helped me finish a work project that had been frustrating me. I appreciate the time you took to write it all out.
Thank you! Really appreciate the helpful article and I’ve used your tips successfully to convert a numbers file to xls.