Page 1 of 1

[Solved] Adding data to existing CSV document

PostPosted: Tue Apr 16, 2019 4:57 pm
by bobbert
HELP! Each month i build on my CSV file by adding another months worth of data. I download the new file, COPY it and attempt to to paste it into my existing file. It adds it, i save it, but when i go back in the new data isn't there????? Anyone have any idea what i'm doing wrong?

Re: Adding data to existing CSV document

PostPosted: Tue Apr 16, 2019 6:36 pm
by Zizi64
Editing a pure .csv file not request either of the Apache OpenOffice nor the LibreOffice Edit it by the simpliest notepad. Just copy/paste the new content, and save it as .csv file.

...In the other way you need import a .csv file into the Open/LibreOffice Calc, then you will able edit it cell-by-cell, and finally you must save (export) it as .csv file.
But it is better to store your important documents in the native, international standard ODF file types.

Re: Adding data to existing CSV document

PostPosted: Wed Apr 17, 2019 12:08 am
by John_Ha
Always save all your spreadsheet files as .ods files and never as .csv files. If you need a .csv file for some reason then save a copy of your .ods file as a .csv file.

See [Tutorial] Differences between Writer and MS Word files where .csv files are similar to .txt or .rtf files.

Is it a size problem? How many rows do you have in your .csv file?

Re: Adding data to existing CSV document

PostPosted: Wed Apr 17, 2019 5:17 pm
by bobbert
Thank you John.......you've just made life so much easier for me.