How to view multiple CSV exports in one workbook
Once you have exported the CSV files from the OpenField Cloud or Console that you wish to merge into individual worksheets in one workbook, please ensure that the CSV files are all stored in one folder in your documents and then follow the steps below.
- Open the Microsoft Visual Basic tool from the Developer tab in Excel. If you cannot see the Developer tab, please see how to add it HERE.
2. In the Visual Basic window, select Insert > Module and then copy and paste the code from HERE into the command window as shown below.
3. To run the code, press the F5 key. In the new window that pops up, open the folder in which you have stored your CSV files and select the desired files before pressing Open.
4. You should now have a workbook containing individual worksheets for each CSV file.