3 Replies Latest reply: Feb 25, 2014 9:25 AM by johan-martijn
johan-martijn Level 1 Level 1 (0 points)

I've made a particular template in Numbers for particular data, but when I try to import data (in this case an Excel spreadsheet) I only get the data within a new Numbers document. Is there a work-around to force Numbers to use my template? What is the purpose of a template if you can only use it by adding data by hand?


PowerMac, Mac OS X (10.5.8), Mac Pro,
  • Wayne Contello Level 6 Level 6 (14,975 points)

    The only way to import data (without adding an Applescript) is to open the source data file in a new, temporary,  document copy the data, paste into your template and close the temporary document.

     

    The purposte of the template is to allow you a predfined set of table and calculations that are formatted the way you want.

  • SGIII Level 5 Level 5 (5,290 points)

    If you have Excel, what usually works well here is this: select the cells with the data in Excel, command-c to copy, click once on the upper left cell of the range where you want your data to appear in Numbers, then command-v or option-shift-command-v to paste. Numbers will expand the table as needed.

     

    If you are not bringing the data directly from Excel on your machine, but you are getting the data from elsewhere, then if you have a choice, get the data in tab-separated format.  That pastes readily into Numbers, after opening it in a temporary document and copying as Wayne describes.

     

    Comma-separated data or Excel format can be opened in a new Numbers document, as you not, but data needs to be converted to tab-separated data before it can be pasted into an existing Numbers document.

     

    If you can only get the data in comma-separated format, then there is an AppleScript that will do the conversion for you. Post if you need that.

     

    SG

  • johan-martijn Level 1 Level 1 (0 points)

    Hi Wayne, SG, it worked like a charm! Thanx!