How do I convert an Excel table to a list in word

Question

Hi,

I have an excel sheet of company details. Lets say Co Name, Web Address, Telephone numbers - with each one in a new row like this:

Company Name	Website	Phone number
Company Name	Website	Phone number
---	---	---	---	---
Company Name	Website	Phone number
---	---	---	---	---
Company Name	Website	Phone number
---	---	---	---	---

I need to convert this list (its a lot longer than the example) to text in a word document in this format (for further import into inDesign):

Company Name

Website

Phone Number

Company Name

Website

Phone Number

Company Name

Website

Phone Number

Company Name

Website

Phone Number

I think I must ber searching using the wrong terms as I can't for the life of me work out how to do this. Can anyone help?

Many thanks.

Chris

Answer 1

I don't believe you'll have any success with the lengthy suggestion provided by another. For one thing it wont divide the Rows into separate paragraphs [Lines].

There is a programmatic method of rearranging the data in the Excel file but IMO, the simplest method is to use the Word Mail Merge feature to create a Directory using the Excel file as the list of Recipients. This doesn't effect the list in Excel.

Your Excel file needs Field Names at the top of each column which then can produce this:

As this:

Answer 2

Hi,

In cell E1, enter this formula

=DROP(TOCOL(VSTACK(IF(SEQUENCE(,4),""),TRANSPOSE(A1:C4)),,TRUE),1)

Hope this helps.

Answer 3

Hi,

In cell F1, enter this formula

=SUBSTITUTE(TOCOL(A1:D4),0,"")

Hope this helps.

Answer 4

Hello there,

Sorry to hear you're experiencing issues with Excel and hope the following solutions assist you:

1. Copy Excel Data: Select and copy the data from your Excel spreadsheet that you want to convert into a list format.

2)Paste into Word: 2.1)Open a new Word document. 2.2)Paste the copied Excel data into the Word document.

3)Convert to Text: 3.1)Select the pasted Excel data in the Word document. 3.2)Go to the "Insert" tab in the Word ribbon. 3.3)Click on the "Table" dropdown menu. 3.4)Choose "Convert to Text" from the dropdown menu.

4)Specify Delimiters: 4.1)In the "Convert Table to Text" dialog box that appears, choose the appropriate delimiter option. 4.2)Since your data is in columns, you'll likely want to choose "Tabs" or "Paragraphs" as the delimiter, depending on how your data is structured. 4.3)Click "OK" to convert the table to text.

5)Adjust Formatting: 5.1)Once the table is converted to text, you may need to adjust the formatting to match your desired output. 5.2)Ensure that each record (Company Name, Website, Phone Number) is separated by a paragraph break.

6)Repeat for Additional Data: If you have multiple sections of data in your Excel spreadsheet, repeat the above steps for each section.

7)Save the Word Document: Save the Word document containing the converted data in a format suitable for import into InDesign, such as .docx or .txt.

I hope the following solutions help solve your issue and should you have anymore problems/concerns please do not hesitate to contact me again.

Thanks,

Parth P.

Answer 5

Thanks. This method has worked well except the phone numbers have all lost ther zero at the beginning. I'v tried formatting the cells as text but its not working. Is there a way to preserve the numbers?