Uploading a Worksheet

Does your company use spreadsheets to store product data, share information and create orders? Now you can save time by uploading worksheets into TESSCO.com®, allowing you to keep a master spreadsheet such as an MS Excel file, then import just the items you wish to order. There’s no double work inputting data into TESSCO.com, and you’ll also save time on keystroke errors too.

To get started with Uploading MS Excel spreadsheets into TESSCO.com, follow these steps:

1. Download Sample.xls by right-clicking the link and...

2. From the file system, open up the MS Excel spreadsheet sample.xls

3. Update TESSCO SKUs and quantities.
(Note:  Upload won't bring in any SKUs that have a zero quantity)

4. Save the spreadsheet as a comma seperated file ( *.csv)

• File | Save As
• Name the file anything that you want Choose the "Save as type " to be "CSV (Comma Delimited) (*.csv)"
• Excel may warn you that the selected type does not support worksheets with multipe sheets.  Simply click OK to save the active sheet.
• Excel may then warn you that your file may contain features that are not compative with the CSV format.  Click YES to save in the CSV format.
• Exit out of MS Excel

5. Return to TESSCO.com

6. Go to the Worksheet Page

7. Choose Upload

8. Browse for the *.csv file that you saved to your PC and select the file

9. Click OK on the Upload Worksheet page.

The system should return you to the worksheet page.  Any SKUs that had a quantity greater than 0 should be visible in your worksheet.  The worksheet name should be the same as your *.csv file.