Import Utility: Importing Auction Purchases Part IV - Upload the File
- On Tab #2: Upload the File, you will upload your file/spreadsheet for import. Please be sure to have read our Import Utility: Importing Donations Part II - Prepare Your Data prior to proceeding).
- The system only accepts files in .csv format. When you first move to this tab, a pop up box will appear informing you of this fact.
- Click in the box and select the file to upload.
- If you get an error message "Column headers must be unique," the system is reading some of the blank columns past where you have data as having data in them (and because the headers of these columns are blank, two blanks are read as being the same/duplicate column headers). This usually happens because at some point you applied formatting to blank rows (highlighted an entire row or applied formatting such as bold or italics to the entire row, including the blank columns). Even if you later remove the formatting, there may be stray code still in your spreadsheet that the system is reading as data. If you don't see any stray formatting or data/characters, you will need to select just the cells that have data (do NOT select the entire columns and rows; only select the cells in your spreadsheet that have data for import) and paste them into a new spreadsheet. Save the new spreadsheet and try importing that file. If you still receive the error after completing the above two troubleshooting step, contact CRM support.
- After the file is successfully attached, you will see the file name under the select file field, which confirms the file has been selected.
- Click the blue Save & Next button in the lower right to proceed to the next step. Alternatively, you can click the blue Back arrow in the lower left to exit out without saving. You can return to complete the draft batch in progress at a later time.
- See our Import Utility: Importing Auction Purchases Part V - Map Fields tutorial to proceed.