Skip navigation

HT3345: Numbers '09: Importing a document from another application

Learn about Numbers '09: Importing a document from another application

HT3345 can you parse a document?

296 Views 5 Replies Latest reply: May 11, 2013 8:57 PM by Yellowbox RSS
prichar Calculating status...
Currently Being Moderated
May 10, 2013 12:08 PM

Exporting a credit card statement.  In numbers I would like to create columns with the info through parsing.  thanks phil

iPad 2, iOS 5.1
  • Barry Level 7 Level 7 (29,095 points)
    Currently Being Moderated
    May 10, 2013 12:13 PM (in response to prichar)

    What format is the exported document file?

     

    On what will Numbers base the parsing of this document?

     

    Regards,

    Barry

  • Jerrold Green1 Level 7 Level 7 (28,185 points)
    Currently Being Moderated
    May 10, 2013 3:01 PM (in response to prichar)

    Prichar,

     

    Numbers has no feature that will help you to import a PDF into a table. I've heard that MS offers a trial version of Excel. Why not give that a try. Let us know how it works out.

     

    Jerry

  • Wayne Contello Level 6 Level 6 (12,625 points)
    Currently Being Moderated
    May 11, 2013 7:51 PM (in response to prichar)

    you can open a PDF document in a program called Skim and generally you can select data in a table, copy, then paste into a table in Numbers-- sometimes you have to hold the option key down while selecting tablular data.

  • Yellowbox Level 4 Level 4 (3,900 points)
    Currently Being Moderated
    May 11, 2013 8:57 PM (in response to prichar)

    Hi prichar,

     

    Copying a statement from the web creates a string of info with no delineation

     

    Are you copying by selecting then Copy (command v)?

     

    If this is a bank statement, can you instead download a comma separated values (csv) file? My bank allows various formats for downloading statements, and csv will open in Numbers. The commas delineate columns.

     

    Regards,

    Ian.

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.