General Business Admin

How do I open a CSV file in Excel?

You can export all your transactions from your business portal and open it in excel. In most cases, you can simply double click the CSV to open it in Excel. If the columns do not display correctly, then you will need to follow the following process.

  1. Select File, then Import.
  2. Select CSV File.
  3. Ensure that Delimited is selected and not Fixed width. Select Next.
  4. Make sure that Semicolon is selected.
  5. Select Finish. If you're asked where to insert the data, select New sheet.
Help us improve our Help Centre. Was this article helpful?