Importing tables within a word, html, rtf, xml file (or any file that MS Word can open) into one or more worksheets or workbooks is easily done with this special process.
Follow these steps to import tables into MS Excel:
1. Select the special process “[115] Import TABLES from document (doc,htm,rtf,xml,etc) into Excel sheet/workbook” from the Special Process drop down list.
2. Next select the input and output files. For the input file, select any file MS Word can open. If the output file doesn’t exist, ‘Convert XLS’ will create it.
3. Click the ‘Click Here: Import Word Tables To Excel Details’ button to specify exactly which tables you want to import from the input file, and how you want them placed within a worksheet/workbook. See the notes below for an explanation on each setting.
4. Optionally click the Add button to add the task to the Conversion Task list. You may add multiple tasks to the Conversion Task list before initiating the conversion process by repeating Steps 1 - 4 as necessary.
5. Click the ‘Convert’ button to execute the process.
NOTES:
Details on the items you can specify when importing table(s) are discussed below:
· Tables to import are specified by number. 1 is for the 1st table, 3 is for the 3rd etc.
· There are 3 methods to import the table into MS Excel. First choice is to import to a specified sheet. All tables specified will be copied to the same sheet with this option. Second choice is to create a new sheet for each table chosen to be imported. The names of the sheets will be based on the “Output Sheet Name or Number” specified. The last option allows you to create a new workbook file for each table specified. The output file name in this case is based on the input file and table numbers specified.
· The output sheet will be created if it doesn’t exist in the output file specified.
· Output cell location is where the first tables data will be inserted. For the first row and column use A1 for example.
· Only Copy Table Data: Here you may only copy the textual content of the table and ignore any formatting the input file had.
· Row/Column Offset between each table: These two items are only relevant for when you’ve specified to copy more than one table into a single sheet. To place each table 2 rows below the last tables data, specify “2” for the “Number of Rows” and leave the “Number of Columns” empty. To place each table 3 columns for the last column of each tables data, leave the “Number of Rows” empty and set the “Number of Columns” to “3”.
· Remove Rows/Columns: You may not want the first row (very common) of each table being imported. So you can easily specify any combination of rows or columns you want removed from the table when being imported. To remove columns 1, 4, 5 and 6 specify “1,4-6” for example.