Text File to Excel Conversion Open

Job ID: 39888875

Budget: $250 – $750 USD

Open
Posted
Paid on delivery

I have a plain text file (PLEASE CONFIRM YOU HAVE READ THIS AND THAT YOU HAVE VIEWED THE ATTACHED FILE) that stores one data entry per line, and I need those records laid out cleanly in a spreadsheet (Excel or Google Sheets). The file’s exact delimiter isn’t clear to me, so the first task is to inspect a sample, identify whether the values are comma-, tab-, or otherwise separated, and then parse it correctly.

Here’s what I’m looking for:
• Detect the delimiter and confirm the field structure.
• Convert the full dataset into a tidy spreadsheet.
• Preserve any header information or, if none exists, create logical column headers based on the data.