Importing Data
Binner currently supports importing of your data from CSV, Excel or SQL file formats. Import/Export tool is located on the Home page.
Import/Export page
You can import files used from an export tool operation, or create your own file to use as an import source.
Currently importing of external data is supported on the following tables: Parts, PartTypes, Projects.
For each table the primary key specified in your import file (PartId, ProjectId, PartTypeId etc) will not be reflected in the final data. It does however get used to map the imported records to the new records, so ensure your record id's for each row are unique in the file you are importing.
A header should be present in the CSV for best results. CSV files are one file per table, so the filename must match the intended table name.
// parts.csv
#PartId,Quantity,LowStockThreshold,Cost,Currency,PartNumber,DigiKeyPartNumber,MouserPartNumber,ArrowPartNumber,TmePartNumber,Description,PartTypeId,MountingTypeId,PackageType,ProductUrl,ImageUrl,LowestCostSupplier,LowestCostSupplierUrl,ProjectId,Keywords,DatasheetUrl,Location,BinNumber,BinNumber2,Manufacturer,ManufacturerPartNumber,UserId,DateCreatedUtc
1,3,10,0.37,"CAD","LM358","296-1395-5-ND","926-LM358AN/NOPB","","","IC OPAMP GP 2 CIRCUIT 8DIP",14,1,"8DIP","https://www.digikey.ca/en/products/detail/texas-instruments/LM358P/277042","https://mm.digikey.com/Volume0/opasdata/d220001/medias/images/6222/296%7E4040082%7EP%7E8.jpg","DigiKey","https://www.digikey.ca/en/products/detail/texas-instruments/LM358P/277042",0,"IC OPAMP","https://www.ti.com/general/docs/suppproductinfo.tsp?distId=10&gotoUrl=https%3A%2F%2Fwww.ti.com%2Flit%2Fgpn%2Flm358","Vancouver","1","2","Texas Instruments","LM358",1,2025-04-24 03:14:48
// projects.csv
#ProjectId,Name,Description,Location,Color,DateCreatedUtc
1,"Amplifier","My amplifier","Vancouver",1,2025-04-24 03:14:48
// parttypes.csv
#PartTypeId,ParentPartTypeId,Name,DateCreatedUtc
1,,"Carbon Resistors",2025-04-24 03:14:48
An excel file should have separate worksheet for each data type you are importing. Each worksheet (tab) name should match the intended table name. To get an example of the data format, which is similar to the CSV format, try exporting some sample data from Binner or Download Excel example
An sql file should contain basic INSERT statements for each data type you are importing. No SQL functions are supported, you must only use basic INSERT syntax as shown below.
Parts:
INSERT INTO Parts ("PartId", "Quantity", "LowStockThreshold", "Cost", "Currency", "PartNumber", "DigiKeyPartNumber", "MouserPartNumber", "ArrowPartNumber", "TmePartNumber", "Description", "PartTypeId", "MountingTypeId", "PackageType", "ProductUrl", "ImageUrl", "LowestCostSupplier", "LowestCostSupplierUrl", "ProjectId", "Keywords", "DatasheetUrl", "Location", "BinNumber", "BinNumber2", "Manufacturer", "ManufacturerPartNumber", "UserId", "DateCreatedUtc")
VALUES(1, 3, 10, 0.37, 'CAD', 'LM358', '296-1395-5-ND', '926-LM358AN/NOPB', '', '', 'IC OPAMP GP 2 CIRCUIT 8DIP', 14, 1, '8DIP', 'https://www.digikey.ca/en/products/detail/texas-instruments/LM358P/277042', 'https://mm.digikey.com/Volume0/opasdata/d220001/medias/images/6222/296%7E4040082%7EP%7E8.jpg', 'DigiKey', 'https://www.digikey.ca/en/products/detail/texas-instruments/LM358P/277042', 0, 'IC OPAMP', 'https://www.ti.com/general/docs/suppproductinfo.tsp?distId=10&gotoUrl=https%3A%2F%2Fwww.ti.com%2Flit%2Fgpn%2Flm358', 'Vancouver', '1', '2', 'Texas Instruments', 'LM358', 1, '2023-05-24 03:14:48');Projects:
INSERT INTO Projects ("ProjectId", "Name", "Description", "Location", "Color", "DateCreatedUtc") VALUES(1, 'Amplifier', 'My amplifier', 'Vancouver', 1, '2025-04-24 03:14:48');PartTypes:
INSERT INTO PartTypes ("PartTypeId", "ParentPartTypeId", "Name", "DateCreatedUtc") VALUES(1, NULL, 'Carbon Resistors', '2025-04-24 03:14:48');