Skip to content
Export and delivery

Convert a lobstr.io CSV export into an Excel spreadsheet

Open lobstr.io CSV exports cleanly in Excel using Google Sheets as an intermediary — three simple steps to get a properly formatted spreadsheet.

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).

    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.