Importing and Exporting Data

This user guide is for the older release of the site. Most of the documentation for the current 2017 release can be found in the Auctria User Guide v3

You can import data from an Excel worksheet into Auctria.

These pages will show you how to bring information you have into an Excel format for your auction.



Input Format

Currently we can only import data from Excel worksheets saved as XLS files.

If you have a file in the newer XLSX format, then you can save it as an XLS file by clicking on File > Save As. In the Save dialog box there will be a drop-down for 'Save as type'. Set this option to 'Excel 97-2003 Workbook (.xls)'

The worksheet you import should be a simple grid, with one row per item, bidder or donor.  Do not include any sophisticated formatting or grouping of columns that might confuse the import process, though you can include a header row.

An example of an imported worksheet might look like the image on the right.