The How-To Geek Forums Have Migrated to Discourse


How-To Geek Forums / Microsoft Office

Excel - How to Save Definition of File to be Imported

(1 post)
  • Started 7 years ago by alabamao68
  • Topic Viewed 767 times

PARTNER SPOTLIGHT

Recommended: Clean Your Mac the Easy Way with CleanMyMac 3

If you want to clean up your Mac the easy way, CleanMyMac is a great tool to get the job done easily, and it will even keep your computer clean automatically.

Unlike the competition, it also includes great tools like a Clean Uninstaller, to get rid of applications and clean up the junk that they leave behind. All with the click of a button.

Download CleanMyMac 3 for Free Today

Posted yesterday 
Top
alabamao68
Posts: 1

I frequently import .txt files to excel, always in the same format, a quite big one with 36 separate fields in 534 bytes (and separate header and trailer records, too, but that's another issue).

Is there a way to save the definition: i.e. the columns where fields split and the data type of each column so that I don't have to go through the laborious import wizard each time I want to import another instance of this file?

Posted 7 years ago
Top
 



Topic Closed

This topic has been closed to new replies.