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 in Others by Kithuzzz
• 20,660 points
35 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 by narikkadan
• 37,660 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 in Others by narikkadan
• 37,660 points
52 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 in Others by narikkadan
• 37,660 points
26 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 171 views
0 votes
0 answers

MS EXCEL: Convert (Height) Decimal Feet & Inches to Inches Only

Using MS Excel (2010), I would like ...READ MORE

Feb 10 in Others by Edureka
• 13,640 points
96 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 in Database by narikkadan
• 37,660 points
191 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 in Others by narikkadan
• 37,660 points
101 views
0 votes
1 answer

Adding Signature Line Word-Excel

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

answered Oct 14 in Others by narikkadan
• 37,660 points
47 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 in Others by narikkadan
• 37,660 points
135 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 in Others by narikkadan
• 37,660 points
57 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