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 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 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 techpack or techpacks that you want to download data, and click
option menu located on the top navigation bar.
Step 2: A window appears with a list of options. Select Upload Techpacks To Folder from the options available.
Step 3: A window pops up and click on choose a file.
Step 4: Select a .zip file you want to upload and then click on Open.
Step 5: Click on Import Techpacks.
Your techpack/techpacks will be imported in the selected folder.
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 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.
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
CARD TITLE.
- In case you wish to hide a certain column in your library, you can click on this
icon to hide a column as shown above
. Your data will be imported, but just won't be visible. You can always unhide that column late through the column manager.
You can switch any column to color column using the
icon.
Check
the columns you would like to show in your material table.
You can preview the columns and the order of the final table after you have made all the changes.
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 new section bar
Step 2: Click on from csv from the new window that opens.
Step 3: Click on choose file button.
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.