https://community.graphisoft.com/t5/Collaboration-with-other/Excel-round-trip/m-p/297484#M38650 <DIV class="actalk-migrated-content"><T>It needs a lot of work. It works well, but at the lowest possible level.<BR /> <BR /> Everything is exported as text, including numbers. True/false properties are exported as 1's and 0's, and those too are text. URLs are not links (though links work in a saved PDF). Most concerning, option sets are not exported, so the Excel user can't pick from the list. And if that user enters a value not on the list, the entire column must be excluded from re-import to Archicad.<BR /> <BR /> In Excel, you can't tell properties from parameters. The Excel user can edit parameter values, but they will be skipped on re-import, and the user doesn't know that.<BR /> <BR /> You can convert the text numbers to number format, and Archicad does not object to this for re-import. It will also accept formula results in number fields, that's good.<BR /> <BR /> I haven't explored adding the option sets to Excel as lists, or T/F fields as checkboxes.<BR /> <BR /> As it stands the Excel user needs to be well-informed and careful in order to hand back useful data. I hope this feature continues to develop – everything in properties and schedules can be done in Excel, but the connection needs to be stronger.</T></DIV> Wed, 13 Jul 2016 15:19:17 GMT James Murray 2016-07-13T15:19:17Z https://community.graphisoft.com/t5/Collaboration-with-other/Excel-round-trip/m-p/297484#M38650 <DIV class="actalk-migrated-content"><T>It needs a lot of work. It works well, but at the lowest possible level.<BR /> <BR /> Everything is exported as text, including numbers. True/false properties are exported as 1's and 0's, and those too are text. URLs are not links (though links work in a saved PDF). Most concerning, option sets are not exported, so the Excel user can't pick from the list. And if that user enters a value not on the list, the entire column must be excluded from re-import to Archicad.<BR /> <BR /> In Excel, you can't tell properties from parameters. The Excel user can edit parameter values, but they will be skipped on re-import, and the user doesn't know that.<BR /> <BR /> You can convert the text numbers to number format, and Archicad does not object to this for re-import. It will also accept formula results in number fields, that's good.<BR /> <BR /> I haven't explored adding the option sets to Excel as lists, or T/F fields as checkboxes.<BR /> <BR /> As it stands the Excel user needs to be well-informed and careful in order to hand back useful data. I hope this feature continues to develop – everything in properties and schedules can be done in Excel, but the connection needs to be stronger.</T></DIV> Wed, 13 Jul 2016 15:19:17 GMT https://community.graphisoft.com/t5/Collaboration-with-other/Excel-round-trip/m-p/297484#M38650 James Murray 2016-07-13T15:19:17Z https://community.graphisoft.com/t5/Collaboration-with-other/Excel-round-trip/m-p/297485#M38651 Agreed. Fantastic feature, but needs a little help. I just set up a bunch of properties with "option sets". I'll have to change them all to "general" to use this feature. Mon, 31 Oct 2016 14:04:37 GMT https://community.graphisoft.com/t5/Collaboration-with-other/Excel-round-trip/m-p/297485#M38651 jp 2016-10-31T14:04:37Z