Spreadsheet issues

Encountering issues trying to view your results CSV? This article should help you! 

  1. My spreadsheet is too big 
  2. All my data is in one column
  3. Data/special characters are not displayed correctly
  4. I don't see all my data

 

1. My spreadsheet is too big

Often with scraping, you're dealing with pretty large numbers when it comes to output data. If this is the case, you may have encountered problems with opening your results file across different programs:

  • The IMPORTDATA function in Google Sheets has a relatively low maximum capacity
  • Google Drive can't open an imported file over a certain size
  • Apple Numbers can't handle spreadsheets over a certain amount of cells

From our experience, the best solution is to use Apache OpenOffice - it will allow you to open large files super easily and without any distortion!

 

2. All of my data is in one column

If you're a Mac user, you might have experienced this particular problem. If your file is too large, Apple Numbers merges all of your data into one column. So again, in this is the case you should try using Apache OpenOffice instead.

You might have also come across this problem when using Zapier to send your output data to Google Sheets. If so, please check our how-to Zapier article for help in setting up your Zap correctly.

 

3. Data/special characters are not displayed correctly

When opening CSV files with Microsoft Excel, the data does not convert cleanly. Problems can include cells being separated in the wrong places and special characters such as accents (e.g. â, é, ö) being distorted.

To correctly display CSV files on Excel, you should go to Data -> Get Data -> From File -> From Text/CSV, then import the file using the UTF-8 Format with the Comma as Delimiter. You can find many online tutorials to help you if you're having trouble with this.

Alternatively, special characters will be well handled if you use the IMPORTDATA function in Google Sheets.

 

4. I don't see all of my data

Certain Phantoms may display a limited amount of certain data points in your output CSV instead of the entirety (e.g. with LinkedIn Profile Scraper you will only see a couple of the user's previous jobs instead of all of them). In these instances, your JSON file will display all of the data.

If you would like these in spreadsheet form, you can use a JSON to CSV converter.

Was this article helpful?
1 out of 12 found this helpful