# Export to .tsv

**URL:** <https://forum.manager.io/t/export-to-tsv/4993>\
**Category:** Uncategorized\
**Created:** [March 10, 2016, 2:11am UTC](https://forum.manager.io/t/export-to-tsv/4993 "2016-03-10T02:11:19Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![AnBe](https://avatars.discourse-cdn.com/v4/letter/a/df705f/32.png) [@AnBe](https://forum.manager.io/u/AnBe)\
**Post date:** [March 10, 2016, 2:11am UTC](https://forum.manager.io/t/export-to-tsv/4993/1 "2016-03-10T02:11:19Z")

</div>

I’m possibly a bit “stupid” but I’m having problems with the “Export” function from various reports. It looks like regardless what I do, “negative” values are not treated as numbers but rather as “text” in Excel.

If I just double click the exported file, Excel treats these as per below. I have also tried to “import” in Excel and changed the “File origin” to various formats (ANSI, UNICODE etc etc) but regardless of format I cannot get EXCEL to treat negative figures correctly.

(I’m on MAC OSX and using EXCEL for Mac 2011)

![](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/1/1000e13f6454f6b9ccc8d43b0ddae9ae12cc9f9e.jpg)

I also have a more “advanced” request for the “Export” function:

Rather than to output a .tsv (or .csv) file, would it be possible to implement a generic spreadsheet export function (I assume the most generic would be .xls or whatever format Google spreadsheet use) so that basic “formulas” are exported rather than just the “result”…? E.g. sums in a “P&L” are exported as a “SUM formula” so that any changes in the exported spreadsheet are correctly calculated…

---

<div class="post-metadata">

**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\
**Post date:** [January 18, 2023, 3:34pm UTC](https://forum.manager.io/t/export-to-tsv/4993/2 "2023-01-18T15:34:20Z")

</div>