Convert Word Tables To Excel easily with 'Convert XLS'.


Customers
 

Convert word tables to Excel, adobe customer

Adobe Systems Inc. Chooses 'Convert Doc'.  A custom site license has been signed by Adobe allowing them to install 'Convert Doc' on their servers.  They will be using it specifically to do Doc to HTML conversions. "We look forward to using your product and potentially working together in the future", Bob Free, Adobe

Convert word tables to Excel IBM Customer

Great customer service, prompt attention to our requirements and lightning speed development has been my experience with the staff at Softinterface Inc. Within a few hours of installing... Bruce King, IBM Canada, Toronto, Ontario


Click for the BBB Business Review of this Computers Hardware, Software & Services in Santa Monica CA
Facebook icon

no viruses


You need to convert from

XLSX to CSV (Unicode/ASCII/ANSI)

XLSX  to Fixed Width Text (Unicode/ASCII/ANSI)

XLS to CSV (Unicode/ASCII/ANSI)

XLS  to Fixed Width Text (Unicode/ASCII/ANSI)

CSV to XLS

CSV to XLSX

CSV to Fixed Width Text (ASCII/ANSI/Unicode)

Text to XLS Conversion

Text to XLSX Conversion

Text to CSV Conversion

Fixed Width Text File to HTML/XML

More... 

Convert Word Tables to Excel with 'Convert XLS'

(Import Word, HTML, RTF, XML Table Data To Excel Workbook/Worksheets)

English, Deutsch, Franįais, Italiano, 日本語, Brazilian Portuguese, Espaņol, Other Languages

'Convert XLS' logo, can be used to Convert Word Tables To Excel

So you need to convert Word Tables to Excel, no problem, we have the tool for you!  Whether it is one more many tables/files/worksheets/workbooks 'Convert XLS' has a special process specifically designed to handle this task. Softinterface has created a sophisticated software utility called 'Convert XLS' which has many 'special processes' to convert/manipulate Word/Excel files.  Read below for details on this specific feature, or click on the 'Convert XLS' home page to get a better idea of what the product does overall.

See the bottom of this page for some examples of how to automate converting word tables to Excel. We have a built in scheduler as well as a command line (and a COM/ActiveX) interface which will allow you to leverage 'Convert XLS' to automate your workplace!

Download 'Convert XLS' a tool which can be used to Convert Word Tables To Excel

Office 2019 Compatible!

 
 

User Interface, How to Use 'Convert XLS' to Convert Document Tables To Excel

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 convert document 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 original and target files (input/output).  For the input file, select any file MS Word can open.  If the target 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 original/input file, and how you want them placed within a worksheet/workbook. See the notes below for an explanation on each setting.

Convert document Tables To Excel

4. 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.

Finally, click the ‘Convert’ button to execute the process.

 

Additional Details

Details on the items you can specify when converting tables to Excel are discussed below:

·         Tables to convert are specified by number. 1 is for the 1st table, 3 is for the 3rd etc.

·         There are 3 methods to convert the Word tables 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 “Target 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 target sheet will be created if it doesn’t exist in the target file specified. 

·         Target 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 original/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.

 

Command Line Examples: Conversion of Word Tables to Excel

 

NOTE: 'Convert XLS' can be used simply with the graphical user interface (GUI).  If you've never heard of 'Command Line' before, we would recommend not reading this section and instead download and try the software.

This is just a sample from the documentation.   If you have trouble running these examples please see Helpful Hints For Creating a Command Line within the documentation.

Command Line Explained

‘Convert XLS’ can be run without a user interface with command line arguments much like in the good old DOS days.  Alternatively you can initiate command line execution by going to the operating system 'command prompt' or within Windows at the START-RUN menu and typing it in there.  Lastly, the command line interface can be used from Batch files (files with *.BAT extension). 

There are two approaches to using the command line:

     A)  Specify a 'Conversion Job' that was built using the graphical user interface (GUI); or

     B)   Specify a 'Conversion Task' in detail from the command line.

See the  'Convert XLS' documentation for a full explanation and reference.  Below we focus specifically on using 'Convert XLS' to execute an Excel Macro from the command line.

Command Line Examples: Convert Word Tables To Excel

The special process constant associated with copying a sheet is 102.

/P#

Meaning

Extra Parameters: /1{Parameter1} … /n{Nth Parameter}

115
 

Convert tables from doc, html, xml, rtf, wpd etc. into an Excel worksheet(s)/workbook(s)
 

/1 = sTablesToImport  (i.e. “1,3-5”)
/2 = lTableImportMethod:  Valid values (0,1,2)
/3 = sSheetToImportTo   
/4 = sPasteToCell   
/5 = lRowsBetweenTables    
/6 = lColsBetweenTables   
/7 = sRowsToDelete    
/8 = sColsToDelete     
/9 = bRemoveFormatting 

This special process can import tables from any file MS Word can open which includes DOC, HTML, XML, RTF, WPD etc. 

Special Parameters Described in Detail

/1 = sTablesToImport    Here you want to specify which tables you want to import.  To import tables 1 3,4 and 5 use “1,3-5”.  To import all tables use the asterisk “*” character (i.e. “/1*” ).

/2 = lTableImportMethod:  Valid values (0,1,2)

There are 3 methods to import the table into MS Excel.  First choice, 0, is to import to a specified sheet. All tables specified will be copied to the same sheet with this option.  Second choice, 1, is to create a new sheet for each table chosen to be imported.  The names of the sheets will be based on the “Target Sheet Name or Number” specified.  The last option, 2, 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.

/3 = sSheetToImportTo    Specify the name or number of the sheet to import the tables to.

/4 = sPasteToCell    Specify the starting cell to begin pasting the tables into (i.e. “B3”)

/5 = lRowsBetweenTables     Row Offset between each table: /5 and /6 are only relevant for when you’ve specified to copy more than one table into a single sheet (e.g. /2 0).  To place each table 2 rows below the last tables data, specify “/5 2” and don’t use /6.  To place each table 3 columns to the right of each other don’t use /5 and specify “/6 3”.  Specify a value of 0 for /5 or /6 to make the data contiguous (no spacing between tables).

/6 = lColsBetweenTables     Column offset between each table.  See /5 for details.

/7 = sRowsToDelete     Remove Rows: 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 rows 1, 4, 5 and 6 specify “/7 1,4-6” for example.  To remove the 2nd column use “/8 2”

/8 = sColsToDelete      See /7 for an explanation.

/9 = bRemoveFormatting   Set to TRUE to only copy table data: Here you may only copy the textual content of the table and ignore any formatting the original/input file had.  Set to FALSE to retain formatting etc.

Examples:

Example 1: Import One or More Tables into a Single Sheet

NOTE: The examples below are shown using Word documents as input, but they can be any file type MS Word can open.

Example 1A: Single Table Import To A Single Sheet

In this example we show how to take the 3rd table within c:\input\In.DOC and place into C:\Output\Out.XLS, in a worksheet called “Apples” beginning at cell D3.  We remove the formatting.

ConvertXLS.EXE /S"C:\Input\In.Doc" /T"C:\Output\Out.XLS" /P115 /13” /2 0 /3 “Apples” /4 D3 /9 TRUE

Example 1B: Several Table Import To A Single Sheet Remove 1st Row Of Each Table

In this example we show how to take tables 1,3 and 4 within c:\input\In.DOC and place into C:\Output\Out.XLS, in a worksheet called “Apples” beginning at cell D3.  We remove the formatting and the first row of each table.  Each table is placed 6 rows below the previous one.

ConvertXLS.EXE /S"C:\Input\In.Doc" /T"C:\Output\Out.XLS" /P115 /1“1,3-4” /2 0 /3 “Apples” /4 D3 /5 6 /7 1 /9 TRUE

 

Example 2: Import One Or More Tables into One or More New Sheets

Example 2A: Single Table Import To A New Sheet

In this example we show how to take the 3rd table within c:\input\In.DOC and place into C:\Output\Out.XLS, in a new worksheet called “Oranges” beginning at cell D3.  We remove the table formatting.

ConvertXLS.EXE /S"C:\Input\In.Doc" /T"C:\Output\Out.XLS" /P115 /13” /2 1 /3 “Oranges” /4 D3 /9 TRUE

Example 2B: Several Table Import To Several New Sheets

In this example we show how to take tables 1,3 and 4 within c:\input\In.DOC and place into C:\Output\Out.XLS, in several worksheets called “Oranges_1”, “Oranges_3”, and “Oranges_4” respectively.  Tables are placed beginning at cell D3.  We remove the table formatting.

ConvertXLS.EXE /S"C:\Input\In.Doc" /T"C:\Output\Out.XLS" /P115 /1“1,3-4” /2 1 /3 “Oranges” /4 D3 /5 6 /9 TRUE

 

Example 3: Import one Or More Tables into One or More Workbooks

Example 3A: Single Table Import To A New Workbook

In this example we show how to take the 3rd table within c:\input\In.DOC and place into a new workbook  C:\Output\Out-3.XLS, in a new worksheet called “Peaches_3” beginning at cell D3.  We remove the table formatting.

ConvertXLS.EXE /S"C:\Input\In.Doc" /T"C:\Output\Out.XLS" /P115 /13” /2 1 /3 “Peaches” /4 D3 /9 TRUE

In this case the following workbook will be created:

C:\Output\Out-3.XLS   (contains a single sheet named “Peaches_3”)

 

Example 3B: Several Table Import To Several New Workbooks

In this example we show how to take tables 1,3 and 4 within c:\input\In.DOC and place into several new workbooks.  Tables are placed beginning at cell D3.  We remove the table formatting.

 

ConvertXLS.EXE /S"C:\Input\In.Doc" /T"C:\Output\Out.XLS" /P115 /1“1,3-4” /2 1 /3 “Peaches” /4 D3 /5 6 /9 TRUE

 

In this case the following workbooks will be created:

C:\Output\Out-1.XLS   (contains a single sheet named “Peaches_1”)

C:\Output\Out-3.XLS   (contains a single sheet named “Peaches_3”)

C:\Output\Out-4.XLS   (contains a single sheet named “Peaches_4”)

 

Note it is highly encouraged that you use the Verbose (/V) switch initially to see what the status of your conversion is.

See Also: