Numbers to Excel and reverse help?

Discussion in 'Mac Apps and Mac App Store' started by buntonn, Jan 20, 2017.

  1. buntonn macrumors newbie

    buntonn

    Joined:
    Oct 3, 2016
    Location:
    Essex, UK
    #1
    Hi I have put together a spreadsheet in Numbers that I am sharing with someone who is on Windows. So I export it to excel and send to him. However now I need it that he can also update the spreadsheet. Is there any utilities like Automator or Hazel etc I could use so when I drop a numbers file into a directory it is converted to make an Excel copy, and also the other way around to convert an Excel file to a Numbers file?

    Thanks,
    Nick
     
  2. cdcastillo macrumors 6502a

    cdcastillo

    Joined:
    Dec 22, 2007
    Location:
    The cesspit of civilization
    #2
    I also prefer numbers over excel for my spreadsheet needs, but If you need to work with someone who doesn't have numbers, I see 2 simple solutions:

    1. You use excel from the beginning, and the problem goes away.
    2. You both use google docs, avoiding the hassle that comes from continually converting one format to another.
     
  3. ianrip macrumors 6502

    ianrip

    Joined:
    May 30, 2010
    Location:
    work:Oyu Tolgio, Home:LOS, From Scotland G15
    #3
    He can use numbers on his window PC, using the iCloud share feature with a IE browser, its a similar feature to google docs and windows One drive
     
  4. maflynn Moderator

    maflynn

    Staff Member

    Joined:
    May 3, 2009
    Location:
    Boston
    #4
    I don't believe there are tools to automatically convert Numbers spreadsheets to Excel. May you can use Automator to create your own script, I'm not sure though.

    In the end, I think you'll be better off using Excel, due to the conversion differences and since Numbers cannot handle all of what Excel can do so a Excel to Numbers import may drop some non-compatible formulas or other things. Also rendering may be off between the two apps, i.e., it looks different. If you're collaborating with another person, you'll be better off using the same tool.
     

Share This Page