Post by lizzie08 » Fri Feb 15, 2013 5:19 pm
I am trying to get information from a text document and enter the information into a spreadsheet (excel) document. How do I go about doing that. Thank you for any information.
OpenOffice 3.2.1 on mac OSX 10.7.5 acknak Moderator Posts: 22756 Joined: Mon Oct 08, 2007 1:25 am Location: USA:NJ:E3Post by acknak » Fri Feb 15, 2013 5:48 pm
Greetings and welcome to the community forum!
Did you try copy & paste?
If you can give us a small sample of the data you're working with, I expect we can give you some specific suggestions for getting it into Calc.
AOO4/LO5 • Linux • Fedora 23 lizzie08 Posts: 2 Joined: Fri Feb 15, 2013 5:14 pmPost by lizzie08 » Fri Feb 15, 2013 6:38 pm
I work at a school and I have a list of students, their address and phone numbers that I need to have in a spreadsheet document so I can sort the information, and put column headings. Also, when I save the document I need to send it to other places, ex: military or graduation company for diplomas. Would they be able to open the document if they do not have open office? They usually request the information in excel format. Thank You
OpenOffice 3.2.1 on mac OSX 10.7.5 acknak Moderator Posts: 22756 Joined: Mon Oct 08, 2007 1:25 am Location: USA:NJ:E3Post by acknak » Fri Feb 15, 2013 7:31 pm
This came up in a recent thread; see http://forum.openoffice.org/en/forum/vi . 45#p263545
for my suggestion.
If you read further there, you'll see that a problem using tab as the separator may come up, so I would maybe modify the suggestion to using some other separator character that does not appear in the data at all, maybe ! or _
Once you get the data imported into Calc, you should save a master copy in Calc's native format: ODF (.ods for spreadsheets). From that master, you can make extra copies to send out using MS Excel format, PDF, or text, as needed.
AOO4/LO5 • Linux • Fedora 23 4 posts • Page 1 of 1Powered by phpBB® Forum Software © phpBB Limited