csv import problem

Post Reply
thekitehunter
Posts: 1
Joined: Sat Oct 23, 2021 5:11 pm

csv import problem

Post by thekitehunter »

I wanted to try Planmaker as an alternative to Libreoffice calc, but it won't import my csv file properly.
The line is:
Fixed Assets,,
11110 - Shop Fittings - Cost,"4,325.60",
etc...
which LibreOffice and Excel both import as two columns:
11110 - Shop Fittings - Cost
4,325.60


Planmaker ignores the double quotes (which keep the number together) and instead imports 3 columns:
11110 - Shop Fittings - Cost
"4
325.60


making it unusable - is there a way around this?
thanks
pmfrench
Posts: 14
Joined: Fri Dec 15, 2006 3:00 am

Re: csv import problem

Post by pmfrench »

Planmaker CSV Import options.png
Results in this:
Planmaker CSV Import results.png
Post Reply

Return to “PlanMaker 2021 for Windows”