Format to save spreadsheet?

Discussion in 'Mac Apps and Mac App Store' started by ardchoille50, Mar 9, 2016.

  1. ardchoille50 macrumors 68020

    Joined:
    Feb 6, 2014
    #1
    I'm creating an exercise spreadsheet in LibreOffice 5.0.5.2 on a Linux computer and I'd like to have this spreadsheet available on a Mac. Which format should I save the spreadsheet for it to be available to a Mac? Can the Numbers app on a Mac open any version of a Microsoft Excel spreadsheet?
     
  2. BrianBaughn macrumors 603

    BrianBaughn

    Joined:
    Feb 13, 2011
    Location:
    Baltimore, Maryland
    #2
    Not sure about "any version" or what versions you can Save As in that release of LibreOffice, but I'd be surprised if one or the other didn't work just fine for what you're doing.

    More of a possibility of complications with a complex spreadsheet.
     
  3. ardchoille50 thread starter macrumors 68020

    Joined:
    Feb 6, 2014
    #3
    odf is the default save option. I'm wondering if OS X can open a .odf file in Numbers.
     
  4. simon lefisch macrumors 6502a

    simon lefisch

    Joined:
    Sep 29, 2014
    #4
    Have you tried opening it in Numbers? Best way to find out is to try it out and report back it if worked or not.

    Also, see if Libre Office can save to another format. Sometimes programs can save to multiple format, like Word can do doc/pdf/etc.
     
  5. ardchoille50 thread starter macrumors 68020

    Joined:
    Feb 6, 2014
    #5
    I don't own a Mac, so I'm unable to test this.
     
  6. simon lefisch macrumors 6502a

    simon lefisch

    Joined:
    Sep 29, 2014
    #6
    Is there a 'save as' in Libre Office? If so, what format options are given?
     
  7. ardchoille50 thread starter macrumors 68020

    Joined:
    Feb 6, 2014
    #7
    The format options given are in the screenshot below:
    lo-formats.png

    I sent myself a few test documents and tried to open them in the Numbers app on my iPhone 6. The only one that opened in Numbers was the .xlsx format (last option in the list). Is the iOS version of Numbers pretty much the same as the OS X version of Numbers? If it will open on the iPhone, will it open on a Mac?
     
  8. simon lefisch, Mar 9, 2016
    Last edited: Mar 9, 2016

    simon lefisch macrumors 6502a

    simon lefisch

    Joined:
    Sep 29, 2014
    #8
    I would assume so. I don't use Numbers since I have MS Office, however I would think that if you were able to open it on your iPhone it should open on a Mac. If you want to post a link to that doc, I can test it for you. You can leave it blank or have a few samples in it.

    Otherwise, maybe someone else who uses Numbers on both iOS and OS X can chime in to confirm.

    Edit: I actually don't have Numbers on my Mac, sorry. Thought it was installed.
     
  9. ardchoille50, Mar 9, 2016
    Last edited: Mar 9, 2016

    ardchoille50 thread starter macrumors 68020

    Joined:
    Feb 6, 2014
    #9
    No worries.
     
  10. GerritV macrumors 65816

    Joined:
    May 11, 2012
    #10
    So then .xlsx is the right choice. If Numbers on iOS can open the file, so will Numbers on MacOS.
    I wonder why .csv didn't work for you though.
     
  11. ardchoille50 thread starter macrumors 68020

    Joined:
    Feb 6, 2014
    #11
    Ah, thank you for that confirmation. As far as the .csv format, I might have done something wrong.. I'm just now learning about spreadsheets and LibreOffice.
     
  12. Fishrrman macrumors G4

    Fishrrman

    Joined:
    Feb 20, 2009
    #12
    I just opened LibreOffice 5.x.

    I created a new spreadsheet, then saved it to the desktop in .odf format (Open Doc).

    I then launched Numbers, and brought up the "open" dialog.

    Numbers does not recognize the .odf ss as an "openable" file.

    I returned to LibreOffice and saved the SS into "Microsoft Excel 2007-2013 XML" .xlsx format.

    Numbers is able to recognize and open the file when saved this way.
     
  13. ardchoille50 thread starter macrumors 68020

    Joined:
    Feb 6, 2014
    #13
    Thank you for this information, very helpful.

    It seems that .xlsx is a standard of sorts, while .odf (Open Document Format) is not.
     
  14. BobertKennedy macrumors member

    BobertKennedy

    Joined:
    May 3, 2014
    #14
    XLSX is a "standard" format which happens to be just one of many. It also happens to be the default format for MS Excel. Since Numbers and Libre Office can open this format, the best practice would be to save your files in XLSX format for maximum compatibility.
     
  15. ardchoille50 thread starter macrumors 68020

    Joined:
    Feb 6, 2014
    #15
    Yeah, I'm going through and saving all of my .ods/.odt files in .xlsx format. Thank you :)
     
  16. BobertKennedy macrumors member

    BobertKennedy

    Joined:
    May 3, 2014
    #16
    Saving as XLSX is not as intuitive as it should be: to save to XLSX, select FILE>EXPORT TO>EXCEL, and select XLSX format under ADVANCED OPTIONS. Also, keep in mind that if you are going to open the file in Excel (or another spreadsheet application), your formatting my be interpreted differently - but this is easy to fix.
     
  17. ardchoille50 thread starter macrumors 68020

    Joined:
    Feb 6, 2014
    #17
    Oh, I was using Save As, I didn't even think about Export. Yeah, I've already noticed that the backgrounds of some of my cells have been cleared. I'll have to learn which settings are compatible with .xlsx.
     

Share This Page