Export data from a text form to Excel

Content
  1. You can easily export Word form data to Excel in just a few simple steps.
  2. understand word forms
  3. Use options to select comma separated format
  4. Import form data into Excel

You can easily export Word form data to Excel in just a few simple steps.

Microsoft Word does not have the ability to save form data directly as an Excel sheet. However, with just a few extra steps, it is very easy to export data from a Word form to Excel.

The instructions in this article apply to Excel 2019, 2016, 2013, 2010; Excel for Mac and Excel Online.

understand word forms

The Word form contains fields to fill in that make it easy to fill in important information. Usually, these forms are distributed so that many people can fill them out and return them. Collecting all the information from these forms and transferring it to an Excel spreadsheet is a tedious manual process. Fortunately, exporting Word form data to Excel is very easy using comma-separated files.

Use options to select comma separated format

Saving form data as a comma-separated value (CSV) file requires only a few tweaks in a Word document. This file format separates each form entry with commas. Use CSV files to import data into Excel.

Microsoft Word is smart enough to store form-only data in a CSV file. Additional text in the document is not added to the CSV file.

With the form document open and filled with data, select File > parameters: .

  1. Select Additionally in the panel to the left of the Options dialog box.

  2. Under Preserve precision when sharing this part of the document, select the Save form data as a delimited text file check box.

  3. Select Okay to close the Word Options dialog box.

There are currently two ways to export data to Excel. Save the document or export the data.

Use Save As to export to CSV

To save a document in CSV format:

  1. From the menu choose File Save as . The Save As dialog box opens with the TXT file format already selected.

  2. Name the file and choose Okay .

  3. A dialog box appears with a preview of the data you are exporting from the form to CSV format.

  4. Select Okay to export the data.

Word retrieves the form data entered as a file in the form .csv , which can be opened in Excel. Word inserts commas between fields. Excel uses commas to separate data in specific cells.

Use Export to save to CSV

To export data to a CSV file:

  1. Select File > Export .

  2. Select Change file type .

  3. In the Document File Types section, select Plain text (*.txt) .

  4. Select Save as to open the Save As dialog box.

  5. Select the location where you want to save the file, enter a file name and select Save to export the data.

Import form data into Excel

Once the Word form data has been exported to CSV format, the data is ready to be imported into Microsoft Excel.

If you open the file with Excel, you won’t see the file in the folder where you saved it because Excel only shows Excel files by default.

Open the CSV file by doing the following:

  1. Open a blank Excel document.

  2. Select File > Open .

  3. Select Overview .

  4. From the drop-down list of file types, select All files (*.*) .

  5. Navigate to the folder where the exported Word form data is located and select the CSV text file.

  6. Select Open .

  7. Excel opens the Text Import Wizard. Select with separators and choose Further .

  8. Uncheck the box tab and check the box comma . Then select Further .

  9. Select Finished .

The data from your Word form appears in your Excel sheet.

Import form data into an existing worksheet in Excel 2019 and 2016

To transfer data from new Microsoft forms to the same spreadsheet, follow these steps:

  1. Open the saved Excel file.

  2. Create a new sheet by clicking the symbol + at the bottom of an existing sheet.

  3. Select cell A1 .

  4. From the Data menu, select Retrieve data: > From file ,> From Text/CSV . (In Microsoft 2010 or 2013 select From text ).

  5. Select the new form data text file and choose Import .

  6. Select in the wizard To download > Download to .

  7. Under Where do you want to put your data, select: Existing sheet and make sure it is selected A1 .

  8. Select Okay .

After the form data has been imported, add the new Word form data to your worksheet:

  1. In Word, select the entire row containing only data.

  2. Right click and select To copy .

  3. In Excel, select your master sheet.

  4. Select the cell just below the last item on the sheet.

  5. Right click and select Insert .

Import form data into an existing worksheet with Excel 2013 and 2010

Follow these steps to migrate data from new Microsoft forms to Excel 2013 or 2010.

  1. Open the saved Excel file.

  2. Select a cell in the first column just below the existing data.

  3. Select Facts > From text .

  4. Select the new form data text file and select Import .

  5. Select in the wizard with separators and choose Further .

  6. Uncheck the box tab Check the box comma and choose Further .

  7. Select Finished .

  8. Under Where do you want to put your data, select: Existing sheet . Make sure the cell where you want to place the new rule is selected.

  9. Select Okay .

This will add new Word form data to the next row of your main worksheet.

Leave a Reply

Your email address will not be published.