Pages to Numbers

Discussion in 'Mac Basics and Help' started by shelley31, Jun 9, 2014.

  1. shelley31 macrumors newbie

    Joined:
    Apr 13, 2013
    Location:
    Buckinghamshire
    #1
    I am sure it must be on here somewhere but can anyone tell me/point me to a video that shows how to export data from pages to numbers?:(
     
  2. maflynn Moderator

    maflynn

    Staff Member

    Joined:
    May 3, 2009
    Location:
    Boston
    #2
    Did you try cut and paste or right click the file and do an open with?
     
  3. Tumbleweed666 macrumors 68000

    Joined:
    Mar 20, 2009
    Location:
    Near London, UK.
    #3
    If the data is in a table in pages you can just cut and paste.
    Otherwise it would depend what form its in and I doubt there would be a generic video.
    If you post your specific problem here or in the mac apps page you'll probably get some quick help but give some examples of what the data you are trying to convert looks like.
     
  4. shelley31 thread starter macrumors newbie

    Joined:
    Apr 13, 2013
    Location:
    Buckinghamshire
    #4
    Cut & Paste

    Hi Guys

    I did try cut & pasted but it doesn't comply with a Numbers format. I then tried resizing boxes but again no go
     
  5. Fishrrman macrumors G4

    Joined:
    Feb 20, 2009
    #5
    Be aware that before you do the cut-n-paste, to arrange your data in Pages into the proper format so that it can easily "drop into" a Numbers worksheet (or into ANY spreadsheet app).

    That is to say, you should use tab characters to define breaks between cells, and a carriage return to define when to drop down to the next row.

    You probably want to get rid of any additional formatting in the Pages document first, as this may not transfer across properly. All you want to see are tabs and carriage returns in addition to the text itself.

    You also need to make invisible formatting characters visible in Pages, so that you can closely examine the document before you attempt to copy/paste the data -- to avoid unintended results...
     
  6. Tumbleweed666 macrumors 68000

    Joined:
    Mar 20, 2009
    Location:
    Near London, UK.
    #6
    What does your data look like that you are trying to copy in?
    Is it in a table or in some other format?
    Can you give an example?
     

Share This Page