Convert a Trial Balance Spreadsheet to a CSV File

When converting a spreadsheet to import your company accounting records, be sure to include a column for the following as they are required to complete your trial balance import:

  • Account name or description
  • Debit 
  • Credit

These items are required to complete the trial balance import.

Here is a sample trial balance report.

Adjust all accounts for tax purposes and ensure debit and credits are balanced prior to importing.

To convert from a Microsoft Excel file to the .CSV format:

  1. Go to File
  2. Click Save As
  3. For the save as type select CSV (comma delimited)

To convert an Open Office spreadsheet file to .CSV format:

  1. Go to File
  2. Click on Save As
  3. In the Save as type select Text CSV (.CSV)