That is unfortunate!
- In what way would you need to use the file?
- And what bearing does the operating system have on this?
Hej
I need to provide the file sometimes to clients to fill in some records on Windows or Mac and return it to me via email.
They use Excel for editing those files.
Yes, you are right maybe the OS is not so much relevant.
Thanks
Radu
Thanks for the clarification!
So the issue isnât that the Excel file will not work but your concerned it might confuse the client. Is that correct?
As said, it is a matter related to user experience.
Yes, if we simply provide the file to the Client it breaks the script they use to process the file.
As well, when opened looks quite unprofessional for a non technical user 
That is helpful info. So you have parameters that would be affected by this data types in the headers. Good to know.
How about thisâŚ
- Create a new Excel file.
- Drag and drop the sheet from DEVONthink into the Excel file.
Hereâs an exampleâŚ
1 Like
Just curious ⌠is there a reason why you need to use DEVONthink sheet, rather than just relying totally on an Excel file that you import or index in DEVONthink?
Yes, good question.
I was typically using Excel and Numbers but as I do not use the super complex features of those two, I tried to get more âDEVONthink basedâ - to spend more time in the DEVONthink environment without switching context to another app.
But this proves to be with its own challenges 
Well ⌠if client wants Excel ⌠give them Excel⌠I perceive (without talking it down) is that sheets in DEVONthink are just tabular views of information and they give you a way to get the data out. I recommend not over-doing it and messing around with CSV files and all that, and stick with an Excel file that meets your clientâs interest. But Iâm guessing you know that. Saves everyone, esp. you, a lot of time.
1 Like
They do not have a special requirement on Excel, they can use csv or any other character delimited format (TAB delimited not so much as it may interfere with the values they are trying to insert), too. Their program would prefer a CSV.
Well ⌠as much as I exploit DEVONthink, I donât think itâs capabilities on the sheet area are matching your needs. Excel excels with working with data, including CSVs and Numbers probably does also. Or if the data is not huge, just use your own TXT file in DEVONthink that has a delimiter that the client accepts.
Changing tabs in a file to comma/semicolon/any other character is a one line shell script. If theyâre feeding the files to a program anyway, thatâs just one more step that can happen unnoticed. At the same time they could remove the â#âŚâ parts in the first line. No biggie.
If they canât do it, you could before sending the file out to them.
1 Like
Does your client work with the data or just need to view it? In the second case converting the sheet to PDF, HTML or RTF might be an option.
I know. And that is what I said from the start: this is a user experience matter as it adds an extra manual step to the flow
It does not if one wraps it in a script (for example) that does the conversion etc.
1 Like