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+)?
You can't paste the Excel spreadsheet data directly into an existing table, so here's what I'd do:
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.
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.
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:
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.
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.
Copy link to clipboard
Copied
Thank you both. That saved a ton of typing.
Copy link to clipboard
Copied
Always happy to help.
Copy link to clipboard
Copied
Yeah, what Barb said!