Spreadsheets: love or hate them, they are part of fashion life, and Microsoft’s Excel program is the answer to most customer spreadsheets. But what if you want to edit a Microsoft Excel .xlsx file on a Mac, iPhone or iPad? Although it is not as simple as opening .docx files in Pages for Mac, it is not very difficult.
You may also like: Editing .pages files on Windows | suggestions for macOS Sierra | How to install Windows on Mac | Share files between Mac and Windows 10
What is an .xlsx file?
Before delving into how to edit .xlsx files on a Mac, iPhone or iPad, let’s first talk about what an .xlsx file is. Simply put, .xlsx is a file extension for the open XML spreadsheet used by Microsoft Excel since 2007. Why resize previous Excel variations? According to many, the explanation behind the change was due to corporate customers: there was a great deal of stress from corporate customers who wanted an open file format that would make the transfer of data between purposes and work techniques a painless process.
But what does this imply for our housing? This means that, in principle, it is easy to open and edit .xlsx files as a result of, regardless of whether it was created and saved with Microsoft Excel, the file must be appropriate with many third-party spreadsheet applications on macOS and iOS.
Read the following: How to open a Word .docx file on Mac, iPad and iPhone
How to edit .xlsx files on Mac
So, how do you edit an .xlsx file on a Mac? Due to the open file format used by Microsoft’s Excel software program, it is surprisingly simple to edit an .xlsx file on a Mac. The best part is that you don’t even have to buy Microsoft Excel for Mac (as part of the Microsoft Office assortment) as a result of Apple’s proprietary spreadsheet software program, Numbers, is suitable for file classification. For those who don’t have numbers or don’t want to buy numbers, there is also a way to use Google Docs – or particularly Google Sheets – to open and edit .xlsx files.
Although we mentioned above that you are not would you like Microsoft Office / Excel for Mac to open .xlsx files on the Mac, Excel remains the target of many spreadsheet customers. It has to do mainly with the familiar consumer interface on Mac and Windows, making it easy to use on each platform. Furthermore, it has to do with the truth that nobody likes to learn to use a new software program if you are used to one more thing.
Obviously, it is extremely simple to edit .xlsx files on your Mac with Microsoft Excel for Mac – open the software program, choose the Browse tab on the left side of the pop-up window that appears and search for the file. Click Open to open it and it is best to be able to edit the file as desired – as long as it is not password protected. Read the following: How to edit PDFs on Mac without spending a dime
Numbers for Mac
Just like opening Microsoft Word files in Pages for Mac, opening Excel files in Sheets for Mac is a painless process as it offers internal assistance for sorting files. And not like Microsoft Office, Numbers is less expensive when you write for $ 19.99 on the Mac App Store, although many other moderate customers find it pre-installed on their Macs. You can double-click the .xlsx file to open it in Pages (except for another common spreadsheet application) or click File> Navigate the Numbers application to open and edit the file.
Read the next: Numbers for Mac evaluation
Google Docs and Sheets
If you don’t have access to Excel or Numbers for Mac, an alternative option is offered: use a mix of Google Docs and Google Sheets in your web browser. The only downside? You may lose some formatting and wording of your unique .xlsx file, as Google’s online spreadsheet software program does not provide the superior tools identical to those of Microsoft Excel.
So, to open the .xlsx file on your Mac with Google Drive and Google Sheets:
- Open your browser, go to the Google Drive website and check in with your Google account, if requested.
- Drag the .xlsx file to Google Drive to add it to Google’s cloud storage platform.
- After importing, right-click the file and click Open with> Google Sheets.
- Google converts the .xlsx file directly into a Google Sheets file, then opens it in a new window, ready for modification.
- When you are able to modify the file, just click File> Download as …> Microsoft Excel (.xlsx).
Read next: Alternatives to Numbers for Mac
How to edit .xlsx files on iPhone and iPad
Editing .slxs files on an iPhone or iPad running on iOS is not as simple as on a Mac; however, it is not possible for both – it simply depends on the applications you need to use. The biggest drawback? Get the .xlsx file on the iOS system, as you want to download it from a website with Safari, or reserve it for an iOS-appropriate cloud storage service like iCloud Drive, Dropbox or Google Drive (requires a little planning anticipated, reasonably than spontaneously works).
The easiest method to open and edit .xlsx files on your iPhone or iPad is, in fact, using the Microsoft Excel application accessible from the App Store. It’s even marked as a free app, so there’s no problem, right? Wrong. Although the app is free to download, customers want an Office 365 subscription to actually use it. If it is one time, you can sign up for the application for a 30-day trial of the service, but when it is not, it is probably best to contemplate the options opposite below.
For those without an Office 365 subscription, we advocate using Numbers for iOS. It’s not as expensive as Numbers for Mac for $ 9.99 on the App Store, however, those who bought a new iPhone model in recent times receive free entry. To use Numbers for iOS, the .xlsx file must already be saved on iCloud Drive or OneDrive, as these are the two cloud storage companies supported by the application. After uploading the file, you can edit it:
- Open Numbers for iOS and tap on Locations in the top left corner and choose iCloud Drive or OneDrive, depending on your particular desire.
- A window should look like the location where you can search your online storage in the online archive. After finding the file, click on it to download it.
- After downloading, it is best to get a pop-up stating that the file is not in Numbers format and opening it will create a reproduction in the application. Tap Continue, after which the tap Continue again.
- Your spreadsheet should now be open in the application, ready for modification. There may also be small formatting points due to the conversion of the file, however, they need to be basically beautiful, reasonably priced.
- When you are able to modify, touch the 3 dots in the top corner of the application and choose Send a copy> Excel and determine how / the place you need to reserve it (by sending an email, saving it in iCloud Drive and so on) against) .).
Read on: Microsoft Office 2016 for Mac purchases on recommendation