Tuesday, April 16, 2013

How to Convert a Word Document to a CSV File


1. Open the Microsoft Word document in Word and save it as a '.txt' file. To do this, select 'File' and then chose 'Save As.' Next, use the down arrow next to 'File as Type' and select '.txt.'
2. Open the Microsoft Word document in MS Excel by selecting 'File' and then 'Open.' Find the file in the 'Look in' directory from within the 'Open' dialog box.
3. Click option 'Delimited' and then click '1' beside 'Start Import at Row' to indicate the first row to import the data. Next, select the geographical location of the original file format beside 'File Origin.' When done, click 'Next.'
4. Click 'Tab' under Delimiter preference and then click 'Next.' Additional options include 'Semicolon,' 'Comma,' 'Space' and 'Other' for you to customize the separating character type.
5. Click 'General' as the format option for the 'Column Data 'and then click 'Finish.' Other column data formats include 'Date,' 'Date' and 'Do not import column (skip).'
6. Select 'File' and then choose 'Save As' from the toolbar menu.
7. Choose '.csv' as the 'Save as Type' and then click 'Save.'

Blogger news