Having trouble converting you CSV?

78 posts / 0 new
Last post
marcintokyo

Hi, I need to process Japanese characters in JIS coding for the description/memo fields. Seems not to be possible, already after selecting the csv file these fields are shown "scrambled".
Hope this can be fixed.

admin

Please create a new issue here and upload your CSV so I can have a look http://www.csvconverter.biz/project/issues

admin

It's tricky to make the converter understand some encoded text, can you try to convert your CSV file from Japanse to UTF-8? I saw this online tool, let me know if it works http://www.motobit.com/util/charset-codepage-conversion.asp

Ian Ennis

Hi, Sorry to take your time. I am having trouble - I have attended to several parse errors but two keep re-occurring and I cannot figure it out. Many thanks, Ian.

Invalid number of items on row 6: 23-Jul-14 Cnc "6 577.89"
Invalid number of items on row 11: IF Cans "1 000.00"

admin

It must be some inconsistency between the number of columns in the header and items. If you create a new issue under Bugs & Issues and attach the CSV file I can take a look. Also see this video http://www.csvconverter.biz/blog/how-fix-csv-file-not-being-converted

Roger Perez

I have a similar problem with some numbers being represented as "1 000" and what i did is to copy the excel sheet to a new excel sheet and paste only the values. Then convert the new sheet to csv.
Another issue I have is that the converter never recognizes the last line. Why do you think that is?
By the way, my bank downloads an excel sheet which i have to convert to csv, but there is no real help on how to do that so that you may avoid format errors in your csv.

admin

The approach of the video using Excel to standardize the CSV to have all fields enclosed by quotes and separated by semi-colon. Then it won't split on commas.
Regarding the last line missing, please open a new issue http://www.csvconverter.biz/project/issues

Grace Bitar

Unfortunately, it didn't work for me. Tried several times but only a portion of the information gets transferred. I'll keep reading the blogs and help topics to see where I'm missing before give up completely.

admin

See this tutorial and video http://www.csvconverter.biz/blog/how-fix-csv-file-not-being-converted
The approach of the video using Excel to standardize the CSV to have all fields enclosed by quotes and separated by semi-colon.

thayná fernandes

eu não sei para onde estão indo meus arquivos convertidos, não vão para o download e nem para meu email, preciso de ajuda.

admin

Verifique se o email esta correto http://www.csvconverter.biz/user
Tambem verifique se nao esta caindo na caixa de spam.

Marc Valley

I am trying to convert a CSV to A qif. It is only 38KB in size, but will only parse 20 records. Any suggestions?

admin

It will parse the first 20 records on the mapping screen, so you can have a preview. When you go to the next steps, it will convert the full file.

laurentchiche

dear Admin, I am trying to produce QIF file to import in Microsoft money.he Amounts formats are well respected and OK from the Bank in CSV. Unfortunately , the figures when transferred seem to be wrong as multiplied by 100, or another words the coma separator is moved to the right with two characters considered. do we know why and can it be stabilise?

admin

This has now been fixed. Make sure you select your country on the second step and the currencies will work accordingly

calumm

The tool is really useful - thanks.

The account name in my CSV file (mapped to Account/Splitter) seems to be used in the file name of the output file (OFX or QIF), but it doesn't seem to be included within the content of the file itself. When I import the OFX/QIF file into Microsoft Money, I have to manually select which account it is, as Money doesn't know which account is intended.
Is there any way to allow Money to recognise which account should be used?
I had expected that the account name would be included in the output OFX/QIF file, and that Money would therefore be able to match it to the account within Money. I don't know how Money recognises accounts, or whether this is possible.
Thanks - Calum

admin

The account field is used to split the CSV into multiple QIF/OFX files. For QIF its impossible for Ms Money to detect the account. For OFX it would be possible but this is not supported yet, this is something that could work http://csvconverter.biz/project/issues/16756

carpers

How should i handle the paypal fees for GNUcash?

Having downloaded the csv i cut out things that Gnucash doesnt deal with. As you may be aware. I sorted the deposit/withdrawal but gnu doesnt have a fees column to work with, they should go into banking fees or whatever expenses account deemed fit.

How should i handle this with your converter?

Sue Dickman

I haven't been able to download my files for about 2 months. It had all been working fine, and now I go through the usual steps, ask to have it sent to my email . . . and then I never receive the file. I haven't been doing anything differently, but the file doesn't seem to go anywhere. Can you help?

parker

The conversion appears to have worked fine and when I open the file in a text editor it looks fine, however all entrees have todays date and not the bank transaction date in quicken after import. any suggestions would be greatly appreciated.

admin

Make sure you selected the correct date format from the dropdown on when mapping the fields. If you still have problems, you can open an issue http://csvconverter.biz/project/issues and upload a bit of your CSV file, so we can debug it

Petro Coetzee

This is the best free app ever! Thank you SO MUCH!!! Just a quick question, I am sure I am being blonde here. When I convert CSV to QIF and upload it to Manager it adds 2 x extra zero's after each amount. aka my account looks like millions instead of thousands. What am I doing wrong please.

admin

Make sure you are selecting the correct Country code, this will affect the decimal separatirs

Adam Wildavsky

Your tool is marvelous - thanks for making it available! I had no trouble creating an OFX file for some stock sales. When I try to import into Quicken 2018 for Mac, though, I get the following message:

  Unable to read the selected Web Connect file. Please contact your financial institution.

My CSV has only four columns: Date, Security, Shares Sold, Amount. I created it myself - it is not from a financial institution.

Is there any hope for me? I know that Quicken expects banks and brokerages to pay them for the privilege of being able to generate QFX files. I had hoped that I could create my own OFX, but I know that might not be possible. If it's not I'll have to look into migrating to some other accounting package.

admin

Hi Adam

If you send me a sample CSV file I can try to debug it contact@csvconverter.biz

Leanne Neish

Hi there, i need troubleshooting. this website has been amazing to convert files, now i cant seem to convert the exact same files. Error as following:

  • The specified file temporary://all_months.csv could not be moved, because the destination is invalid. More information is available in the system log.
  • Error moving file

Any suggestions would be much appreciated :)

 

admin

Pages

Having trouble converting you CSV? | Free Online Converter CSV or TSV to QIF or OFX

Error

The website encountered an unexpected error. Please try again later.