Convert Excel Files Via Command Line With Total Excel Converter

Total Excel Converter will help you convert XLS, XLSX, CSV, TSV, XLSM to PDF, DOC, HTML, Access, TXT, ODT, ODS, XML, SQL, CSV, Lotus, DBF, TEX, DIFF, SYLK, LaTeX. It works both via GUI and command line.
Buy your full perpetual license for as low as $59.90.

Usage of the command line prompt is follows:

ExcelConverter.exe "<source>" "<destination>" <options>

Be sure to use quotations for any folders or file names with spaces.

Note you can use macros in the destination path:

•  <DATE[:format]> - current date, default format is yyyymmdd
•  <TIME[:format]> - current time, default format is hhmmss

For example: destination "C:\<DATE>_<TIME:hhmm>" produce file C:\20200605_0436

Options:

• -log - Don`t show errors. Write them to the log file
• -verbosity - Log file verbosity
  • error - Write to log file only errors (default)
  • detail - Write detailed log file
• -logmode - Log file mode
  • overwrite - Overwrite (default)
  • append - Append
• -xmllog - XML format log file name
• -list - File with files mask to convert. Simple text file, each file on new line
• -Recurse:off - Include subfolders
• -do - Delete originals
• -msuccess - Move succesfully processed files to this folder
• -merror - Move problem files to this folder
• -kfs - Keep folder structure
• -kfl:off - Keep folder level
• -fo - Force overwrite existed files
• -rename:off - Force rename existed files
• -threads - Multi thread processing (0 - auto)
• -limit - Limit converted files to count
• -combine:off - Combine all files into one document (pdf, tiff)
• -ds:off - Copy original date stamps to converted documents
• -sort - Sort source file list
  • unsorted - Unsorted, natural order (default)
  • name - Sort by file name
  • date - Sort by file modification date
  • numbers - Sort by numbers in file name
• -ext - Use custom extension for output files
• -optionfile - text file with options to use, "opt=value", one line - one option definition
• -c - Convert to
  • DOC - convert to DOC
  • PDF - convert to PDF
  • HTML - convert to HTML
  • MHT - convert to MHT
  • XHTML - convert to XHTML
  • CSV - convert to CSV
  • TXT - convert to TXT
  • TIFF - convert to TIFF
  • JPG - convert to JPG
  • SVG - convert to SVG
  • RTF - convert to RTF
  • XML - convert to XML
  • JSON - convert to JSON
  • XLS - convert to XLS
  • XLSX - convert to XLSX
  • ODS - convert to ODS
  • ODT - convert to ODT
  • DIFF - convert to DIFF
  • SYLK - convert to SYLK
  • Latex - convert to Latex
  • SQL - convert to SQL
  • DBF - convert to DBF
  • PCL - convert to PCL
  • Access - convert to Access
• -template - Destination file name template
• -xml_template - Template for export to XML
• -Pass - Specify workbook Password to convert
• -sheets - Specify what sheets in the workbook you need to convert. -Sheets
• -cs:off - Combine Sheets into one file
• -ExportAll:off - Export all Sheets include hidden
• -FirstRowIsHeader:off - First row contains header
• -td - Text Delimiter
  • N - Use None
  • T - Use Tab
  • S - Use Space
  • CSV - Use CSV
  • C - Comma
  • Semi - Use semicolon
  • Other - Use key -TDO. #ASCII Code - for setup ASCII separator
• -tdo - Text Delimiter Other
• -Ansi:off - Use Ansi Code Page
• -UseQuote:off - Use Quote
• -fixlayout - Text file with columns width for fixed column width export, <column name>=<width>
• -UseOOFilter:off - Use OO Filter
• -ps - Paper Size
  • A3 - A3
  • A4 - A4
  • A5 - A5
  • B5 - B5
  • Letter - Letter
  • Legal - Legal
• -po - Paper Orientation
  • P - Portrait
  • L - Landscape
• -PgSep:off - Every page into separate file
• -NoTrim:off - No truncate CSV files
• -RoundUp:off - Round up to column format
• -maxpages - Setup max pages for PDF export
• -ThousandSep - Thousand Separator
• -is - Rendered image (jpeg, png) size <width>x<height>
• -accessdb - Access database file
• -table - Table name
• -pc - PDF file compression
  • F - Fastest compression
  • N - Normal compression
  • M - Maximum compression
• -pvl - PDF initial page layout
  • sp - Single page
  • oc - One column
  • tcol - Two columns, odd-numbered pages on left
  • tcor - Two columns, odd-numbered pages on right
  • tpol - Two pages, odd-numbered pages on left
  • tpor - Two pages, odd-numbered pages on right
• -pvm - PDF initial page mode
  • normal - Normal view
  • outlines - Show the outlines pane
  • thumbnails - Show the thumbnails pane
  • fullscreen - Show the document in full screen mode
  • optional - Optional content group panel visible
  • attachments - Attachments panel visible
• -mp - PDF master (owner) password
• -up - PDF user password
• -perm - PDF user permissions
  • Print - Print
  • Copy - Copy
  • Modify - Modify
  • Annotation - Annotation
  • FormFill - FormFill
  • Accessibility - Accessibility
  • DocAssembly - DocAssembly
  • HighResPrint - HighResPrint
• -EncryptPassword - Encrypt Owner Password for document
• -EncryptStrength - PDF Strength of Encryption
  • es40 - es40
  • es128RC - es128RC
  • es128AES - es128AES
  • es256AES - es256AES
• -PFXFile - PFX File for sign document
• -PFXPass - The password to open the PFX file
• -SignName - The name of the signature field to sign
• -SignLoc - The location that the signing was done
• -SignCon - The contact information of the signer
• -SignRes - The reason for signing document
• -PDFAuthor - PDF document author
• -PDFSubject - PDF document subject
• -PDFTitle - PDF document title
• -PDFProducer - PDF document Producer
• -PDFKeywords - PDF document Keywords
• -pdfa:off - PDF/A compatibility mode
• -pdfver - PDF document format version 1.2 - 1.6
• -pdfzoom - PDF document default page zoom
  • default - default
  • fitwindow - fit to window
  • fitwidth - fit width
  • 10 - 10%
  • 25 - 25%
  • 50 - 50%
  • 75 - 75%
  • 100 - 100%
  • 150 - 150%
  • 200 - 200%
  • 400 - 400%
• -TM - Top Margin (inches)
• -LM - Left Margin (inches)
• -BM - Bottom Margin (inches)
• -RM - Right Margin (inches)
• -PageRange - Page Range
• -pd - Custom paper size dimensions in mm <width>x<height>
• -tc - TIFF Image Compression
  • U - uncompressed TIFF
  • L - LZW compression
  • R - RLE compression (packbits)
  • J - JPEG compression
  • CC - Bilevel Huffman compression (CCITT1D)
  • G3FAX1D - Bilevel Group 3 CCITT compression, monodimensional (G3FAX1D)
  • G3FAX2D - Bilevel Group 3 CCITT compression, bidimensional (G3FAX2D)
  • G4 - Bilevel Group 4 CCITT compression, bidimensional (G4FAX)
• -tiffpi - TIFF Photometric interpretation
  • rgb - RGB
  • cmyk - CMYK
  • ycbcr - YCBCR
  • cielab - CIELAB
• -dpi - Image DPI
• -tjq - TIFF JPEG Quality (1-100)
• -HeadText - Header text. Where [page] - Page Number and [date] - current date
• -HeadAlign - Header align
  • l - align left
  • r - align right
  • c - align center
• -HeadFont - Header font [name,size,color]
• -HeadFontPDF:off - Embed header font into PDF
• -FootText - Footer text. Where [page] - Page Number and [date] - current date
• -FootAlign - Footer align
  • l - align left
  • r - align right
  • c - align center
• -FootFont - Footer font [name,size,color]
• -FootFontPDF:off - Embed footer font into PDF
• -HeadImage - Draw picture on the header
• -HeadImageAlign - Header image align
  • l - align left
  • r - align right
  • c - align center
• -HeadImageSize - Header image size (inches) [w,h]
• -HeadImageMargins - Header image margins (inches) [x,y]
• -FooterImage - Draw picture on the footer
• -FooterImageAlign - Footer image align
  • l - align left
  • r - align right
  • c - align center
• -FooterImageSize - Footer image size (inches) [w,h]
• -FooterImageMargins - Footer image margins (inches) [x,y]
• -CounterStart - Start numeration in header/footer from
• -CounterDigits - Header/footer counter digits
• -PrintGridLines:off - Print gray grid lines
• -FontKerning:off - Files with kerning look a little better but are a little bigger too
• -FontMapping - Font Mapping
  • ReplaceStandardFonts - Replace standart fonts by internal fonts. (optimum file size/accuracy)
  • ReplaceAllFonts - Replace all fonts by internal fonts. (smaller file size)
  • DontReplaceFonts - Do not replace any font. (maximum file size)
• -PrintToFit:off - Fit to page
• -PNVP - If set, the sheet will be printed on at most this number of vertical pages. Use 0 to have unlimited vertical pages while still limiting the horizontal pages.
• -PNHP - If set, the sheet will be printed on at most this number of horizontal pages. Use 0 to have unlimited horizontal pages while still limiting the vertical pages.

Examples:

• ExcelConverter.exe C:\Documents\index.xls C:\Pages\Doc1.doc -c doc -log c:\log\Excel.txt
  Convert file Index.xls into Word document Doc1.doc
• ExcelConverter.exe C:\Documents\ C:\All.PDF -cPDF -cs
  Convert all Excel files from this folder C:\Documents\ to PDF format and combine the converted files to file C:\All.PDF
• ExcelConverter.exe -list List.txt C:\PDF\ -cPDF
  Convert all files from file list List.txt to PDF and place them to C:\PDF\
• ExcelConverter.exe C:\Documents\index.xls C:\Pages\Doc1.csv -c csv -td Other -tdo "="
  Convert file Index.xls into CSV file with delimiter =