TextPipe: Online Help
    Excel spreadsheets to CSV
 

Submit feedback on this topic 

 Home  User Assistance   Tutorials   How to Use TextPipe
 Menus: File   Edit   Filters[ Wizards  Convert   Unicode   Add   Remove   Replace   Extract   Special   Maps   Restrict ]  Tools   Window   Help   Advanced
Home
Up

 

 

(Pro version only)

This filter takes ALL incoming documents, opens them with Microsoft Excel, and outputs them as CSV (comma-delimited) files. This can be used to process a set of Excel Spreadsheets to CSV. After this filter you can add search and replace filters or any other filters you choose, such as convert the data to Tab-delimited or XML.

Normally you set the Output filter's Change Extension to '.CSV' to prevent the original documents being overwritten.

This filter requires Microsoft Excel 98 or higher to be installed. If you wish to convert documents other than the default .XLS files, you may also need to install Excel's conversion filters.

Unless you know that all documents being processed are Excel documents (e.g. by using a wildcard of *.xls in the Files to Process tab), you should restrict this filter to only files of a certain extension.

See also

Word documents to text
Excel spreadsheets to CSV
PDF documents to text

 

 Contact Us   Support   Community   Tutorials and User Guides (online)
 Copyright © 1999-2006 DataMystic. All rights reserved.