Create a CSV file from Excel workbooks / worksheets

CSV File Creator in detail

The CSV File Creator allows you to easily create CSV files from your Excel workbooks. You just select the worksheets that are to be converted to CSV files and let the CSV File Creator do the work.

The CSV File Creator for Excel options:

• Convert just a single sheet
• Select the sheets you want converted
• Convert a specific range on each selected file to a CSV file
• Convert entire sheets without having to select a range to a CSV file
• Automatically name CSV files based on their sheet names if doing multiple sheets or prompt for name and directory
• Remove hidden columns before converting to CSV files
• Remove formatting so that numbers with % signs, parentheses, spaced formatted numbers are not treated as text entries

The CSV File Creator is completely menu driven

CSV File Creator for Excel - main menu

The menus are easy to follow and use. And, to help you learn how to use the features of the CSV File Creator, there is an exercise file to give you hands on practice.

Many times when you manually save an Excel workbook into CSV format, Excel will add extra rows to the CSV file. The CSV File Creator solves this problem!

See also in "Excel - Data management - merge, convert, delete"

• Address Assistant - Split addresses from one cell into multiple cells.
• Consolidation Assistant - Consolidate data from Excel workbooks or worksheets.
• Data Assistant for Excel - Make table form data applicable for Excel pivot tables.
• Data Cleaner for Excel - Remove spaces, Change text case, Replace / modify text, etc.
• Data Extraction Assistant for Excel - Extract data from one worksheet to many spreadsheets.
• Data Loader for Excel - Easy loading, processing, and transferring data .
• Filter Assistant - Filter multiple Excel spreadsheet columns at a time.
• Formula Manager - Manage all formulas in Excel worksheets easily.
• Formula Ref Changer and Sheet Index Creator - Change Excel formula reference types.
• List Assistant - Easy way to re-arrange rows in your Excel worksheet.
• Name Splitter - Split names into several Excel cells.
• Number Manager - Fill in the gaps in Excel workbooks.
• Report To Data Assistant - Convert text reports into Excel worksheet databases.
• Spreadsheet Assistant - Over 200 useful features for MS Excel.
• Text File Importer - Import text files with over a million lines into Excel.
• Text Manager - Change case in Excel, Join text to one cell, Remove spaces, etc..