Skip to main content
Yogesh.T
Yogesh.T14-Alexandrite
14-Alexandrite
Feb 27, 2026 4:49 PM UTC
Solved

How to export .xls table in creo table format

How to bring .xls table in Creo10? Is there a simple way to do so. I have a big BOM i am working on and ita a pain to copy paste: ) 

 
 

 

 

 

Thx in Adv! Creo on Fly!!

 

PBrulotAnswer
12-Amethyst
Feb 28, 2026 1:57 PM UTC

In Creo 10 you can import a table from a csv file so you have to save the excel file as csv file. In Creo, select "table from file" and in the open file box, select type csv.

From Creo 11 you can directly import an excel file.

 

... it is still a big question mark why you have to copy a BOM table from excel into a drawing.

View in thread

4 replies

kdirth
kdirth21-Topaz I
21-Topaz I
Feb 27, 2026 6:53 PM UTC

Use Save Table > Save as CSV.  Open in excel, comma delimited.

CSV.png

Translate
There is always more to learn.
    KenFarley
    KenFarley21-Topaz II
    21-Topaz II
    Feb 27, 2026 8:38 PM UTC

    When we put a bill of materials on a drawing, we never have to enter any text into the table manually. Every component in the assembly has parameters (DrawingNumber, DescriptionBOM, etc.) that are used in the table. The BOM is "built" by the drawing - quantities are automatically added up.

    If a component is gotten from an outside source, we just have to put the few parameters that matter in that downloaded part/assembly. If there's something that needs to be included but it's not an actual component, like paint or grease, it gets added to the assembly using a bulk part.

    I do not miss the days of editing huge BOM tables to add all the entries, or being the person checking the drawing and having to count screws, dowels, or any other such components.

    Possibly this might help? It's a bit of work up front, but it pays off a lot if you're going to be using parts and assemblies over and over.

    Translate
    PBrulot12-AmethystAnswer
    12-Amethyst
    Feb 28, 2026 1:57 PM UTC

    In Creo 10 you can import a table from a csv file so you have to save the excel file as csv file. In Creo, select "table from file" and in the open file box, select type csv.

    From Creo 11 you can directly import an excel file.

     

    ... it is still a big question mark why you have to copy a BOM table from excel into a drawing.

    Translate
      Yogesh.T
      Yogesh.T14-AlexandriteAuthor
      14-Alexandrite
      Mar 3, 2026 8:32 PM UTC

      It has 120 components many that are not even in the CAD but hardware., But your suggestion was worked on by me and optimized with a bit trial and error to get what was needed. 

       

      CREO in need, can do it with community help!

      Translate
      Yogesh
      Terms & ConditionsAccessibility statement