Convert word document to excel

0 votes
I need to turn a word document I have into a table. The catch is that the document has 1,000 pages, and each page must be entered into a separate cell in the excel sheet. I don't want each line to become a cell when I copy and paste from Word. I require that one cell contain the entire text that appears between two-page breaks.

To provide some context for the problem, let me say that I am trying to make a table because I basically need to create a CSV from a word file where each page represents one item.

Is it possible to automate this in some way?
Oct 23, 2022 in Others by Kithuzzz
• 27,740 points
73 views

1 answer to this question.

0 votes

See the solution here:

https://superuser.com/questions/747197/how-do-i-copy-word-tables-into-excel-without-splitting-cells-into-multiple-rows

In essence, I had to change the "pilcrow" characters in my file for line breaks and then reverse the process in Excel.

One crucial point, however: when updating rows in Excel, the author advises typing "alt+0010" (the key combination for a line break). That did not, however, work for me. However, pressing Ctrl+J causes a line break character to be inserted in the Excel replace box.

answered Oct 23, 2022 by narikkadan
• 51,240 points

Related Questions In Others

0 votes
1 answer

Convert Word doc, docx and Excel xls, xlsx to PDF with PHP

After receiving a request, I'll put the ...READ MORE

answered Nov 20, 2022 in Others by narikkadan
• 51,240 points
202 views
0 votes
1 answer

Excel - function to convert first letter of each word to uppercase

there are two methods to do this: Method ...READ MORE

answered Nov 21, 2022 in Others by narikkadan
• 51,240 points
80 views
0 votes
1 answer

Convert Excel to Word using Aspose.Word for Java

However, Aspose.Cells APIs cannot directly convert Excel ...READ MORE

answered Dec 10, 2022 in Others by narikkadan
• 51,240 points
81 views
0 votes
0 answers

Date time convert in Replace activity in word document scope

we have input in excel  New date/Header 31/12/2020 31/12/2019 We  want ...READ MORE

Jun 22, 2020 in Others by Sapna
• 120 points

recategorized Jun 22, 2020 by Gitika 195 views
0 votes
1 answer

How can I import an Excel file into SQL Server?

You can use OPENROWSET to import an Excel file ...READ MORE

answered Sep 15, 2022 in Database by narikkadan
• 51,240 points
403 views
0 votes
1 answer
0 votes
1 answer

Convert csv- or Excel-file (xlsx) to kml with custom markers

With some help from the community, I ...READ MORE

answered Sep 26, 2022 in Others by narikkadan
• 51,240 points
198 views
0 votes
1 answer

Adding Signature Line Word-Excel

Since there doesn't appear to be a ...READ MORE

answered Oct 14, 2022 in Others by narikkadan
• 51,240 points
85 views
0 votes
1 answer

Convert Excel and Word files to PDF Using ruby

 You can combine some: For excel files - ...READ MORE

answered Sep 26, 2022 in Others by narikkadan
• 51,240 points
266 views
0 votes
1 answer

How can I convert a Word document to PDF?

This is a difficult task, made even ...READ MORE

answered Oct 31, 2022 in Others by narikkadan
• 51,240 points
153 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP