Skip to main content
bronxguys02
bronxguys02
Known Participant
July 24, 2017
Answered

How do I add rows of an Excel table into a table in FrameMaker?

  • July 24, 2017
  • 4 replies
  • 2218 views

I finally got half of my data formatted into a table in FM. I received the rest of the info that needs to be added to the table. How do I do that without retyping all the rows (600+)?

      This topic has been closed for replies.
      Correct answer Barb Binder

      You can't paste the Excel spreadsheet data directly into an existing table, so here's what I'd do:

      1. Copy the spreadsheet data to the clipboard
      2. Paste either into an ¶ in the Fm document, or better yet into a new one—this makes a new table
      3. Add enough rows/columns to the existing table (use Table > Add Rows or Columns)
      4. Then you can copy those cells and paste them into the empty rows of the original table
      5. Save your file and close the other Fm doc.

      4 replies

      Matt-Tech Comm Tools
      Community Expert
      Matt-Tech Comm ToolsCommunity Expert
      Community Expert
      July 25, 2017

      Yeah, what Barb said!

      -Matt Sullivan, FrameMaker Course Creator, Author, Trainer, Consultant
      bronxguys02
      bronxguys02Author
      Known Participant
      July 24, 2017

      Thank you both. That saved a ton of typing.

        Barb Binder
        Community Expert
        Barb BinderCommunity Expert
        Community Expert
        July 24, 2017

        Always happy to help.

        ~Barb at Rocky Mountain Training
        Matt-Tech Comm Tools
        Community Expert
        Matt-Tech Comm ToolsCommunity Expert
        Community Expert
        July 24, 2017

        It sounds like you're bringing it in as Import by reference. Is that correct?

        If so, use the Copy into document option instead.

        If you already used Copy into document then you just have table rows, which you can Cut/Paste as needed.

        -Matt Sullivan, FrameMaker Course Creator, Author, Trainer, Consultant
        Matt-Tech Comm Tools
        Community Expert
        Matt-Tech Comm ToolsCommunity Expert
        Community Expert
        July 24, 2017

        Use File>Import>File to convert to a FrameMaker document. You'll get options to convert on the fly, or you can convert after import.

        If you have trouble with the import, try exporting the XLSX as CSV and then importing.

        -Matt Sullivan, FrameMaker Course Creator, Author, Trainer, Consultant
        bronxguys02
        bronxguys02Author
        Known Participant
        July 24, 2017

        I can get the spreadsheet into FrameMaker, but then I need to add the spreadsheet info into an existing table in FrameMaker.

        Barb Binder
        Community Expert
        Barb BinderCommunity ExpertCorrect answer
        Community Expert
        July 24, 2017

        You can't paste the Excel spreadsheet data directly into an existing table, so here's what I'd do:

        1. Copy the spreadsheet data to the clipboard
        2. Paste either into an ¶ in the Fm document, or better yet into a new one—this makes a new table
        3. Add enough rows/columns to the existing table (use Table > Add Rows or Columns)
        4. Then you can copy those cells and paste them into the empty rows of the original table
        5. Save your file and close the other Fm doc.
        ~Barb at Rocky Mountain Training
        Terms & ConditionsAccessibility statement
        Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices