I have an external word document that contains mailing label information. Multiple label information such as company name, company address, company city, company state and company zip. What I want to do is use this word document to create the original excel document using libreoffice. Any suggestions
Do you want to convert the data from a textual document (from a table or from the tabulated text body) to a spreadsheet document?
Can you upload an anonymized sample version of the source document?
Note that Mail Merge function in LibreOffice can use Writer documents with a table as their data source - so depending of your goal, it might happen that you wouldn’t need to convert anything.
You can’t “create the original excel file” as such automatically from this.
Some manual effort:
- Add an extra column to the right in your labels file.
- Copy table content and paste special-Plain text to a Writer document.
- Verify that you get regular label data, 5 rows for each, throughout.
- Copy the text from your Writer document and paste into an empty Calc sheet.
- Create formulas to extract records to rows
- Copy the formula created data, and paste special into a new sheet, values only.
See attached file (14.5 KB), which contains data for most of the steps described above for your 17 record sample. I saved it as Open Document, but you can save it to whichever format you desire, which your installed applications offer.