How To Convert HTML To XLS

To convert HTML file to XLS do the following:

1. Launch Total HTML Converter.
2. In a left-hand table choose a folder with HTML files from the file tree.
3. Then select an HTML file or files in the central panel (click check boxes).
4. In a right-hand table you may preview the file you have selected.
5. Select the tarhet format - XLS

   

6. After you select the target format (Excel) the Wizard's window appears. It collects all the conversion parameters. First, set up the destination path - the folder to place the output file to. You may set up the path in two ways:
   • Type the destination.
   • Click 'Diskette' button and find the file from a folder tree.

     

   • If you need to change the path from what you have typed or chosen press 'Full stop' button. The program will change the path to the original one.

     

     Note: If you do not set up the destination and do not give the name to the file Total HTML Converter will do it for you. It will set the same destination where the source HTML file is located and will give the same name as the source HTML file has.

   • If you would like to convert a group of files the program will offer you to keep the folder structure. Select it if you need it.

     

7. Press 'Next' on the bottom of the window or choose 'Render' on the left-hand side of the window.

   

8. Check what parameters you would like to render (Text, Shape or Image). If you select, for example, shapes only, images and text will not be converted at all.

   

9. Select a background. You may choose either the color or the image.

   

10. Click 'Next' button on the bottom of the window or select 'Margin' on the left-hand side of the window. Set up the margin parameters (left, right, top, bottom) in inches.

    

11. Set up the size of the paper, custom and paper orientation. You may also use 'Fit to Page' option to detect paper orientation automatically.

    

12. Click 'Start conversion'. The program will show you the conversion options which you have already set up. Check 'Delete originals' and 'Open destination folder after converting' if you need these parameters. Press 'Start!' button.

    

    Note: If you do not want to set up the document options they will be defined automatically by the program. They will be the following:

    • Convert to - xls;
    • Margin: Top - 0,5, Bottom - 0,5, Left - 0,5, Right - 0,5;
    • Paper Common, size A4, 8,3” x 11,7”, Portrait;
    • Render - text, images, shapes.

13. After clicking 'Start!' the program will open the folder where the converted file was put into if you have checked -Open destination folder after converting-.

14. If you need to cancel conversion click 'Cancel'.

    

Convert HTML to XLS via Command Line

You are also be able to convert HTML formats to XLS files with the help of command line.

To use Command line enter HtmlConverter.exe <source> <destination> - c xls ,

where

• <source> is the destination of the source file,
• <destination> is the destination of converted file.

Example: HtmlConverter.exe C:\Documents\index.htm C:\XLS\XLS1.xls - c xls

This is conversion of the file index.htm into XLS file XLS1.xls and saving the converted file in the folder C:\XLS\

There are also some additional options of Command line:

1. To change the format of all the files from the folder use * sign.

   Example: HtmlConverter.exe C:\Documents\*.htm C:\XLS\ - c xls

   Convert all HTML files from the folder C:\Documents\ to XLS format and keep the converted files in the folder C:\XLS\

2. To convert a group of files put them to list.txt

   Example: HtmlConverter.exe -list List.txt C:\XLS\ - c xls

   This is conversion of all the files from file list List.txt to XLS and putting them to C:\DOC\

3. You may use additional options. Press 'Help' button on a tool bar and choose 'Command line parameters'.

   

   The list of options will appear. You may read about them in Command Line Parameters page.