HT201279: Numbers '09: Exporting a spreadsheet in Excel format

Learn about Numbers '09: Exporting a spreadsheet in Excel format
patfromclio

Q: convert Numbers file to Excel format

When I convert my Numbers file to Excel format, each worksheet name is appended with "Table - 1". 

Each subsequent conversion adds another "Table - 1" to the name of every worksheet as well.

How do I stop this from happening?

iPad, iOS 5

Posted on Jun 14, 2012 8:47 AM

Close

Q: convert Numbers file to Excel format

  • All replies
  • Helpful answers

  • by Jerrold Green1,

    Jerrold Green1 Jerrold Green1 Jun 14, 2012 11:57 AM in response to patfromclio
    Level 7 (30,001 points)
    Jun 14, 2012 11:57 AM in response to patfromclio

    Pat,

     

    The suffix identifies which table that particular Excel worksheet is representing, in this case, Table 1. If you had a Numbers sheet called Sheet 1 with a Table 1 and a Table 2, you would get two Excel worksheets; Sheet 1 Table 1 and Sheet 1 Table 2. If you don't like "Table 1", give your table a more likeable name.

     

    Jerry

  • by Badunit,

    Badunit Badunit Jun 14, 2012 2:57 PM in response to patfromclio
    Level 6 (11,705 points)
    iTunes
    Jun 14, 2012 2:57 PM in response to patfromclio

    If you are exporting then importing repeatedly, it will keep appending these things to the names.

     

    Numbers document with two sheets, both with a single table called "Table 1" will get exported as two Excel worksheets: "Sheet 1 - Table 1" and "Sheet 2 - Table 1". It creates a separate Excel worksheet for every table and names each with the sheet and table name.

     

    Reimporting this to Numbers will result in a Numbers document with a sheet called "Sheet 1 - Table 1" and another called "Sheet 2 - Table 1" and both will contain a single table called "Table 1".  It imports each Excel worksheet as a Numbers Sheet and creates a table for each called "Table 1".

     

    It really doesn't work well to import & export repeatedly. Much better to use one app or the other.