Forums >> Revit Building >> Technical Support >> Exporting schedules to Excel with multiple lines in a cell

itavarescorreia

active

Joined: Tue, Nov 27, 2012
5 Posts
No Rating

Hi all, 

I am hoping someone can help me out. I am trying to fill out a room schedule with an additional parameter which lists all the inventory present in that room. This of course adds multiple lines to each row which I know how to do. However, when I link the .txt file back to Excel, what are paragraphs in RVT are merely spaces in excel, meaning that my multiple line cell is filled with a single line of loose words. 

Is there a way that I can export to txt and keep my paragraphs inside the parameter field? Or perhaps more adequately, is there a format that I need to apply in Excel? 

Thanks in advance! 

This user is offline

WWHub

site moderator|||

Joined: Tue, May 16, 2006
13079 Posts

There is no such thing as a multi lined cell in Revit.  The cell just wraps (ONE CELL) - thats why it exports as it does.

Revit is always one line per "record".

This user is offline

itavarescorreia

active

Joined: Tue, Nov 27, 2012
5 Posts
No Rating

You can add multiple lines to a parameter by Ctrl+Enter, which is beneficial if you need to add additional information per paramenter (eg. Inventory). But Excel interprets them as a single line text. Is there a way around this? 

This user is offline

TKennedy

active

Joined: Wed, Oct 7, 2009
654 Posts

You need to set Excel to wrap text in cells.

This user is offline

WWHub

site moderator|||

Joined: Tue, May 16, 2006
13079 Posts

I know about the hard code word wrap in a Revit cell.  It is still one cell. As TKennedy says, you have to format the cell in Excel.

This user is offline

Exporting Multiple schedules to excel at once?

0

excel - autoCAD - revit

3

Exporting Electrical panel schedules to Excel

5

Exporting Schedules into excel format

3

exporting to excel

3