I've attached an excel 2007/2010 Add-In that you can use to export the data from excel into xml files that Speed-Quote can read. Here are the instructions:

Unzip the files that are attached to this email and save it somewhere that you will remember. It contains the Add-In (SQ-Colorific.xlam), as well as a sample Excel file that Ben had sent me earlier, your excel sample file and the sample output from those files run through the Add-In.

To Register the Add-In with Excel

1. Open Excel
2. Click the Microsoft Office Button in the top-left corner and then click Excel Options.
3. Click the Add-Ins category on the left hand side of the window.
4. In the Manage box, select Excel Add-ins, and then click Go.
5. In the Add-Ins box that pops up, click Browse and find the SQ-Colorific.xlam file that you had previously unzipped. Select the file and click OK. Make sure that SQ-Colorific is checked in the Add-Ins popup box and then press OK.
6. If everything has gone correctly you should now see a “Speed Quote” tab at the end of your Excel Ribbon Control (top of the screen).

To Use the Excel Add-In

1. The Speed Quote tab will contain 2 buttons, “Export SQ XML - Ben” & “Export SQ XML - Bryce”.
2. Open a excel data file formatted the same as the ones you sent me.
3. Select all of the rows that contain data by clicking and/or shift-clicking on the row numbers. Do not select the first header row.
4. Click the appropriate button in the Speed Quote tab. (e.g. if you opened an excel file in the same format as Ben's file, press the “Export SQ XML - Ben” button)
5. Excel will ask you for the name of the SpeedQuote Database to import the products into. I have defaulted it to “Colorific”. This is the name of the database as it appears in Speed-Quote
6. Excel will ask you for a filename to save the xml into.
7. Excel will export the data to that filename and popup a box that says “Export Complete” when finished.

Importing the XML files into Speed-Quote

1. Start Speed-Quote & goto the Master Entry Sheet
2. Open the “Database Management” screen using the icon that looks like a file cabinet.
3. Click anywhere on the white section and select “Load Database → Import Master Data from XML → All Products”.
4. Speed-Quote will ask for an xml file to load. Select one of the xml files you exported out of Excel and press OK.

These may seem like a lot of instructions, but once you've done it a few times it will become very simple.