How to export a CSV (Comma-Separated Value) file that, when opened, will contain multiple columns

1. Go to Ledger & Payables → Setup → Positive Pay.
   
2. In the Setup Positive Pay for Bank Accounts screen, mark the radio button for Export as: Comma Delimited. Mark the checkbox to the left of each field that you want to populate on the report.
   
3. How the data displays when Comma Delimited is marked.
4. How the data displays when Fixed Width Order is marked. (still shows in spreadsheet in one column but, spaced out)
   
5. To export and have the data in separate columns in the spreadsheet:
   • Export as a CSV Text File and save the file in a location where you can easily find it.
     
6. Now you must convert your CSV Text file to a CSV Excel file.  

How to convert a CSV text file to a CSV Excel file

These exact instructions are dependent upon the version of Excel you have loaded on your machine. You may need to tweak the instructions accordingly.

1. Open a new Excel file.
2. Go to the 'Data' tab.
3. Select 'From Text/CSV'
4. Browse for the CSV file you want and click the Import button at the bottom right. The button will change from 'Open' to 'Import' when you select your file.
   
5. Select Load.
   
6. The data will display in columns. If your worksheet has headers that you do not want, you may uncheck the 'Header Row' box and then remove the first row.
   
7. Your file will now look similar to this:
   
8. Save the file where you can easily find it and then export it to your bank. 

Updated August 30, 2023 15:49