+ Reply to Thread
Results 1 to 2 of 2

Word to Excel

  1. #1
    Registered User
    Join Date
    03-07-2022
    Location
    New York
    MS-Off Ver
    Microsoft 365
    Posts
    29

    Word to Excel

    Hi y'all, 'm trying to convert a word doc with many many emails into an excel file. However, every time I do so I get the following error: DataFormat.Error: External table is not in the expected format. How can I resolve this issue?


    EDIT: I've added a sample word file. The actual file is ~1.2 MB so it's a bit large
    Attached Files Attached Files
    Last edited by MitchMitchell; 07-27-2022 at 10:24 AM.

  2. #2
    Forum Expert dosydos's Avatar
    Join Date
    12-09-2015
    Location
    MA, USA
    MS-Off Ver
    365(PC) V:2412
    Posts
    1,477

    Re: Word to Excel

    I mean i just opened your word document Selected everything using CTRL+A. Then copied everything with CTRL+C.
    Then opened excel and pasted with CTRL+V. This put all 1,560 emails into their own cell in column A.
    <----- If you are happy with your solution please click on the "* Add Reputation" as a way to say thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 07-27-2020, 10:57 AM
  2. Link Excel to Word 'Retrive data from excel into specific row inside word'
    By Eduards in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-25-2019, 06:55 AM
  3. Extract Word header table data to excel (closed word document)
    By Yakov on Excel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-14-2017, 02:12 PM
  4. Excel VBA - Word to search for part of a word and replace full word
    By charlie543 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-24-2016, 02:56 AM
  5. [SOLVED] Excel macro- Find replace an itallic font word with a regular word?
    By thisisaboutwork in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-08-2013, 01:48 PM
  6. Excel to Word passing data dynamically with bookmarks from Excel to Word
    By csekhar.apps in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-10-2010, 09:52 AM
  7. Replies: 1
    Last Post: 02-18-2005, 11:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1