System and method for formatting source text files to be imported into a spreadsheet file

1. A method for formatting a plurality of source text files each having specific formats to be imported into a single spreadsheet file comprising the steps of:

a) selecting a user modifiable file format profile to be associated to each of the plurality of source text files, wherein each source text file comprises a file directly created by a text editor or recognized by a spreadsheet program as a text file, the plurality of file format profiles each including a plurality of identifiers each with a corresponding formatting instruction, wherein each identifier generates a unique action in the spreadsheet file, wherein the file format profile is configured to be used to format the single spreadsheet file;

b) creating a source-format link between the plurality of source text files and the selected plurality of file format profiles,

wherein the source-format link stores a format action applied to the spreadsheet file after an importing;

c) importing the plurality of source text files into the single spreadsheet file after the creating the source-format link;

d) creating a location link between the imported plurality of source text files and their locations into the single spreadsheet file after the importing, wherein the location link comprises a directory path of the source text files and contains a related location and a size of each of the imported plurality of source text files;

e) storing the location link into a spreadsheet user profile database after the creating; and

f) applying the selected plurality of file format profiles to the imported plurality of source text files by using the source-format link and the location link.

2. The method of claim 1 farther comprising before step a) a step of creating at least one file format profile including at least one identifier with a corresponding formatting instruction.

3. The method of claim 2 farther comprising a step of storing the created at least one file format profile into a file format profile database.

4. The method of claim 1 farther comprising after step a) the step of modifying the selected file format profile.

5. The method of claim 4 farther comprising a step of storing the modified selected file format profile into the file format profile database.

6. The method of claim 1 wherein the spreadsheet file is created by a spreadsheet program.

7. The method of claim 1 further comprising after step f) a step of deleting the location link.

8. The method of claim 7 , further comprising updating a spreadsheet user profile to correspond with the deletion.

9. The method of claim 1 , wherein the applying farther comprises executing a set of formatting instructions based on the at least one identifier contained in the file format profile.

10. A computer-implemented system for formatting a plurality of source text files each having specific formats to be imported into a single spreadsheet file, comprising

at least one computer, including:

a) a system for selecting a user modifiable file format profile to be associated to each of the plurality of source text files, wherein each source text file comprises a file directly created by a text editor or recognized by a spreadsheet program as a text file, the file format profile including a plurality of identifiers each with a corresponding formatting instruction, wherein each identifier generates a unique action in the spreadsheet file, wherein the file format profile is configured to be used to format the single spreadsheet file;

b) a system for creating a source-format link between the source text file and the selected file format profile, wherein the source-format link stores a format action applied to the spreadsheet file after an importing;

c) a system for importing the source text file into the single spreadsheet file after the creating;

d) a system for creating a location link between the imported source text file and its location into the single spreadsheet file after the importing, wherein the location link comprises a directory path of the source text files and contains a related location and a size of each of the imported plurality of source text files;

e) a system for storing the location link into a spreadsheet user profile database after the creating; and

f) a system for applying the selected file format profile to the imported source text file by using the source-format link and the location link.

11. A computer program product stored on computer usable medium for formatting a plurality of source text files each having specific formats to be imported into a single spreadsheet file, comprising computer readable program means for causing a computer to perform the steps of:

a) selecting a user modifiable file format profile to be associated to the source text file, wherein each source text file comprises a file directly created by a text editor or recognized by a spreadsheet program as a text file, the file format profile including a plurality of identifiers each with a corresponding formatting instruction, wherein each identifier generates a unique action in the spreadsheet file, wherein the file format profile is configured to be used to format the single spreadsheet file;

b) creating a source-format link between the source text file and the selected file format profile, wherein the source-format link stores a format action applied to the spreadsheet file after an importing;

c) importing the source text file into the single spreadsheet file after the creating the source-format link;

d) creating a location link between the imported source text file and its location into the single spreadsheet file after the importing, wherein the location link comprises a directory path of the source text files and contains a related location and a size of each of the imported plurality of source text files;

e) storing the location link into a spreadsheet user profile database after the creating; and

f) applying the selected file format profile to the imported source text file by using the source-format link and the location link.