Import csv data into a specifically formatted Word table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pat Dools - 27 Feb 2005 21:57 GMT

I have data from a statistician that needs to be put in specifically
formatted tables. She usually sends me that data in a word document, csv
style and I need to rework that data into a table. Since we might run and
rerun the data several times over the course of the month and the specific
formatting for each table is pretty specific, I was wondering if there is
anyway to set all of the tables structure and then import the data into the
body of the tables. My thoughts we to create a template, but I am not sure
if that is the way to go.

I am not sure exactly where to post this, or if this can be done. Thanks
for any guidance you can give me.

Signature

Pat Dools

Reply to this Message

Jezebel - 27 Feb 2005 22:38 GMT

Hard to be precise without knowing more about what you need to end up with,
but you might be better using Excel rather than Word, at least initially.
Excel can read csv data directly, so if you have a spreadsheet set up with
the columns formatted as you need them, most of the tabulation formatting
can happen automatically.

You can embed the Excel tables in a Word document, if you need to dress them
up further.

>I have data from a statistician that needs to be put in specifically
> formatted tables. She usually sends me that data in a word document, csv
[quoted text clipped - 10 lines]
> I am not sure exactly where to post this, or if this can be done. Thanks
> for any guidance you can give me.

Reply to this Message

Pat Dools - 27 Feb 2005 22:53 GMT

Due to quality control constraints I am not permitted to use excel at all,
which is making this a challenge.

What I need to do:

I have about 40 different tables, each with different formatting. Every
month I will get data that needs to go into each of these separate 40 tables
. The data from the old table will have to be deleted and the new data will
need to go in.

Rather than reconstruct the whole table, I would love to save the shell
(headers/spacing) and just bring in the new data, since the formatting has to
be really specific.

The statistician will send me a word doc with the data in a comma delimited
format. Is there anyway to put this data into a table without having to
reformat the table each time?

Many thanks.

> Hard to be precise without knowing more about what you need to end up with,
> but you might be better using Excel rather than Word, at least initially.
[quoted text clipped - 19 lines]
> > I am not sure exactly where to post this, or if this can be done. Thanks
> > for any guidance you can give me.

Reply to this Message

Jezebel - 28 Feb 2005 00:42 GMT

Can't think of an easy way off-hand, but I'll ponder.

If it were me, I'd also be saying very rude things to your quality people --
the method you're currently using is MUCH more prone to error than using
Excel would be.

As the saying has it: "Those who can, do. Those who can't, teach. Failing
that, become a quality consultant."

> Due to quality control constraints I am not permitted to use excel at all,
> which is making this a challenge.
[quoted text clipped - 52 lines]
>> > Thanks
>> > for any guidance you can give me.

Reply to this Message

Pat Dools - 28 Feb 2005 01:31 GMT

Thank you for your help. Right now I am saving the tables as separate
templates and then cutting and pasting the data in the rows (as long as they
are equal it works). I am just hoping there was something more efficient.

> Can't think of an easy way off-hand, but I'll ponder.
>
[quoted text clipped - 61 lines]
> >> > Thanks
> >> > for any guidance you can give me.

Reply to this Message

Doug Robbins - 28 Feb 2005 01:38 GMT

You could use a catalog (or in Word XP and later, it's call directory) type
mailmerge main document with the .csv file as a datasource. If you put the
mergefield names (assuming that there is a header row in the .csv table) in
the cells of a one row table, when you execute the merge to a new document,
the document will contain a table with one row for each record in the
datasource. You could then copy and paste that table into your document.

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

> Due to quality control constraints I am not permitted to use excel at all,
> which is making this a challenge.
[quoted text clipped - 52 lines]
>> > Thanks
>> > for any guidance you can give me.

Reply to this Message

Graham Mayor - 28 Feb 2005 08:45 GMT

You could probably use the method at
http://www.gmayor.com/convert_labels_into_mail_merge.htm also.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> You could use a catalog (or in Word XP and later, it's call
> directory) type mailmerge main document with the .csv file as a
[quoted text clipped - 65 lines]
>>>> --
>>>> Pat Dools

Reply to this Message

Pat Dools - 28 Feb 2005 13:03 GMT

Thanks for all of your suggestions. I am going to try some of this out today.

> You could probably use the method at
> http://www.gmayor.com/convert_labels_into_mail_merge.htm also.
[quoted text clipped - 68 lines]
> >>>> --
> >>>> Pat Dools

Reply to this Message