When you have created your own catalogue you may wish to export it as a .CSV file to enable editing of the data in Excel.
Creating a CSV File
To save the catalogue as a CSV file
- At project level from the menu bar select Register > Catalogues. This opens the Registered catalogues window, which lists all installed catalogues.
- Select the catalogue you have created in the list and click on Catalogue>Save As CSV File from the menu bar.
- A save as screen will appear, give the csv file a name and click Save.
Note: Winner will by default save this file to your Export folder, if you want to save it elsewhere change the destination in the Save in drop-down box. - Close down your Registered catalogues screen.
- If a screen is shown asking if you want to export your catalogue – always click Yes.
Importing a CSV File into Excel
- Open up a blank Excel sheet. From the menu bar at the top select the Data tab, then select From Text/csv icon.
- Find the CSV file created at Step 3 above and click Import
- Click on Load
- The data in the spreadsheet can now be edited.
Related articles