Why does OnCrawl use CSV files?

Because of the size of many websites, OnCrawl offers data in CSV format. Unlike most spreadsheet formats, this means that the file you download is lightweight and useable, no matter how many lines and columns of data it includes.

CSV files are text files that use pre-specified characters to separate rows (new lines) and columns (commas or semicolons). This makes them compatible with spreadsheet software, as well as with any other application you might want to use to handle them.

Here are two ways to open a CSV file in Excel to preserve the data in table format.

Method 1: Open the file with Excel

When to use this method:

  • Your file does NOT contain any special characters (non-Latin alphabets, accents...)

How to do it:

  1. Right-click on your CSV file and choose "Open with...". Then, select Excel.
  2. Look at one line of data. Make sure that the character that separates the data in each column is a semicolon (;). This is standard for OnCrawl exports. Remember this for later.
  3. Under the "Data" menu, select "Text to columns".
  4. On the first screen, choose "Delimited" and click "Next".
  5. Change the delimiter to a semicolon: untick the "Tab" checkbox and tick the "Semicolon" one instead. Click "Next".
  6. Optional: Click on each column to set the type of data that you can find in the column.
  7. Click "Finish".

Method 2: Import the file as data into Excel

When to use this method:

  • Your file contains special characters (non-Latin alphabets, accents...)

How to do it:

  1. Open Excel.
  2. Switch to the Data ribbon at the top of the application.
  3. Choose the type of data to add:
    PC: Click "Get and Transform Data" and select "From Text".
    Mac: Click "From Text" (second button from left).
  4. Choose your CSV file.
  5. On the first screen, choose "Delimited".
  6. Change the "File origin" to "Unicode (UTF-8)" and click "Next".
  7. Change the delimiter to a semicolon: untick the "Tab" checkbox and tick the "Semicolon" one instead. Click "Next".
  8. Optional: Click on each column to set the type of data that you can find in the column.
  9. Click "Finish".

You can also find this article by searching for:

decode characters export

Did this answer your question?