Converting from xlsx to Calc to .CSV?
Converting from xlsx to Calc to .CSV?
I am extremely new to Open Office but already love it due to the free download. I have just become an at home assistant to a client and I only have Open Office. She uses Microsoft Office. I received a document (xlsx) and was able to save it and open it to OpenOffice. My question is, in order to send it back to her, how do I make it a universal (CSV) file so that she is able to read it and make changes? Is this possible to do? All answers are welcome!
Open Office 3.0 / Windows XP (Service Pack 2) - I have Windows Vista
Re: Converting from xlsx to Calc to .CSV?
Save as xls which is Microsoft's old binary format, still supported by Excel and almost fully supported by OOo.
csv is a database exchange format which stores only one sheet's raw data to a text file without formulas, formattings, annotations nor anything.
csv is a database exchange format which stores only one sheet's raw data to a text file without formulas, formattings, annotations nor anything.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Converting from xlsx to Calc to .CSV?
Thank you for your advice. I have tried doing that, and seeing if it would open into Microsoft Excel 2007 before I sent it to the client and it wouldn't. I'm not sure what I'm doing wrong.
Open Office 3.0 / Windows XP (Service Pack 2) - I have Windows Vista
- Hagar Delest
- Moderator
- Posts: 32627
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: Converting from xlsx to Calc to .CSV?
Any specific layout or formulas in your file? Can you upload a sample file (don't hesitate to fake numbers), see How to attach a document here.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
Re: Converting from xlsx to Calc to .CSV?
If you Save As to .xls, Office 2007 should open it no problem. Are you sure you saved as .xls, and not in .ods with the .xls extension?
Use 'Save As' and then pick Microsoft Excel 97/2000/Xp (.xls)' from the drop down, and make sure the 'Automatic File Name Extension' option is selected.
Use 'Save As' and then pick Microsoft Excel 97/2000/Xp (.xls)' from the drop down, and make sure the 'Automatic File Name Extension' option is selected.
Ubuntu 14.10 Utopic Unicorn, LibreOffice Version: 4.3.3.2
Gurkha Welfare Trust
Gurkha Welfare Trust
Re: Converting from xlsx to Calc to .CSV?
here is an example
- Attachments
-
- Massage Directory.xlsx
- (35.48 KiB) Downloaded 323 times
Open Office 3.0 / Windows XP (Service Pack 2) - I have Windows Vista
- Hagar Delest
- Moderator
- Posts: 32627
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: Converting from xlsx to Calc to .CSV?
I've converted the file to .xls with OOo 3.1.1 on my xubuntu Karmic box, can someone with MS Excel check it?
NB: your signature says you're using 3.0, can you upgrade to latest 3.1.1? It may help.
NB: your signature says you're using 3.0, can you upgrade to latest 3.1.1? It may help.
- Attachments
-
- Massage Directory.xls
- (182 KiB) Downloaded 199 times
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
Re: Converting from xlsx to Calc to .CSV?
What is xubuntu Karmic box? I will try to update OpenOffice
Open Office 3.0 / Windows XP (Service Pack 2) - I have Windows Vista
- Hagar Delest
- Moderator
- Posts: 32627
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: Converting from xlsx to Calc to .CSV?
My GNU/Linux distribution is the Ubuntu version delivered with the XFCE desktop manager. Karmic Koala is the latest version released a couple of weeks ago.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
Re: Converting from xlsx to Calc to .CSV?
If those are real people's details I'd remove that file.
Ubuntu 14.10 Utopic Unicorn, LibreOffice Version: 4.3.3.2
Gurkha Welfare Trust
Gurkha Welfare Trust
Re: Converting from xlsx to Calc to .CSV?
Opens fine in Word 2007, but now I've tested that can a mod take those two files down as they appear to contain personal data.I've converted the file to .xls with OOo 3.1.1 on my xubuntu Karmic box, can someone with MS Excel check it?
OOo 3.3 on Windows 7 & 3.2.1 on Mint 10
- Hagar Delest
- Moderator
- Posts: 32627
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: Converting from xlsx to Calc to .CSV?
Don't worry, I had removed the file at first sight and in fact, the list comes from public information (you can click the links, it points to people proposing massages). So I've put the file back online.
But I agree, once the files have been proved to be readable with MS Excel, better remove them.
But I agree, once the files have been proved to be readable with MS Excel, better remove them.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
Re: Converting from xlsx to Calc to .CSV?
Good idea, I'm feeling a little stressed so could do with a massage(you can click the links, it points to people proposing massages). So I've put the file back online.
OOo 3.3 on Windows 7 & 3.2.1 on Mint 10