Inserting multi row CSV into recurring table in word

macropod · #1 12-07-2016, 12:42 PM

From your description, it's possible a mailmerge would be the way to go, but it's unclear whether the CSV file has headers that repeat every 20 rows and whether you just want the output to all go into the same place in the document (i.e. a new table every 20 rows, one after the other) or whether you want to create replicas of the document with the same content, except for the table data, every 20 rows.

cuttlefishjones · #2 12-08-2016, 02:34 AM

Quote:

Originally Posted by macropod

From your description, it's possible a mailmerge would be the way to go, but it's unclear whether the CSV file has headers that repeat every 20 rows and whether you just want the output to all go into the same place in the document (i.e. a new table every 20 rows, one after the other) or whether you want to create replicas of the document with the same content, except for the table data, every 20 rows.

Thanks for the reply!

I'll try and clarify it a bit:

The CSV is ten columns the first row being the header. The rest of the rows are data (mostly text).

Code:

(headerA)   (headerB)   ...
(datax1)     (datay1)     ...
(datax2)     (datay2)     ...

In Word I want a table (1x20) to represent each row, each odd cell being a header and even cell the data from the corresponding cell in the CSV row.

Code:

(TABLE1)
(headerA)
(datax1)
(headerB)
(datay1)
...
(EOF TABLE1)
(TABLE2)
(headerA)
(datax2)
(headerB)
(datay2)
...
(EOF TABLE2)

And then for each row in the CSV I want a new table to be created in the same format.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Inserting a formula to count 30 days before and after a date in WORD table	bjh894	Word	9	05-18-2020 11:14 AM
Rotating a multi page table in word 2011 for Mac	UncleheFTy	Word Tables	1	08-17-2014 03:22 PM
programmatically inserting hidden text into a Word 2010 table	epid011	Word VBA	16	12-30-2013 11:29 AM
inserting a string of data into an MS Word table???	matto	Word VBA	0	07-16-2010 09:35 AM
How do I reference a merged cell in a multi column & row table in MS Word ('03')?	jihanemo	Word Tables	0	03-18-2009 08:33 AM