How to Change a Microsoft Word Document to a CSV File

If you have a list of data in a Word document and need to convert it into a CSV (Comma Separated Value) format, here’s a step-by-step guide to help you through the process.

Step 1: Prepare the Data in Word

Before starting, ensure your data in Word is organized with commas separating the values and each entry on a new line. Here’s an example of a simple email list:

[email protected], John Doe, 123-456-7890
[email protected], Jane Smith, 234-567-8901
[email protected], Alice Johnson, 345-678-9012

Step 2: Save the Word Document as a Plain Text File

1. Open your Word document containing the data.
2. Click the File tab at the top-left of the window.
3. In the left-hand pane, select Save As.
4. Choose Plain Text (.txt) from the list of available file types.
5. Click Save.
6. You’ll receive a warning about losing formatting, but since you’re working with plain data, click OK to proceed.

Step 3: Open the Text File in Microsoft Excel

1. Open Microsoft Excel.
2. Select Open in the left-hand pane.
3. Navigate to the folder where you saved the TXT file.
4. If the file doesn’t appear, make sure the “Text Files” option is selected in the file type drop-down.
5. Select the TXT file and click Open. The Text Import Wizard will open.

Step 4: Import the Data into Excel Using the Text Import Wizard

1. In the Text Import Wizard, make sure the Delimited option is selected.
2. Choose the row where your data begins (usually the first row).
3. Click Next.
4. In the Delimiters section, choose Comma. You’ll see a preview of your data being organized into columns.
5. Click Next.
6. For Column Data Format, select General unless you need a specific format for certain columns (e.g., dates).
7. Click Finish to complete the import.

Step 5: Save the File as CSV

Once your data is neatly organized in Excel, click the File tab again.

1. Select Save As.
2. In the Save as type dropdown, select one of the CSV options:
   • CSV UTF-8 (preferred if your data includes non-ASCII characters).
   • CSV (Macintosh) (for Mac users).
   • CSV (MS-DOS) (common for Windows users).
3. Choose a location to save your file and click Save.

Unlock powerful features with a genuine Office 2021 Professional Plus Key – get the best deal at the lowest price today!