Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: Identify File Type~?~

  1. #1
    Join Date
    22nd February 2010
    Location
    MO, US
    Posts
    2

    Identify File Type~?~

    The attached file is one of 2,691 .txt files that I need to convert to a .csv format so that I can import it into a product database.
    I cannot identify the type of structure in the text file, which is preventing me from using the Excel Import Wizard.

    Sample text file content (in case you do not wish to open the file):
    <ACCESSORY><SKU>369331</SKU><UPC>888063.69331</UPC><AVAIL_DATE>12/01/2010</AVAIL_DATE><STOCK>Y</STOCK><MANUFACTURER><NAME>MetroPCS</NAME><PART_NUM>VPAPVKYO3METLUC</PART_NUM></MANUFACTURER><LONG_DESC>METROPCS Dual Output Vehicle Power Adapter w/ USB Port. Kyocera USB connection.</LONG_DESC><SHORT_DESC>Dual Output Vehicle Power Adapter with USB Port</SHORT_DESC><SHIP_WEIGHT>0.22</SHIP_WEIGHT><SPECIFICATIONS><SPEC><NAME>Advise Customer</NAME><VALUE>NA</VALUE></SPEC>...

    The product database has a fixed .csv format that I must follow which may require modifying / manipulate the .txt file data to match that of the .csv format.

    Any help identifying the file / data format is appreciated.
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    1st September 2010
    Posts
    7,920

    Re: Identify File Type~?~

    It's an XML file... Have a read in help for importing. Is especially easy in XL 2007+

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    22nd February 2010
    Location
    MO, US
    Posts
    2

    Re: Identify File Type~?~

    Thank you.
    I made a backup of the file, changed the file extension to .xml, ran the import wizard and it worked, easy as stated.
    Now this brought me to several other issues, but none related to the file type or importing.

    Thanks for the timely response!
    Cheers.
    "... just another User..."

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Identify Cell Data Type
    By thedvirs in forum EXCEL HELP
    Replies: 4
    Last Post: October 21st, 2007, 14:23
  2. Remove File Name Type
    By toecutter in forum EXCEL HELP
    Replies: 2
    Last Post: September 27th, 2006, 16:43
  3. File type
    By Raf in forum Excel and/or Access Help
    Replies: 2
    Last Post: March 21st, 2006, 19:07
  4. Replies: 3
    Last Post: November 30th, 2003, 01:54
  5. Replies: 4
    Last Post: March 12th, 2003, 02:17

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
  •  
porno