The problem with many CSV files
A shop, a bank or a till may give you one CSV for each month. Twelve files mean twelve windows and twelve charts. One workbook is easier to read, share and keep.
Quick steps
- Open CSV to Excel.
- Add every CSV file at once.
- Check the separator. The tool detects it for you.
- Pick the header row option if your files have one.
- Download the workbook.
One sheet for each file
Each CSV becomes its own sheet. The sheet name comes from the file name, cut to the 31 characters Excel allows. If two names match, the tool adds a number.
Commas, tabs and semicolons
Exports use different separators. The tool checks the first lines and picks the one that repeats. You can also set it by hand. A tab file from a database works the same way as a comma file.
Keep long codes as text
A postcode, a card number or a product code can start with zero. Excel may turn it into a number and drop the zero. Tick the text option to keep every digit.
After you download
Open the workbook and check three things. The first sheet has the right columns. The row count matches the old file. Long codes still start with zero. If something looks wrong, the old CSV is still on your disk.
Limits and privacy
Each file can be up to 30 MB. The browser reads the CSV files and writes the workbook on your device. Nothing is uploaded and no account is needed.
Found this useful? Browse the free tools or suggest the next guide.