Import data into TSS from XLS file

Import data into TSS from XLS file

Import data into TSS from XLS file

 

1 Click the tools menu then data then Import Data into TSS

2 Click Next

3. Choose the type of data like Inventory

4. Navigate to where you saved your .xls file

5 Next choose the sheet and it should preview your data like seen below

 

6.  

 

 

 

Click next and map your fields to the appropriate TSS fields the most important and only required fields are Make and Model 

 

 

Next then decide which fields to check for duplicates I would just leave it as Make and Model the more fields and the bigger the file the longer the import will take

 

 

Next

 

Now tell TSS where the data starts in the file most likely line 2 as the first line is the list of field names

 

 

Next and the last step is actually importing the data into TSS

 

    • Related Articles

    • Template File in Excel that can be used to import inventory into TSS XP

      Use the attached file to import data.

    • Shortcut to making your inventory only have the active items you use

      Step 1 Go to Inventory and browse all your inventory Step 2 make sure that the Active Item field is in your column headings If the Active Item is not listed, Right click on the column headings and choose field chooser to then drag the active item to ...

    • Routine Maintenance for TSS XP Data

      To ensure optimal performance and data integrity, it is recommended to regularly restructure the TSS data—similar to a defragmentation process. This maintenance task should be scheduled to run nightly, or at a minimum, at the end of each week. ...

    • TSS XP Pre-Use Checklist

      Please note that the checklist required prior to using TSS XP is currently incomplete and remains a work in progress as of October 2024. Updates and finalization are actively under way to ensure comprehensive coverage and usability. In consideration ...

    • TSS Plus important tools and tips

      Fixdata.exe is the tool to backup and try to help with fixing your Plus data In TSS2000 it is the program that runs when you click on the ambulance within TSS. In general have all users close TSS before running Fixdata Do the manual choice from the ...