If you use Microsoft Excel on your Mac, you can save the spreadsheets you create and open them in Numbers, Apple’s spreadsheet app. It’s a handy feature to use in case you can’t access Microsoft’s apps. Every Mac comes with Apple’s iWork apps: Pages (word processor), Numbers (spreadsheet), and Keynote (presentations). And these apps can import Office documents. Here’s how you can open Excel spreadsheets in Numbers, as well as export Numbers spreadsheets for use in Excel. How to import Microsoft Excel spreadsheets into Apple Numbers This procedure works with.xlsx and.xls file formats. You can also import.csv and tab-delimited files.
Launch Numbers (it’s in the Applications folder of your Mac). In the window that automatically opens when you launch the app, navigate to the location of your Excel file. For example, if it’s in Documents, click on the Documents folder in the left sidebar. (You can also click on the File menu and select Open, then navigate to your spreadsheet.) IDG. Once you’ve located your file, select it and click Open. A progress window will appear.
Format cells - Control + 1 (Command + 1). Most people know this as the shortcut for the Format Cells dialog, but you can also use it to format almost anything in Excel, without care about the state of the ribbon. Select visible cells only - Alt +; (Mac: command + shift + Z). The trick to copying only what you see.
IDG. A window may appear, explaining any changes that were made during the import process. The more complicate your Excel spreadsheet (lots of formulas, charts, etc.), the higher the possibility that a change had to be made.
The simpler the spreadsheet, the more your file will resemble what you created in Excel. The Excel file should open in Numbers. Before you start working on your spreadsheet, look it over carefully.
Formatting may have changed, especially with charts. Check to make sure the formulas you are using are intact. There’s always a chance that so much happened during the import that you can’t use your spreadsheet. How to export Apple Numbers files as Microsoft Excel spreadsheets If you’ve been working in Numbers and will eventually return to Excel, you can export your spreadsheet as an Excel file. In Numbers, click on the File menu and move your cursor to “Export to”. A pop-up menu will appear. Select Excel.
IDG. In the Export Your Spreadsheet window that appears next, you can opt to include a summary worksheet and require a password. Click on the Advanced Options, and you can select between.xlsx and.xls file formats. Click Next when you have finished selecting your options.
IDG. Choose where you want to save the file and name it. When you click Export, this will save the file.
On multiple occasions while using WISEflow, it is possible to export lists of user or assessment data to a CSV-file. Here is how to open them on a PC or a MAC. There are different ways to open CSV-files whether you have a older or newer version of Excel.
The two examples below give you two methods shown on both Mac and PC. The method can differ on your specific system and version, but these two examples should give you an idea of how to do the same either way. Mac (Old versions of Excel).
Go to the Data tab and click on From Text and find the.csv file to open. Find the CSV-file you downloaded from WISEflow in your file system and click Get Data. This opens the Text Import Wizard. Make sure that File Origin is set to Unicode (UTF-8). And that the option Delimited is checked off If this is not the case, find, Unicode (UTF-8) from the drop-down menu and check Delimited.
'CSV' stands for 'Comma-Separated-Values', meaning that columns are separated with commas in the file. For Excel to read this and convert them into actual columns, make sure that Comma is checked like below. The preview below shows you how Excel will read the data. Play around with separators (e.g. Comma, semicolon) until the preview is correct.
It is possible that there are personal identification numbers (CPR) in one or more of the columns. Therefore, click the given column and set Column data format to Text, otherwise any 0's in front of the number might be deleted. Click Finish and OK to finalise the import.
PC (Newer versions of Excel). Go to the Data-tab and select From Text/CSV. Select the file you want to import from your file system and press Get Data. This will open the following window:.
Make sure that File Origin is set to Unicode (UTF-8). Make sure that Delimiter is set to Comma. Click Load.