CSV data mess with Invoice export - any workaround?
Thread poster: Peter Sass

Peter Sass
Germany
Local time: 08:10
Member
English to German
+ ...
Oct 29, 2012

Hi there,

I love the billing feature, yet the invoice export via the CSV format does not seem to work properly. When trying to import the CSV data into common spreadsheet programs like Excel or Calc (OpenOffice), the columns get messed up, e.g. invoice dates and descriptions entered in one column etc. I've tried all the possible tweaks for data import, but none works to distribute the data into different columns.

Since this has been noted before, is there a workaround?

Unfortunately, the one mentioned by Juho Karhu here
http://www.proz.com/forum/prozcom:_translator_coop/158290-announcing_invoicing_tool_updates:_payment_reminders_custom_formatting_purchase_order_number_more-page7.html#1866286
, i.e. converting the CSV to XML before importing to Excel, does not seem to work either.

I'd be most thankful for any ideas on this!


 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

CSV data mess with Invoice export - any workaround?

Advanced search






Déjà Vu X3
Try it, Love it

Find out why Déjà Vu is today the most flexible, customizable and user-friendly tool on the market. See the brand new features in action: *Completely redesigned user interface *Live Preview *Inline spell checking *Inline

More info »
Anycount & Translation Office 3000
Translation Office 3000

Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search