How to open OfficeR&D exported files in MS Excel

Introduction

OfficeR&D exports data such as invoices, bookings, members, fees as a .csv. The invoices export, as an example, generates a .csv file that describes all line items of all invoices and is suited to be imported into an accounting software.

Procedure

The CSV file is a simple text file, encoded with UTF-8 encoding that uses commas (,) as field separators. To open the file in Microsoft Excel, follow these next steps:

Open Microsoft Excel.

Click on the Data menu bar option.

Click on the From Text icon.

Navigate to the location of the file that you want to import. Click on the filename and then click on the Import button.

Choose 65001: Unicode (UTF-8) from the drop-down list that appears next to File origin.

Click on the Next button to display the Text Import Wizard - Step 2 of 3window.

Place a checkmark next to the delimiter that was used in the file you wish to import into Microsoft Excel. The Datapreview window will show you how your data will appear based on the delimiter that you chose.

Click on the Next button to display the Text Import Wizard - Step 3 of 3.

Choose the appropriate data format for each column of data that you want to import. You also have the option to not import one or more columns of data if you want.