Convert Tab File to Excel
Budget: ₹600 – ₹1,500 INR
I have a text file that uses tab characters as its only delimiter, and I need every record moved cleanly into a standard .xlsx workbook. All fields must sit in their correct columns, with no extra spaces or hidden characters, and the final sheet should open in the latest versions of Microsoft Excel without prompting for repairs or re-formatting.
Feel free to use whichever workflow you prefer—Excel Power Query, VBA, Python (pandas), or another reliable method—as long as the end result meets these acceptance checks:
• Every tab-separated value occupies its own cell in the worksheet
• Original row order is preserved exactly
• Header names (if present) stay intact and remain in row 1
• No data loss, truncation, or encoding issues appear when I spot-check the delivered file
Please return the finished .xlsx file along with a brief note describing the steps or script you used so I can replicate the process in the future if the source text updates.
Feel free to use whichever workflow you prefer—Excel Power Query, VBA, Python (pandas), or another reliable method—as long as the end result meets these acceptance checks:
• Every tab-separated value occupies its own cell in the worksheet
• Original row order is preserved exactly
• Header names (if present) stay intact and remain in row 1
• No data loss, truncation, or encoding issues appear when I spot-check the delivered file
Please return the finished .xlsx file along with a brief note describing the steps or script you used so I can replicate the process in the future if the source text updates.
Related categories:
Python
Visual Basic
Data Processing
Data Entry
Excel
Excel VBA
Data Analysis
Data Management