How can I use Microsoft Excel to tidy my ASCII Text files

How can I use Microsoft Excel to tidy my ASCII Text files

A direct import from the client's accounting package into CaseWare is not always possible. Therefore, it may be necessary to import the trial balance using the ASCII text file method. It should always be possible to export your client’s trial balance into either an ASCII or Excel file. 

The ASCII file must be in a satisfactory format before importing into CaseWare. When you receive an ASCII file from your client, the file is likely to be in an undesirable presentation for CaseWare to successfully import.



The best software to use for tidying up ASCII files is Microsoft Excel.

1. Open Microsoft Excel and browse for your ASCII file.

2. Remember you are not browsing for an excel document. So you need to change the file type to Text Files (*.prm; *.txt; *.cs)

3. Select the ASCII file and click Open

4. Whenever you try to open an ASCII file using Microsoft Excel, you will need to complete 3 steps of the Text Import Wizard:

Step 1: Select Delimited  and click Next (If the Preview of the data below is neatly structured then select Fixed).

Step 2: Select the appropriate Delimiter. Once you do this the data in the Data preview will line up neatly. Click Next.

Step 3: Always change the Account No column to Text. This is to ensure your account numbers do not change format once they are brought into excel (e.g. decimal points, dates, etc).

5. The ASCII Text file has now successfully been imported into Excel

6. It is important to ensure that all information concerning an individual account is contained on one line

7. Delete all extraneous data including subheadings, page numbers, subtotals, dates and blank rows (between the data)

8. Save the file after the changes are made. It is important to save the changes as a different file so if you have made an error you can revert back to the original.




Note: The file can then be saved in the following formats before importing into CaseWare: 

Text (tab delimited) (*.txt) with a new file name.

Excel file because CaseWare is able to import Excel files.



    • Related Articles

    • How can I use Microsoft Excel to tidy my ASCII Text files?

      A direct import from the client's accounting package into CaseWare is not always possible. Therefore, it may be necessary to import the trial balance using the ASCII text file method. It should always be possible to export your client’s trial balance ...

    • Can CaseWare documents be exported to Microsoft Word & Excel

      CaseWare Working Papers allows users to export CaseWare type documents to Microsoft products. Automatic Documents can be exported to Microsoft Excel. CaseView Documents can be exported to Microsoft Word. Automatic Documents To export automatic ...

    • Why is my Trial balance balancing in Excel but not in CaseWare

      If your trial balance in Microsoft Excel is balancing well, but not in CaseWare it is likely that there are existing duplicated account numbers within your Excel Spreadsheet. CaseWare Working Papers will only allow unique account numbers to be ...

    • Importing from online accounting software

      We have begun to integrate Analytics with online accounting platforms, enabling you to upload data directly from these services without having to leave your browser or download the engagement files to your hard drive. These operations do not require ...

    • Importing from desktop accounting software

      You can import to Analytics from a wide variety of desktop accounting packages. You can import client data for analysis from a number of desktop accounting suites. Downloading CaseWare Transformer First, you'll first need to download the CaseWare ...