How do I convert a Word 2003 document into csv format?

[Benjamin Chambers]

Word 2003, unlike previous versions, won't let you use the Save As command to
save a document in csv format -- for reasons I cannot fathom -- so I'm unable
to put my mailing list into Excel, and from there into a database.

How can I make this happen? I hope I'm overlooking something simple.

 

[DerbyDad03]

I know a whole lot more about Excel than Word but I'll give this a
shot...

Text can be copied/pasted into Excel and depending on how it was
originally formatted in Word, one of two things should happen:

- Each line of text will be split into individual cells based on
spaces or tabs, or
- Each line will end up in a single cell which can then be separated
using the Data...Text to Columns feature.

Essentially the same thing(s) will happen if you save the document as
text and then use Open With...Excel.

How is the mailing list set up in Word? If I knew a little more about
the layout, I might be able to offer an way to get laid out in Excel
the way you need it.

 

[Benjamin Chambers]

This was very helpful. I realize in retrospect that I oversimplified my
question, because I was having other problems with Word that were
complicating conversion. My original document isn't broken up into fields yet
- e.g., the business name is followed by a carriage return, but the number,
street, city, state, and zip are all together in one line. I can usually fix
a lot of this sort of thing using Find/Replace, but for some reason, Word was
not seeing key characters when I did Replace (e.g., paragraph characters).
When I gave it another shot after getting your message, it could. I really
can't explain why.

One problem that you solved for me, however, was getting the Word document I
had massaged into Excel. I was trying to import Word documents, and Excel was
telling me that they weren't in an acceptable file format, even when I had
all the fields comma-delimited. Saving the file as text first took care of
that.

I've now got an Excel document I can work with - a few manual corrections
will be necessary, but not many. Thanks again. I may be back with more
questions; I've got more of these to work with.