Help me organize my contacts..

June 5, 2010 10:48 PM

How can I convert a Word Doc (3 columns of addresses) to a csv file. I can get them in the Cvs file but cant get them to formulate correctly... Any help?
posted by pearlybob to Technology (4 answers total)

Assuming a standard Word doc (w/ tables), try selecting all of them and pasting to a new Excel sheet, then saving it as a CSV. Alternatively, try saving as plain text and opening it in Excel as a space-delimited file.
posted by theclaw at 11:26 PM on June 5, 2010

Copy the table when you're in the word document.
Open excel, right click and "paste special." Play around with the different ways to paste it in. I think picking Text should place the data in individual cells instead of dumping it all into a single cell.

Then "Save As..." a csv file.
posted by ijoyner at 11:40 PM on June 5, 2010 [1 favorite]

If you're having trouble pasting the data into the CSV file, then press control-alt-v (or "Paste Special) instead of just pasting, and you'll get some options about where you want your delimiters and what they should be. If you adjust those, you should be able to paste correctly.
posted by koeselitz at 3:21 AM on June 6, 2010

Click anywhere inside table.

Choose "Convert to Text"

Next dialog asks for delimiter. Choose Other and type in a comma. Click OK.

Profit.
posted by SuperSquirrel at 6:47 AM on June 6, 2010 [1 favorite]