https://community.graphisoft.com/t5/Collaboration-with-other/data-transfer-from-calculation-lists-to-word-excel-access/m-p/8061#M570 <DIV class="actalk-migrated-content"><T>if anyone finds time consumeing transfering calculation lists from archicad to word/excel/access or to get it organized the fastest way of doing it is<BR /> to copy data from list and paste to word document. then replace spacebars<BR /> (press one time spacebar in 'find what' window) with nothing (dont touch 'replace with' at all) and replace 'I' with tab(one or more and it has to be copied from word doc. and pasted to 'replace with' ). than easyli it can be copied to table, excel or acces.<BR /> hope it will helpful.</T></DIV> Fri, 20 Feb 2004 13:46:44 GMT Anonymous 2004-02-20T13:46:44Z https://community.graphisoft.com/t5/Collaboration-with-other/data-transfer-from-calculation-lists-to-word-excel-access/m-p/8061#M570 <DIV class="actalk-migrated-content"><T>if anyone finds time consumeing transfering calculation lists from archicad to word/excel/access or to get it organized the fastest way of doing it is<BR /> to copy data from list and paste to word document. then replace spacebars<BR /> (press one time spacebar in 'find what' window) with nothing (dont touch 'replace with' at all) and replace 'I' with tab(one or more and it has to be copied from word doc. and pasted to 'replace with' ). than easyli it can be copied to table, excel or acces.<BR /> hope it will helpful.</T></DIV> Fri, 20 Feb 2004 13:46:44 GMT https://community.graphisoft.com/t5/Collaboration-with-other/data-transfer-from-calculation-lists-to-word-excel-access/m-p/8061#M570 Anonymous 2004-02-20T13:46:44Z https://community.graphisoft.com/t5/Collaboration-with-other/data-transfer-from-calculation-lists-to-word-excel-access/m-p/8062#M571 I have found it very fast. easy and smooth to pre define an Excel workwook with all the appropriate sheets titles, cover sheet, fonts etc. and save the AC list as tabbed text... then import into the appropriate sheet and nothing else is required but saving as a PDF. An example can be downloaded at <A href="http://www.thompsonplans.com/plans/pages/details/1313A" target="_blank">http://www.thompsonplans.com/plans/pages/details/1313A</A> where it says "sample". Sat, 21 Feb 2004 15:56:32 GMT https://community.graphisoft.com/t5/Collaboration-with-other/data-transfer-from-calculation-lists-to-word-excel-access/m-p/8062#M571 Rick Thompson 2004-02-21T15:56:32Z https://community.graphisoft.com/t5/Collaboration-with-other/data-transfer-from-calculation-lists-to-word-excel-access/m-p/8063#M572 Saving any Calc text output as text, and then opening in Excel specifying | as separator does even better job IMHO. The only replacement you have to do is insert formulas in the totals fileds. Sat, 21 Feb 2004 18:13:55 GMT https://community.graphisoft.com/t5/Collaboration-with-other/data-transfer-from-calculation-lists-to-word-excel-access/m-p/8063#M572 Djordje 2004-02-21T18:13:55Z