How to import your existing data to Techpacker

  • Updated

1. How to copy/paste data from Excel to Techpacker


☑ Make sure to add the exact matching number of rows and columns in your techpack section where you will be copying your data from Excel.

☑ Make sure the Excel where you are copying the data from DO NOT have any formatting in the text and there are NO line breaks in the cells.



Data can be directly copied and pasted from Excel to Techpacker in all techpack sections including measurements, materials, sketches, and even custom sections.

Copy the data from Excel and paste it in the matching cell of your techpack section on Techpacker. 







2. How to copy/paste data from Excel to the custom sections


Make sure to add at least one card in the selected custom section. Learn how to create custom section here.


Data can be directly copied and pasted from Excel to Techpack in any custom sections including costing, fit, quantity breakdown, full custom section, etc.

Copy the data from Excel and paste in the matching cell of your techpack section on Techpacker. 






3. How to import data from excel in the measurements section

 You can also import your entire measurement table built on Excel and save yourself a ton of time. 


Here is an example of what your Excel file should look like. Download


Here's how it's done- 


☑ Your Excel file has to be formatted in .csv format

☑ Make sure your measurement section on Tech pack completely blank



Step 1

Click on this open_in_browser.png import measurement from .csv icon located on top-right corner of your Measurements section options panel. 





Step 2

As you click on import measurement from csv icon, a window pops-up will open for you to upload your .csv file. Select your file and click open




After you click on open, a table of all the point of measurements will appear in the measurement section in the form of cards.




Make sure the columns having sizes should be made as size columns.




4. How to import data from excel in the material section


You can create the material table by directly importing the excel in the CSV format with all the POM and the tolerances. This will save your time as you don't have to add each POM card-wise. 

Before creating a material table by import csv -

☑ Make sure that your material section has no cards and is completely blank.


Step 1

Click on the open_in_browser.png import materials from csv icon located on top of the material section.




Step 2


As soon as you click on import materials from csv icon, a window pops-up. Select the csv file which you want to upload and then click open




After you click on open, a table of all the materials will appear in the material section in the form of cards.





Make sure the columns having color combos should be made as color columns.




5. How to import data as a .tpr file

What is a .tpr file? 

.Tpr format files, our native Techpacker files, offer users the flexibility to export/import their tech pack data conveniently. This feature is particularly useful during account deactivation or reactivation. Learn more


To import a techpack in the .tpr format follow these steps:


Step 1: Inside the techpack dashboard page, select the mceclip4.png techpack or techpacks that you want to download data, and click mceclip5.png  option menu located on the top navigation bar. 

Screenshot_2024-01-22_at_8_42_41 PM.png


Step 2: A window appears with a list of options. Select Upload Techpacks To Folder from the options available.

Screenshot_2024-02-02_at_1_47_32 PM.png


Step 3: A window pops up and click on choose a file.

Screenshot_2024-01-31_at_2_43_13 PM.png


Step 4: Select a .zip file you want to upload and then click on Open.

Screenshot_2024-01-31_at_2_44_40 PM.png


Step 5: Click on Import Techpacks.

Screenshot_2024-01-31_at_2_51_53 PM.png


Your techpack/techpacks will be imported in the selected folder.

Screenshot_2024-01-31_at_2_56_32 PM.png





6. How to import .csv in Libraries


Before creating a library by importing a CSV.
☑ Make sure that your library has no cards and is completely blank.


Step 1: Click on this open_in_browser.png import from csv icon located on the top-right of your library.



Step 2: Browse and select the .csv file you wish to upload and click open

You can use this excel template to update your material table data before importing it on Techpacker.

import library.png


Step 3:This screen will pop-up where you will select the information from your CSV file you wish to include.

  • Under Source you will see the names of the columns from your CSV file
  • Under Destination, you will select and match the relevant columns where your table data should go.
  • For e.g. if in your .csv a column in called CARD TITLE, then in the destination area you should also match it with  Alphabet-a.png CARD TITLE.
  • In case you wish to hide a certain column in your library, you can click on this images.png icon to hide a column as shown above Alphabet-b.png. Your data will be imported, but just won't be visible. You can always unhide that column late through the column manager
  • Alphabet-c__1_.png You can switch any column to color column using the palette.png icon.
  • Alphabet-d.png Check Group.png the columns you would like to show in your material table. 


  • Alphabet-e.png You can preview the columns and the order of the final table after you have made all the changes. 
  • F.png Click on the "Import CSV" icon to import the table with the final changes made by you.



7. How to import data in custom sections


Step 1: Add a new section by clicking anywhere on the Combined_Shape.png new section bar


adding custom section.png


Step 2: Click on mceclip4.png from csv from the new window that opens. 

Step 3: Click on mceclip1.png choose file button.


Use from csv.png


Step 4: Select the file that you want to import and click on open.




Step 5: A window will pop-up to rename the section. Provide a section name  here and  click done.




Your new section will be created with all the details in the csv.



Share this

Was this article helpful?

4 out of 4 found this helpful