Excel to create CSV import file

This topic contains 2 replies, has 2 voices, and was last updated by  vicki 8 years, 5 months ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
  • Author
    Posts
  • #168970

    vicki
    Buyer
    Post count: 76

    So I read all your warnings about using LibreOffice and not Excel to edit spreadsheets for import. I had started with a spreadsheet of data exported from another program (in Excel format), but opened it in LibreOffice as an .ods file and spent hours updating it. I saved the file many many times as I edited but today when I went to convert it to csv and import it, I saw none of my changes had been saved. I’m still in shock. This kind of thing hasn’t happened to me in years and I presume it must be some kind of LibreOffice bug which I don’t have time to troubleshoot. (I’ve looked for a reasonable explanation and haven’t found one: I’m on a Mac running 10.8.5, with the latest version of LibreOffice)

    So I re-read your instructions which were to edit the *csv* file in LibreOffice. Before I re-do all the hours work I wanted to check with you: do you think I will be safe to edit the data in Excel (which I know will save the work) and export from there to CSV? Is the problem just with editing the file in CSV format? I hesitate using LibreOffice since I don’t know why it didn’t save my work properly.

    #169155

    Paolo
    Site Admin
    Post count: 31206

    Hi,

    you should open our sample csv file as csv file with openoffice and copy the date from your excel spreadsheet.

    You shouldn’t be converting files and it would be better to open even the xls file with open office.

    Let us know how you went,

    Thanks

    #169383

    vicki
    Buyer
    Post count: 76

    OK, thanks.

Viewing 3 posts - 1 through 3 (of 3 total)

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
20% Discount Offer
Hurry! Get your 20% discount before it expires. Get 20% Discount