Skip to main content
Have you tried opening a CSV file of scraped data in Excel, only to get a bunch of unreadable, cramped data?
A CSV file opened with Excel looking terrible
The reliable fix is to route through Google Sheets first, which handles the import correctly and then lets you download a clean .xlsx file.

​
Step-by-step instructions

1

Create a Google Spreadsheet

Open the Sheets home screen at sheets.google.com and click + to create a new blank spreadsheet.
Click the + button to create a new spreadsheet
2

Upload the CSV

Click File, then Import.
Click File and Import
Click the Upload tab, then Browse and choose the CSV file you downloaded from lobstr.io.
Click Upload and Browse
Click Import data. Google Sheets creates a new file with each column properly separated.
Click Import data
3

Export to Excel format

Click File → Download → Microsoft Excel (.xlsx).
Click File > Download > Microsoft Excel
An Excel file downloads to your computer. Double-click to open it — you now have a clean, structured, reliable Excel file.
Excel file looking way better
If you regularly need your data in Excel, set up the Google Sheets export integration. Results are pushed to your spreadsheet automatically after every run, and you can always download the sheet as Excel from there.