Help with fields

[matGAJ5U]

How do I “mail merge” data from excel into my sheets so that the following happens. 

In excel

Column A of the spreadsheet would be title 

column B would be data relating to that title 

Column c (as b etc) 

in civil, how do I link the spreadsheet

then:

when the title is selected in the field of sheet/title block, field 2 below reflects the relevant cell of that row but column b and so on and so forth

can you then generate a sheet for each row/entry in the spreadsheet automatically like the mail merge function in word?

[SoaresASBCAD · Accepted solution]

https://knowledge.autodesk.com/support/civil-3d/learn-explore/caas/CloudHelp/cloudhelp/2021/ENU/Civi...

[Joe-Bouza]

Not sure how @SoaresASBCAD @solves your wm question. A very good reference to fields. 

I would go with SSM for title block info. I do not know if an OOTB way to go from excel to SSM, but @@JTB world has a SSet creator that uses an excel file. I’m not a sales rep, just a satisfied customer