johnfromplattsmouth

Q: How to Use Excel Spreadsheet as Numbers Template

Just bought a MacBook Air 13 with Numbers, and want to use an Excel spreadsheet I have as a template to turn it into a Numbers spreadsheet.  I know that my Mac can read the Excel spreadsheet, but have no idea how to turn it into Numbers.  Hope someone can provide some direction.  If it makes any difference, it is an expense tracking spreadsheet.  If there are good pre-made apps that would do that, would like to get pointed to them, too.

 

I am disappointed to read that Numbers does not have the Excel freeze pane feature, but hope I can get Numbers to do something halfway similar.  My "features" needs are sufficiently few that I don't see buying Excel for the Mac just to get that (and I particularly don't want any other of the Office suite programs). 

Thanks for some direction!

Posted on Aug 29, 2016 1:49 PM

Close

Q: How to Use Excel Spreadsheet as Numbers Template

  • All replies
  • Helpful answers

  • by SGIII,Apple recommended

    SGIII SGIII Aug 29, 2016 5:56 PM in response to johnfromplattsmouth
    Level 6 (10,622 points)
    Mac OS X
    Aug 29, 2016 5:56 PM in response to johnfromplattsmouth

    johnfromplattsmouth wrote:

     

    I know that my Mac can read the Excel spreadsheet, but have no idea how to turn it into Numbers. 

     

    Have you tried launching Numbers, choosing File > Open and navigating to the .xls or .xlsx document to open it? Depending on the formulas used, that is successful with many Excel documents.

     

    it is an expense tracking spreadsheet.  If there are good pre-made apps that would do that, would like to get pointed to them, too.

     

     

    In Numbers go to File > New in your menu and choose the 'Personal Budget' template.  It is good at tracking expenses and also is a good example of how to put Numbers to work.

     

    Numbers has its own table-centric style and it's best not to just think of it as an Excel clone.  Excel 2016 for the Mac, by the way, is excellent too and would be a good choice if you were working with large datasets. For personal projects I think you'll find Numbers has its charms and will make some things easier than what you may have been doing in Excel.

     

    SG

  • by FoxFifth,

    FoxFifth FoxFifth Aug 29, 2016 6:33 PM in response to johnfromplattsmouth
    Level 7 (25,643 points)
    iPhone
    Aug 29, 2016 6:33 PM in response to johnfromplattsmouth

    Another option that you may want to investigate is LibreOffice. It is more like Excel than Numbers and it is free. https://www.libreoffice.org/

  • by SGIII,

    SGIII SGIII Aug 29, 2016 6:46 PM in response to johnfromplattsmouth
    Level 6 (10,622 points)
    Mac OS X
    Aug 29, 2016 6:46 PM in response to johnfromplattsmouth

    Should add that if the 'Personal Budget' Numbers template doesn't fit your expense tracking needs (it's pretty nice, sleeker than most Excel templates I've seen, and a lot of people here can explain how to customize it with your own categories, etc.) and if you really like the Excel template you found, then my advice would be to go with Excel. It's reasonably priced these days and constantly updated so you don't have to depend on volunteer availability in an open source project to plug security holes or smooth out rough edges in the interface.  Also both Numbers and Excel work great on iOS mobile devices, with easy syncing to/from your Mac.

     

    SG

  • by Yellowbox,Apple recommended

    Yellowbox Yellowbox Aug 30, 2016 10:05 AM in response to johnfromplattsmouth
    Level 6 (10,430 points)
    Mac OS X
    Aug 30, 2016 10:05 AM in response to johnfromplattsmouth

    Hi John,

    Numbers does not have the Excel freeze pane feature, but hope I can get Numbers to do something halfway similar.

    Going "halfway" you can set some rows and columns as Header Rows and Header Columns in a table

    Screen Shot 2016-08-31 at 2.47.36 AM.png

    You can have up to 5 Header Rows or Header Columns in a table, then you can "Freeze" them

    Screen Shot 2016-08-31 at 2.56.04 AM.png

    Be aware that Numbers slows down with multiple Header Rows, Header Columns and Footer Rows in a table.

    Please reply with your overall aim. The what, not the how .

     

    Regards,

    Ian.

  • by johnfromplattsmouth,

    johnfromplattsmouth johnfromplattsmouth Aug 30, 2016 6:43 PM in response to Yellowbox
    Level 1 (4 points)
    iWork
    Aug 30, 2016 6:43 PM in response to Yellowbox

    Yellowbox, I had a short beginning tutorial on the Mac today and brought up this subject.  My tutor went to help and found the same instructions under table that you linked above.  Up until I saw your post I was convinced that Numbers now had full, Excel-like freeze panes.  Now, with the one to five numbers of places limit, not sure how it is going to work.  Must try it, I guess.

     

    As to what my aim is, I have an expenses spread sheet.  Across the top I have dates from 1 to 31 (or 30), and down the side I have expense categories and subcategories.  I would like to be able to see the date at the top (so I get the right date) and go about 30 rows down to gasoline and see that I am on gasoline ( as oppose to car insurance, etc.).  So my goal is precision in making entries.
    ,

  • by SGIII,

    SGIII SGIII Aug 30, 2016 7:12 PM in response to johnfromplattsmouth
    Level 6 (10,622 points)
    Mac OS X
    Aug 30, 2016 7:12 PM in response to johnfromplattsmouth

    johnfromplattsmouth wrote:

     

    Across the top I have dates from 1 to 31 (or 30), and down the side I have expense categories and subcategories.  I would like to be able to see the date at the top (so I get the right date) and go about 30 rows down to gasoline and see that I am on gasoline ( as oppose to car insurance, etc.).

     

    You mean something like this?

     

    Screen Shot 2016-08-30 at 10.04.08 PM.png

     

    That's how Numbers tables work by default when you've defined a Header Row and a Header Column.   You don't have to go to the menu to Freeze Panes the way you do in Excel.  Unlike Excel, tables are central to the Numbers design (Excel has tables too, but they're harder to use).

     

    I do urge you to have a look at the 'Personal Budget' template at File > New.  Working with a 30-column table is, I think, probably doing things the hard way.

     

    SG