Skip to main content
Yogesh.T
Yogesh.T14-Alexandrite
14-Alexandrite
February 27, 2026
Solved

How to export .xls table in creo table format

  • February 27, 2026
  • 3 replies
  • 154 views

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!!

 

Best answer by PBrulot

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.

3 replies

kdirth
kdirth21-Topaz I
21-Topaz I
February 27, 2026

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

CSV.png

There is always more to learn.
    KenFarley
    KenFarley21-Topaz II
    21-Topaz II
    February 27, 2026

    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.

    P
    PBrulot12-AmethystAnswer
    12-Amethyst
    February 28, 2026

    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.

      Yogesh.T
      Yogesh.T14-AlexandriteAuthor
      14-Alexandrite
      March 3, 2026

      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!

      Yogesh
      Terms & ConditionsAccessibility statement