TXT to Excel Conversion, Sorted -- 3
Budget: ₹12,500 – ₹37,500 INR
I need a single-step solution that takes one structured TXT file and delivers a clean, ready-to-use Excel workbook. The text file is the only source; after import, every record must be arranged in strict numerical order. No extra filtering or complex transformations are required—just an accurate conversion followed by the sort.
Please handle:
• Reading the TXT file (it is tab-/comma-delimited; if you find a different delimiter, let me know before proceeding).
• Importing all columns into a worksheet named “RawData.”
• Creating a second worksheet, “SortedData,” that shows the same content ordered by the chosen numerical field (ascending by default—confirm if descending would serve the data better).
• Verifying totals or counts match between the two sheets to prove nothing was lost in translation.
Deliverable: a single .xlsx file that opens in the latest Excel desktop version without compatibility warnings.
If you automate the task, note the script or macro you used so I can reuse it on future files. Happy to answer any structural questions about the TXT file as soon as you review it.
Please handle:
• Reading the TXT file (it is tab-/comma-delimited; if you find a different delimiter, let me know before proceeding).
• Importing all columns into a worksheet named “RawData.”
• Creating a second worksheet, “SortedData,” that shows the same content ordered by the chosen numerical field (ascending by default—confirm if descending would serve the data better).
• Verifying totals or counts match between the two sheets to prove nothing was lost in translation.
Deliverable: a single .xlsx file that opens in the latest Excel desktop version without compatibility warnings.
If you automate the task, note the script or macro you used so I can reuse it on future files. Happy to answer any structural questions about the TXT file as soon as you review it.