Highlighted

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

Community Beginner ,
Jul 24, 2017

Copy link to clipboard

Copied

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+)?

Adobe Community Professional
Correct answer by Barb Binder | Adobe Community Professional

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.

Views

633

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

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

Community Beginner ,
Jul 24, 2017

Copy link to clipboard

Copied

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+)?

Adobe Community Professional
Correct answer by Barb Binder | Adobe Community Professional

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.

Views

634

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Jul 24, 2017 1
Adobe Community Professional ,
Jul 24, 2017

Copy link to clipboard

Copied

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.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jul 24, 2017 1
Community Beginner ,
Jul 24, 2017

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jul 24, 2017 0
Adobe Community Professional ,
Jul 24, 2017

Copy link to clipboard

Copied

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.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jul 24, 2017 1
Adobe Community Professional ,
Jul 24, 2017

Copy link to clipboard

Copied

I'm typing too slow today!

Or use Matt's suggestion to import the rest of the data into a design doc instead of my steps 1–2, and then continue down the list.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jul 24, 2017 1
Adobe Community Professional ,
Jul 24, 2017

Copy link to clipboard

Copied

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.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jul 24, 2017 1
Community Beginner ,
Jul 24, 2017

Copy link to clipboard

Copied

Thank you both. That saved a ton of typing.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jul 24, 2017 1
Adobe Community Professional ,
Jul 24, 2017

Copy link to clipboard

Copied

Always happy to help.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jul 24, 2017 0
Adobe Community Professional ,
Jul 24, 2017

Copy link to clipboard

Copied

Yeah, what Barb said!

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jul 24, 2017 0