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

Peter Sass
Germany
Local time: 01:41
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!


Direct link Reply with quote
 


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






SDL Trados Studio 2017 Freelance
The leading translation software used by over 250,000 translators.

SDL Trados Studio 2017 helps translators increase translation productivity whilst ensuring quality. Combining translation memory, terminology management and machine translation in one simple and easy-to-use environment.

More info »
BaccS – Business Accounting Software
Modern desktop project management for freelance translators

BaccS makes it easy for translators to manage their projects, schedule tasks, create invoices, and view highly customizable reports. User-friendly, ProZ.com integration, community-driven development – a few reasons BaccS is trusted by translators!

More info »



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