Expand IntroductionIntroduction
Expand AdministrationAdministration
Expand User InterfaceUser Interface
Expand SOLIDWORKS FundamentalsSOLIDWORKS Fundamentals
Expand Moving from 2D to 3DMoving from 2D to 3D
Expand AssembliesAssemblies
Expand CircuitWorksCircuitWorks
Expand ConfigurationsConfigurations
Expand SOLIDWORKS CostingSOLIDWORKS Costing
Expand Design CheckerDesign Checker
Expand Design Studies in SOLIDWORKSDesign Studies in SOLIDWORKS
Expand Detailing and DrawingsDetailing and Drawings
Expand DFMXpressDFMXpress
Expand DriveWorksXpressDriveWorksXpress
Expand FloXpressFloXpress
Expand SLDXML Data ExchangeSLDXML Data Exchange
Expand Import and ExportImport and Export
Expand Model DisplayModel Display
Expand Mold DesignMold Design
Expand Motion StudiesMotion Studies
Expand Parts and FeaturesParts and Features
Collapse RoutingRouting
Expand Sheet MetalSheet Metal
Expand SimulationSimulation
Expand SimulationXpressSimulationXpress
Expand SketchingSketching
Expand SOLIDWORKS MBDSOLIDWORKS MBD
Expand SOLIDWORKS UtilitiesSOLIDWORKS Utilities
Expand SOLIDWORKS SustainabilitySOLIDWORKS Sustainability
Expand TolerancingTolerancing
Expand TolAnalystTolAnalyst
Expand ToolboxToolbox
Expand WeldmentsWeldments
Expand Workgroup PDMWorkgroup PDM
Expand TroubleshootingTroubleshooting
Glossary
Hide Table of Contents

Creating a From-To Excel File Manually

To create a From-To Excel file manually, keep the following in mind:
  • The file must contain the required From-To List fields.
  • The data must start in column A, but does not need to start in the first row.
  • Wire name must be the first field, and must be in column A. The order of the remaining fields is unimportant, except as noted here:
    • The two Part number fields can have the same name in the Excel spreadsheet. In this case, they must appear after the From reference and To reference fields respectively.
    • The From pin and To pin fields can have the same name in the Excel spreadsheet. In this case, they must appear after the From reference and To reference fields respectively.
  • You can use different header names for the fields in the Excel file and cross-reference the names to the header definition fields when you import the Excel file.
  • If you import only connection data (no component data), you can omit the Part number fields.
  • If you import only component data (no connection data), you can omit one reference field (From Reference or To reference) and one Part number field.

Example

Here is an example of an Excel file for a cable assembly containing two wires, named W11 and W6, and one cable, C1 with four cores named S1W, S2W, S2t, and W5. The cable and two wires start from one connector (motor1, part number db15-plug). The four cable cores connect to a second connector (con2, part number db9-plug). The two individual wires connect to a third connector (con3, part number 5pindin-plug).

From-ToList.gif


Provide feedback on this topic

SOLIDWORKS welcomes your feedback concerning the presentation, accuracy, and thoroughness of the documentation. Use the form below to send your comments and suggestions about this topic directly to our documentation team. The documentation team cannot answer technical support questions. Click here for information about technical support.

* Required

 
*Email:  
Subject:   Feedback on Help Topics
Page:   Creating a From-To Excel File Manually
*Comment:  
*   I acknowledge I have read and I hereby accept the privacy policy under which my Personal Data will be used by Dassault Systèmes

Print Topic

Select the scope of content to print:

x

We have detected you are using a browser version older than Internet Explorer 7. For optimized display, we suggest upgrading your browser to Internet Explorer 7 or newer.

 Never show this message again
x

Web Help Content Version: SOLIDWORKS 2016 SP05

To disable Web help from within SOLIDWORKS and use local help instead, click Help > Use SOLIDWORKS Web Help.

To report problems encountered with the Web help interface and search, contact your local support representative. To provide feedback on individual help topics, use the “Feedback on this topic” link on the individual topic page.

0.20.46