Skip to main content
You no longer need this workaround to get an Excel file. lobstr.io exports directly in Excel (.xlsx) — just pick Excel in the download menu when downloading your results. This guide is only useful for converting CSV files you’ve already downloaded.
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, select Excel (.xlsx) as the format when downloading results — no conversion needed. And to push results to a spreadsheet automatically after every run, set up the Google Sheets export integration.