tag:infinitekind.tenderapp.com,2009-01-14:/discussions/suggestions/15638-optimizing-plain-text-reports-for-spreadsheet-useInfinite Kind: Discussion 2023-10-13T16:30:29Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/581514622023-03-04T16:33:36Z2023-03-04T16:33:36ZOptimizing Plain-text reports for spreadsheet use<div><p>Save as csv / delimited?</p>
<p>Also. Extension. Extract data. To csv for excel.</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/581514622023-03-04T17:05:27Z2023-03-04T17:05:35ZOptimizing Plain-text reports for spreadsheet use<div><p>Save as csv, tab, and "encoded for Excel" all have the same problem. The categories and subcategories export into the first column with sub-labels indented using spaces. They need delimiters, so they import into separate columns:</p>
<p>ReportSection,Category,Subcategory,AndSoOn.</p>
<p>Preferably with the option to repeat on every line. Also, the extract data extension doesn't see my memorized reports.</p></div>ssmitttag:infinitekind.tenderapp.com,2009-01-14:Comment/581514622023-07-14T14:28:34Z2023-07-14T14:28:36ZOptimizing Plain-text reports for spreadsheet use<div><p>Are there any plans to make exported reports easier to work with in Excel?</p></div>ssmitt