Export spot coordinates from Revit to CSV file for surveyors?

[Anonymous]

Hi all,

I'm looking for a way to extract my east'ing / north'ing spot coordinates that I marked in Revit into a CSV file for my surveyor to stake out. I was wondering if there was a quick and easy way to do this rather than to input all points manually into a spreadsheet. I'm relatively new to using Revit for Civil work, so any information anyone could provide me would be greatly appreciated. 

If you need any additional information, feel free to ask. See attached for a screen shot of what i'm referring to. 

[L-Vettz]

Dynamo with a point family is the way to go.

[Anonymous]

Would that require I redo all my points, or could I use the ones already in ... I guess what i'm asking is how exactly would i approach that? any tutorials or tips you know of?

[L-Vettz]

You would use dynamo to isolate and create a list of all of your points. I'm assuming your points are actual families and not annotations. Once isolated you can use dynamo to read the N/S/E/W coordinates of each family and output them directly to excel. If your new to dynamo it could be daunting, but the people at the dynamo forums are usually happy to help.

[ToanDN]

A non-dynamo method, still requires you to place point families correctly in the model though, is export a 3d view with the points to DWG, open the DWG in AutoCAD and create a data extraction of the point blocks.  It can gives you XYZ of each point and can export to Excel.

[Anonymous]

I'll try reaching out on the forum, see if I could get any insight... Thank you!

[Anonymous]

This might be the most feasible method so far, I'll have to try this one first, I am assuming it would have to be done sheet by sheet...

[L-Vettz]

If I understand Toan correctly you could export a full 3D view of the project with ONLY your points turned on. This would generate a 3D CAD file with only the points. That should work for the entire job at once as opposed to sheet by sheet. I'm a way better dynamo user than I am a CAD user so this may be the better option for you.

[ToanDN]

---

@Anonymous wrote:

This might be the most feasible method so far, I'll have to try this one first, I am assuming it would have to be done sheet by sheet...

---

No.  You just need one 3d view showing all the points.  You can isolate the points so the file is cleaner if you want.

[Anonymous]

in the case of the points being annotations, is their a way?

[mbrachoOZZ]

You don't know how funny it was to see your name in what I was exactly looking for... 

Greatings from OZZ

[velrajbecool]

Hello @Anonymous ,

Did you get a procedure for exporting spot coordinates from Revit to Excel file, 

Could you please share how to do that?

If any other person knows, please explain. I have just marked spot co ordinates in 3d view and that to be exported.

Thanks in advance.

[MichaelWolff]

This is what we did: Sprinkle a Revit drawing with point coordinates and then export that drawing to dwg. Open the dwg file in AutoCAD (which most users of Revit are probably renting as well) and use DATAEXTRACT to generate an Excel file of all MTEXT entities. When you select everything, you end up with an Excel file that has N and E values combined in one column. We built a formula making extensive use of SUBSTITUTE, LEFT, RIGHT and SEARCH formulas and saved everything as a csv. Once we got the decimal separator and the value separator correct, we could even generate topography in Revit from it.